Forum Discussion
Hi kiwivideo1
I suggest you first manually enter 2 typical invoices like you are trying to import. Export those 2 invoices. Use the export file as your import template. Follow this exactly.
Not sure what RecordID you are referring to. The Sales Items import RecordID is for the Customer Record ID only, however this is not a required field and if you don't have it, don't use it. Use Co./Last Name or CardID to match the customer cards instead. Don't use all 3, use one only, unless you have customers with same name.
If the customer card does not exist, the import will fail. Items are identified by Item Number, not Record ID.
Regards
Gavin
- kiwivideo12 years agoContributing User
Many thanks for your quick reply, Gavin. Sorry MINE was delayed! I had in fact been doing that after I posted the question and before your reply came in. Issue resolved. It was actually the Item Number field which was missing - because they were dummy records being imported for other purposes, and weren't created through the normal process. However, it's great to know there IS somewhere in the MYOB universe where quick responses can be received. Again, much appreciated!
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
Find technical support and help for all MYOB products in our online help centre
Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.