SL93 said:

"4020","2","150.00","150.00","H","0","1","13.00","19.50"

Probably should be more like

"4020","2","150.00","150.00","HST","0","1","13.00","19.50"

assuming a standard setup of Ontario HST.

You didn't give us the Taxes image so we don't know what your taxes are called.  I just opened a file I have here and the tax name is GST/HST.  I doubt you have a tax called H and a tax code called H.

The reason why different answer may not help you is because the settings for the area you highlighted plus the Tax name "H" can be completely different between different company files.  Not everyone has HST 13%.  Many eastern provinces are HST 15%, western provinces don't have HST so unless they sell East, they won't have it in their file.

Thanks for the reply - I did attach the image, not sure why it won't show. In Sage: Setup - Settings - Company - Sales Taxes - Tax Codes : Code names are H (tax ontop) and HI (tax incl) (unless we're pulling the wrong 'codes' and these need to be the 'tax name' instead?)

We have tried the "HST" several ways and it still shows the same error message. We understand the varying inputs for taxes - even have 2 programmer sets of eyes on this and they're stumped - hence why we're here! :)

found it. It's under 'Taxes' not 'Tax Codes' and it wanted the name of it "GST/HST", whereas we were entering the code names - thanks!

That's what I said.

Richard S. Ridings said:

You didn't give us the Taxes image so we don't know what your taxes are called.

Glad you got it working.

Yet another error message. "The number of detail lines does not match the actual number of lines."
Same syntax as pasted before with the exception of "GST/HST" being changed, blank line after </SalInvoice> as you typically suggest. Any thoughts?

You only have four line items but indicated 5.

"5","C000004","4","06-26-2023","0","30 days","788.23","0"

Some of the messages actually do tell you what the problem is :)

Your next error message is that your total is out of balance with the line items.

"5","C000004","4","06-26-2023","0","30 days","788.23","0"

When using Pay Later, this 30 days text is not required as it is not a paid by source (eg. cheque number or credit card name set up in your system).  It looks like you tried to put terms in here but that is not what this field indicates.

Didn't get the error message you suggested; changing it to 4 worked - this will have to be changed by our programmer on the export template file.
Appreciate the help & the sarcasm! Cheers

I'm surprised you didn't get an imbalance issue.  When I calculated it, the total was 788.24.  Your entry said $788.23.  Check the journal entry and invoice lookup after import to make sure the import didn't change it to something you don't want.  I haven't imported with this type of file in a couple of years but it's been a lot longer since I validated the import process.  It may recalculate the total now based on line item dollars.