(This page is under construction, click here to see legacy documentation.)

IN PROGRESS

Workbench integrates with MYOB Advanced using the MYOB Advanced API. This document explains how to configure the integration between the two systems. This includes:

• Export of batches of Job cost financial data from Workbench to MYOB Advanced financials (Accounts Payable/Accounts Receivable/General Ledger/Timesheets/Journals)

• Import of various master data into Workbench from MYOB Advanced.

• Import of Job Receipts (AR) and Payments (AP).

This document outlines the different models of configuration in MYOB Advanced for new Workbench clients.
The below displays the configuration of Master files between the two integrated systems.

Model 1
In the below case, there is a requirement for 1 x Masterfile in MYOB Adv. accommodating multiple financial companies in Workbench.
MYOB Advanced Customers (AP) Workbench Suppliers (AP)
Bunnings – 1 x Masterfile record. Bunnings - Financial Company = 01
Bunnings - Financial Company = 02
Bunnings - Financial Company = 03

Model 2
In the below case, there is only a need for the below customer to be transacted for Financial Company 01 and 02, not 03.
MYOB Advanced Customers (AR) Workbench Companies (AR)
Melbourne Water – 1 x Masterfile record. Melbourne Water - Financial Company = 01
Melbourne Water - Financial Company = 02

There are two Models in Workbench for integrating with MYOB Advanced, they are:

• One Legal Entity (Model 1).

• One Legal Entity with Multiple Branches (Model 2).

The integration configuration is a task most likely performed by a Workbench Support Consultant. If you are looking for FAQs or troubleshooting an error please check the MYOB Advanced FAQs page under this same section.

Preparation work:

1- Important terminology to be familiar with in MYOB Advanced.

Workbench | MYOB Advanced

• Financial Companies | Companies

• Profit Centre | Branches

2- Find out the MYOB Dealer contact.Before the integration configuration can start, the MYOB Advanced dealer must import the Workbench-MYOB Advanced customisation package into MYOB Advanced. Send them the latest version of the .zip file (that contains a .xml file in it) with the customisation.

Customisation files are kept here. Note that only Workbench employees can access this. A Customer Support Consultant will provide this file to the MYOB Dealer.

3- Request the Dealer to provide an MYOB user with the ‘full user API’ licence. This will give you access to all you need. Later on, once the integration is up and running the Dealer might decide to change the user’s licence to one that has less access but still allows the integration to work as expected.

4- You need to know what MYOB Advanced Company Type the financial entity is set to in MYOB, as this will be needed to set the 'Model' option in Workbench as part of the integration setup.
If the Client is using multiple branches, ask the client or the MYOB Dealer if they are wanting to integrate with their branches as well. This would be Model 1 2 described above → One Legal Entity With Multiple Branches

Otherwise, it would be model 1 = One Legal entity.

The setup stage:

1. Customisation package sent to Dealer and imported into MYOB Advanced. Ensure the client is kept in the loop of all communications between you and the MYOB Dealer.

2. In Workbench -> Navigate to the MYOB Advanced Integration screen. Refer to the below field fields that need mapping:

   In MYOB adv -> Log in using the user given to you (assuming license

   • Select your Financial Company

   • Enter the URL for the MYOB Advanced instance.

   • Enter in Username and password of the user that will be integrated between MYOB and Workbench. Must be a user with enough access to do all the configuration (user with the ‘full user API’ licence).

   • Enter the MYOB Branch: The Branch in the Branch (MYOB is the Profit Centre Code In Workbench. It can be the defaulted default Branch that they use )

   • Check Model (with reference to MYOB adv companies screen or ask your client / their dealer)

   • Check their Tax Category (with reference to MYOB adv screen)

3. In GST Types configure GST codes as per MYOB adv GST screen:
   

4. • in MYOB.

   • Select a model, based on how they want to integrate, either using branches or Sub-accounts, as per the explanation in the graph above.

5. Find Tax Categories in MYOB, and open the DEFAULT Tax Category. Use the Tax IDs in MYOB and mapped them to the GST Types in Workbench. Export Codes in Workbench must be populated with the corresponding Tax ID from MYOB. We recommend you copy and paste rather than type to avoid errors. Reciprocal codes are only required if intercompany is used.
   

   Image AddedImage Added

6. In MYOB, log in using the user provided by the MYOB Dealer. Assuming the licence is set up correctly, you should be able to access their the client’s company database.

   URL (address):

   1. Verify the MYOB Company (financial entity) type.

7. The screenshot shows company type -> by searching in the magnifying glass icon -> search 'Companies' -> select Configuration ->  Companies

   so follow mini video:

   
   

   Image Added

Overview:

Screen Guide:

Next Steps: