Hi Mazzii1,
Thanks for your response.
May I ask if the items in question are all active? Also, may I ask for a copy of the import file?
We look forward to your response.
Cheers,
Genreve
Hi Genreve_S
Yes they are all active. We've only just come over to MYOB in July.
The sample file is in my original post above. Let me know if you can't see it.
Cheers,
Mazzii
Hi again Genreve_S
I can't seem to get my head around the issue. I tried removing things like Billed, and Received, I tried creating a new Item number. None of them worked.
Attached is the most recent import log and the issue seems to be around the top 10 lines there. The lines where there is a 2 1 2... etc on the left side of the description. If that is how we're meant to read the log file!?
Thanks,
Mazzii
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
