Forum Discussion
- Mike_JamesUltimate Cover User
Hi PrimeProducts , there are several ways to go about this in AccountRight:
- manual import using the import/export wizard. For this to work, your orders file need to have columns to match MYOB's requirements. The best start point is to export some existing sales orders/invoices, with all columns, and align your excel order file and data to match. (Customer names need to match MYOB). Then save the excel file as a txt file (tab-delimited would be my preference) and try a manual import. Backups before importing are vital, until you get used to the process.
There is a big learning curve with manual imports, but if it works, it's a free solution. - Second option is to try using an add-on program like Transpost (transpost.com.au), which is a clever program to streamline the import process. Orders would be posted via the API to your MYOB file. There would be a charge for this program.
- Third option is to have a developer like us write a custom import program using your excel file as is. Orders would be posted via the API. This option is probably more expensive but very tailored.
- manual import using the import/export wizard. For this to work, your orders file need to have columns to match MYOB's requirements. The best start point is to export some existing sales orders/invoices, with all columns, and align your excel order file and data to match. (Customer names need to match MYOB). Then save the excel file as a txt file (tab-delimited would be my preference) and try a manual import. Backups before importing are vital, until you get used to the process.
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.