Page Comparison

MYOB Import fields

Used in WB

Co./Last Name

We are linking and validating on the CardID only

If the name exists in the file the import uses it for validation as well and it must be exact.

Not after June 07 and MYOB V10

First Name

Addr 1 - Line 1

• Line 2

• Line 3

• Line 4

Invoice No.

Invoice number

Yes

Date

Invoice Date. Note that this date triggers the period allocation in MYOB. The WB Batch date is not used. Export will abort and error if Transaction date is outside the WB batch date.

Yes

Customer PO

Ship Via

Delivery Status

Hard Coded 'A'

Description

Sales Code Description

Account No.

MYOB Account number from WB Sales Code

Taken from the Job Invoice Line

Amount

FC GST Exclusive Amount

Inc-GST Amount

FC GST Inclusive Amount

Job

This is the MYOB job. It validates this field.
If the User requires Profit Centre reporting in MYOB this field is utilised. Set up jobs in MYOB to equate to the Profit Centre or the Job Suffix on the Profit Centre.
Where Profit Centre reporting is used in WB and this is being mirrored in MYOB, the MYOB job number is the WB Profit Centre or the Job Suffix on the Profit Centre.

This must be set up in the Control Parameter

Comment

Batch Number; WB Job Code; Sales Code

Journal Memo

WB Job Name

Slsmn Last Name

Slsmn First Name

Shipping Date

GST Code

Workbench GST code is used

Yes

GST Amount

FC GST Amount

Freight Amount

Freight GST Code

Freight GST Amount

Sale Status

Currency Code

Currency Code from the JobInvoice. Note that in MYOB the Card can only be in one currency. Any import of value into that Card is assumed to be at the Currency Code of the Card.

Yes

Exchange Rate

Exchange Rate from the APInvoice.

Yes

Terms - Payment is Due

'4' is hard coded into the export

• Discount Days

• Balance Due Days

• % Discount

• % Monthly Charge

Referral Source

Amount Paid

Payment Method

Payment Notes

Name on Card

Card Number

Expiration Date

Authorisation Number

Cheque Number

Inclusive

Category

Card ID

The WB Client Account Number


Make sure that this number is not duplicated anywhere in either AR or AP.

1

Record ID

Don't Use

MYOB Import Fields

Used in WB

Co./Last Name

We are linking and validating on the CardID only

If the name exists in the file the import uses it for validation as well and it must be exact.

Not after June 07 and MYOB V10

First Name

Addr 1 - Line 1

• Line 2

• Line 3

• Line 4

Inclusive

Purchase OrderNo.

MYOB validates this number and it cannot be duplicated.
If WB PO is '0' then APInvoice ID
If WB PO <>'0' then use PO and put 2 alpha on the end randomly generated to increase chance of non duplication.

Yes, if AP is attached to a PO.

Date

Invoice Date. Note that this date triggers the period allocation in MYOB. The WB Batch date is not used. Export will abort and error if Transaction date is outside the WB batch date.

Yes

Supplier Invoice No.

Invoice number

Yes

Ship Via

Delivery Status

Hard Coded 'A'

Description

WB Detail from the AP Line transaction.

Plus another possible 4 fields. See Control Parameters

Yes

Account No.



MYOB Account number from WB Activity Code

Held on the Job Transaction.

Yes

Amount

GST Exclusive amount. Use the FC value

Yes

Inc_GST Amount

GST Inclusive amount. Use the FC Value

Yes

Job

This is the MYOB job. It validates this field. If the User requires Profit Centre reporting in MYOB this field is utilised. Set up jobs in MYOB to equate to the Profit Centre or the Job Suffix on the Profit Centre.

See Control Parameter

Yes

Comment

BatchNumber; PO Number

Yes

Journal Memo

APInvoice (Header) Details

Yes

Shipping Date

GST Code

Workbench GST code is used

Yes

GST Amount

FC GST Amount

Yes

Import Duty Amount

Freight Amount

Inc-GST Freight Amount

Freight GST Code

Workbench GST code is used

Yes

Freight GST Amount

Freight Import Duty Amount

Purchase Status

Currency Code

Currency Code from the APInvoice. Note that in MYOB the Card can only be in one currency. Any import of value into that Card is assumed to be at the Currency Code of the Card.

Exchange Rate

Exchange Rate from the APInvoice.

Terms - Payment is Due

2 This is Hard Coded. It means that it counts the days from the Invoice date

• Discount Days

Yes

• Balance Due Days

Number of Days from the Invoice Date

• % Discount

Amount Paid

Category

WB-API

Card ID

The WB Supplier Account Number


Make sure that this number is not duplicated anywhere in either AR or AP.

Yes

Record ID

Don't Use