Hi Mazzii1
Suggest you spend some time reading here:
There is nothing intuitive here - you must follow the rules. My guess is your previous imports that worked did not include Item GPS+UTS - attach a screenshot of profile tab.
The best advice one can give with learning how to import into MYOB is to first manually enter into MYOB 2 or 3 typical Invoices or Bills you are wanting to import. Export those 2-3 Invoice/Bills. This export file becomes your import template - showing format layout and order MYOB is expecting for the import. Do not deviate until all imports are successful. Then you can experiment with changes. Also practise locally on a copy of your file. Imports cannot be 'undone'.
Regards
Gavin
Hi gavin12345
Thank you for responding.
I have read through these and definitley used the same template from the first sucessful one. Obvsiouly the item numbers change as they are specific to each supplier. Hence why I set them up that way.
Thank you for pointing that out. I updated the items with symbols in MYOB and the imports and that seems to be working.
The other issue that I don't get is, the Billed and Received amounts are not importing. Do you know why that is? I've changed all the columns to General because I read that the files will only import that way. Just tried and changed the heading to Quantity - that caused an error. Changed back to Billed then formatted to Number with 2 decimals - still didn't work.
Any suggestions are appreciated.
Cheers,
Mazzii
