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.


    • Related Articles

    • Gearbox WIISE Integration with Purchase Orders

      Overview Gearbox integrates with WIISE by pushing and updating Purchase Orders created in Gearbox to WIISE. When a Purchase order is completed in Gearbox, the user clicks on Export To WIISE button. If the purchase order is edited after the export, ...
    • Exporting Purchase Orders & Tracking Categories in Xero

      Purpose To provide instructions on how to export Purchase Orders from Gearbox to an integrated Xero system. Xero must be integrated prior to exporting Purchase Orders. Xero has a 30 min timer on session tokens which may result in additional login ...
    • MYOB API Integration

      Overview Gearbox exports Purchase Orders into MYOB through API, enabling seamless synchronization of data between the two platforms. You must be an Administrator within Gearbox and have a MYOB account created before proceeding. MYOB Integration 1. ...
    • Purchase Orders

      Overview Gearbox uses Purchase Orders to order and receive Parts into Stock. If you do not wish to use the Purchase Order component of Gearbox, the only way to add Stock is through Stock adjustments. Purchase Orders require the Parts and Inventory ...
    • Xero integration with 2-Factor Authentication

      Overview Gearbox facilitates the seamless export of Purchase Orders into Xero, via a user-triggered API. This integration allows users to efficiently transfer Purchase Order data from Gearbox to Xero, streamlining the process of managing financial ...