Once a MYOB instance has been connected to a Workbench FinCo in the WebWorkbench MYOB Integration screen, there are still some steps to take to enable the two system to integrate correctly.

Configuration

MYOB Category

On MYOB, create a new category called WBI. This category will be entered in MYOB Integration screen. 

Open

Open

Workbench Control Parameters

The following Control Parameters with the Parameter Type of "Interface" should be specified. Search for Parameter name like Interface, and they will come up on the results:

Interface Job Integration
Interface Location Code
Interface PersonID
Interface Template Company ID
Interface Zero Rate Input GST Type
Interface Zero Rate Output GST Type

Interface Job Integration

There are two options:

• None - all data is posted to MYOB with no job specified.

• PC Prefix - data is posted to MYOB with the Job populated with the "PC Prefix" of the Workbench job's profit centre.  With this option, each profit centre in Workbench corresponds with a job in MYOB, and so reporting can be generated from MYOB based on Workbench profit centres.

Interface Location Code
A valid Location Code which is used when creating system batches for data imports.

Interface PersonID
A valid PersonID which is used when creating system batches for data imports. This will normally be automatically populated, with a personID from a People record with Fullname 'Workbench Interface', created by the install scripts.

Interface Template Company ID
The CompanyID of a Company in Workbench which is used as a template to populate required data which is not supplied from MYOB.

Interface Zero Rate Input GST Type
 A MYOB Tax Code with a tax rate of zero.  This is used to populate the Tax Code on AP Invoice lines with no GST when exporting to MYOB.

Interface Zero Rate Output GST Type
 A MYOB Tax Code with a tax rate of zero.  This is used to populate the Tax Code on AR Invoice lines with no GST when exporting to MYOB

select * from workbench.dbo.ControlParameters
where parametername in (
'Interface Job Integration',
'Interface Location Code',
'Interface PersonID',
'Interface Template Company ID',
'Interface Zero Rate Input GST Type',
'Interface Zero Rate Output GST Type'
)

Coding

GL Codes

The GL Codes in Workbench should be in the format X-XXXX (e.g. 1-4300).  Some Workbench systems integrating with MYOB with file transfers may have been configured with GL Codes without the hyphen (e.g. 14300).  In this case the existing GL Codes will need to be changed in Workbench to include the hyphen.  To facilitate this, a script called wbReconfigureMYOBGLCodes.sql is provided. Executing this script on the Workbench database will insert the missing hyphen into all the GL Codes specified on the following:

• Activities

• EmployeeClasses

• Sales Codes

• Jobs

• Plant Rate Codes

Additionally, each Financial Company in Workbench should be checked to ensure that any GL Codes specified there are hyphenated correctly.

This GL Coding regime assumes that GL Codes are always fully specified in Workbench, and the GL Prefixes or Suffixes on Profit Centres are not used.

Tax Codes

The GST Type Codes in Workbench need to match the corresponding Tax Codes in MYOB.

Companies

The Card ID on Customers and Suppliers in MYOB corresponds to the AR Account and AP Account respectively of Companies in Workbench. The sync include inactive contacts when importing/syncing from MYOB, so if a Contact is flagged as inactive in MYOB, it will become inactive in Workbench.

Syncing

On the MYOB Integration screen in Workbench there is an option to manually sync data from MYOB to Workbench.  This data includes Companies (Customers and Suppliers), Job Receipts and Payments, Leave Balances, and GL Accounts. An initial sync should be performed to bring the Customers and Suppliers into Workbench from MYOB.   Check that the "Interface Template Company ID" control parameter in Workbench is specified and maps to an appropriate Company record.

There is an automated task that is scheduled to perform an import weekly, every Monday between midnight and 1am. This will import:

• Job Receipts and Payments that have a date within the last 40 days. Note that these documents do not have a 'Last Updated Date'.

• Companies and their Contacts that have been created or updated within the last 40 days.

• GL Accounts and Leave Balances. All of them as these have no associated dates.

The Import button will perform an immediate sync with MYOB, in those cases you want to import any of the above and you cannot wait for the weekly task to run. Last Update date will display the last time the import was executed.

Code Validations

Also on the MYOB Integration screen are options to validate some of the coding.

Validate Companies

This looks at all the AR Account Codes and AP Account Codes on Workbench Companies, and checks that there are matching Customer and Supplier records in MYOB.  If all the Companies on Workbench have been imported from MYOB, then there should not be any.  Any discrepancies are displayed.

Validate Accounts

This looks at all the GL Codes where they are specified in various places in Workbench, and checks that there are matching GL Accounts in MYOB. Any discrepancies are displayed.

Special Mapping

Analysis2 code 

When updating MYOB from Workbench with the Analysis2 code:

• populate the Job in MYOB, if it exists, don’t validate

• populate the Category in MYOB, if it exists, otherwise use the MYOB Category setting