Thanks Doreen_P
There are no quotation marks that have been added as I didn't use excel. As you can see from the error log there is nothing here. From what I can see the customer name & also the Tax code have been converted to a number however these are formatted as plain text fields so unsure why this is coming through as a number. I'm not sure if this is what is pulling the invalid amount error or not?
Hi Amber_BIBS
If you open this in excel, this is what you see - 0.1 on column O is in wrong place. If price is 390.34, the GST and the Inc-Tax Total should be much higher than 0.1 and 1.1 - I would suggest these are the amounts that are out. Rather than 0.1 work out the GST amount, and the tax inclusive amount. MYOB does not use formulae in imports, you need to import the data.
Best approach is to manually enter the transaction (or a sample), then export. This will show you how to correctly prepare import, including {} on line one if required.
Regards
Gavin
