Try 12001 or even 9001

Hmmm.  12001 seems to work but now I'm getting "line 6 does not contain a valid total amount."

Any idea where I can get more info on how to format this file?  Sage help is not very helpful.  A sample file would be very helpful.

Thanks,

Garry

You can always use the Knowledgebase article called "How do I import transactions into Sage 50 using a .IMP file format?".  It has the formats you are currently using and some samples, though not a specific sample of Purchase Invoice format.

I am not sure the total in your sample is incorrect, however you have what appears to be a Sage 50 sales tax code, GI listed that has no place in the file.  That GI on line 6 I am assuming means there is GST included in the $24.94 but in reality you are entering it in the area for Freight Sales tax.

Sales tax is very picky.  See the example line item from the sample SalInvoice in the Knowledgebase article.

"C1020","2.0000","4.7500","9.50","GST","0","1","7.00","0.67","PST","0","0","7.00","0.67"

This line refers to the item C1020 and is selling 2 at $4.75 each for a total of $9.50.  Now the rest of the line is the Sales tax information.  It is the calculation, not the tax code.  GST is not include (0) but is refundable (1) at a rate of 7% for a total of $0.67 on the $9.50.  Same for PST.  If you want GST included, it is GST,0.  You must have a tax called GST in your Sales tax setup in your file.  If your tax is called GSTAB, then use that.

In the PurQuote example in the article you will see there is only GST calculated on the Freight and GST and PST on the line item and none of the sales taxes are included in the prices listed.