Import Templates - Technical

Owned by Former user (Deleted)
Last updated: May 30, 2012Version comment
4 min read

MYOB Service Sales Import Template (NZ)

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 Service Purchases Import Template (NZ)

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


MYOB Transaction Journals Import Template

MYOB Import Fields

 

Used in WB

Journal Number

Workbench Batch Number

Yes

Date

Batch Date

Yes

Memo

Dependent on the transaction type

Yes

Account Number

MYOB Account Number

Yes

Debit Amount

Debit amount

Yes

Credit Amount

Credit amount

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

Currency Code

If WB Multi currency switched on then use Local Currency Code else null

No

Exchange Rate

If WB Multi currency switched on then use '1' else null

No

Allocation Code

Dependent on the type of transaction. Usually the Workbench Job Number

Yes

Category

Dependent on the type of transaction. See set up

Yes