Accounts Receivable (Debtors)

Owned by Former user (Deleted)
Last updated: Jan 17, 2017 by Workbench (Unlicensed)

Export Batch/s from Workbench through Batch Control

Import into MYOB. You can only import one Batch at a time.
Go To File\Import Data\Sales\Service Sales

This will bring up an Import File screen. The default is as follows

You must change

  • Tab-delimited to Comma-separated
  • Co/Last Name to Card ID.
  • Duplicate records should always be left as the default "Reject Them". (Refer Page 6).

Press Continue

You will then need to find the TXT file to Import and double click or Open

This will display the Import Data screen.

Click Match All
Press Import
MYOB will display a message to say whether you were successful

Go to the MYOBPLOG.TXT file for an explanation of issues.

Each invoice rejected will have an error.

It is possible to fix the original TXT file and re-import. Be really careful as you are changing the raw data.

Where does the info end up?

  • Comment: Batch & Header Job Number
  • Journal Memo: (Control Parameter gives some flexibility)
  • Description: (Control Parameter gives some flexibility)

MYOB Job Number

Dependent on the Workbench Control Parameter 'MYOB Job Field'
Can be:

  • Null
  • Workbench Profit Centre
  • Job Suffix on the Workbench Profit Centre
  • Workbench Job (not recommended unless there are a limited number of jobs. The job must exist in MYOB before it will populate this field.