Export Purchase Orders to MYOB

Export Purchase Orders to MYOB

Overview

Gearbox allows you to export Purchase orders in MYOB CSV format.

To import Purchase Orders to MYOB you must first setup a purchase account “5-XXXXX” and the Supplier must exist in MYOB (case sensitive). The Card Type must also be set to Supplier, otherwise MYOB will not accept the import.
Screenshot 2016-03-19 09.28.19

To Export Purchase orders to MYOB (Offline Version via a csv file), head to Purchase Orders > Ready to Export.

These are Purchase orders stamped ready to be exported.

Gearbox MYOB Export

Click on the Export MYOB CSV format required (Bill or EXO) to download the text file

Open MYOB and select File > Import/Export Assistant
Screenshot 2016-03-18 21.00.11

Then choose the following settings when completing the import
Screenshot 2016-03-18 21.00.35

Select “Purchases” & “Service Purchases”
Screenshot 2016-03-18 21.01.13

Select the following:
Screenshot 2016-03-18 21.01.32

Select “Match ALL”
Screenshot 2016-03-18 21.01.49

Then Click Import
Screenshot 2016-03-18 21.02.06

Check the log file after the import for any warnings or errors
Screenshot 2016-03-18 21.03.45

Errors identify that the record was rejected (did not import).

Warnings advise that the record was imported however it may not be as expected.