Mr. Mth said:

"1001", , ,"200.00"
"1010", , ,"263.50"

Have you tried

"1001", "", "", "200.00"
"1010", "", "","263.50"

or

"1001", "1", "200", "200.00"
"1010", "1", "263.50","263.50"

Hi Richard,

I did used the last format to be able to import my date, alltough I would prefer not to insert a quantity and a price...

Richard S. Ridings said:

"1001", "", "", "200.00"
"1010", "", "","263.50"

This format is giving me the same error as the format without the quotation marks...  

Thanks for trying though!

I have to admit that with all the imports I've done, I don't recall once not using a quantity and unit price.  I am not sure it is possible.  The dev-import.pdf file does not specifically say they are optional, just not that they are compulsory.

You have to take any information in these files as guidance only, not actual fact.  Even the datadict.pdf file has a few mistakes as well as missing information.  The real information is only available during testing (when you can decipher the error messages).

I was curious how $200 + $263.50 = $999

Hahaha! Good observation!

I wanted to test whether or not the "total amount" was imported or if the wizard would calculate the real total amount by adding the amount of each detail (rows).

Turns out the "total amount" of the imported invoice seems to be calculated at the moment of the importation and thus the field is useless... allthough you do have to specifiy one in your import data...

Same thing for the tax information : my tests show that you have to put the tax information in the "details" rows if you want the imported invoice to list the taxes amount, otherwise, the invoice is imported w/o them.

Recently I was working on a file that consistently imports invoices (not created by me or my programming).  The person who programmed the import format enters the sales tax only on the header row after the Total amount.  They had no clue (or didn't care) that it was being imported as Freight sales tax with a zero dollar amount for Freight costs.

As you said, there is no sales tax on each line but if you look at the journal entry, it is correct for the invoice.  However, I was asked to do some reporting programming for their file and was told they were not using Freight.  I couldn't figure out why everything showed up without tax at the line item level.  After some searching in the database, I found out where the tax was.  The journal entries are all right but I can't tell which tax is applicable to which line item, so we had to modify the requirements to ignore the line item tax.

So yes, if you want the sales tax to show per line item properly, enter it on each line and there has to be a sales tax code in your file with the same tax names and calculation.  Beware of the included vs. excluded flags as well as the refundable vs. not refundable flags.

Well, they (the developpement team at Sage) surely could give more information and, most importantly, more precise information about the import formats.

And they could improve the import utility as well! 

As you said earlier, the only way to really know how this all works is by testing it ourself (and/or asking the community )...

But, well, the important thing I guess is that my colleagues won't have to enter the 3000 invoices manually to Sage!

Well you really are taking away all the fun from those of us who like data entry!