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.