Chapter 12 - Invoicing > Transfer to Myob

MYOB has some unique limitations with transfer of transaction information to MYOB Invoices.

Firstly, unless client ID numbers have been setup - MYOB uses the client company name as the mechanism to match accounts. This process is also case sensitive so special care must be taken to ensure the account names are identical between ManStat and MYOB.

There is one exception to this rule. Any account name in ManStat that contains an asterisk will ignore text from the asterisk onwards.

The following examples will all transfer to the same MYOB Card : ACME Pty Ltd

ACME Pty Ltd * Sydney

ACME Pty Ltd

ACME Pty Ltd * Project B

If not using card ID in MYOB the last two items must be de-selected after using Match All in MYOB import, otherwise import may fail regardless of match settings.

If using Card ID then deselect company name and Record ID

Client specific cost centre override possible for MYOB export

Sales Fields - Item

Field descriptions for importing and exporting

Field

Manstat Equivalent

Description and Character Limits

^Co./Last Name

CompanyName

When importing, must match a preexisting card in your MYOB Premier company file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric.

NOTE: To match a preexisting card designated as "Individual", MYOB Premier requires both the last and first names.

First Name

20 characters, alphanumeric.

Addr 1
- Line 1
- Line 2
- Line 3
- Line 4

Total Address field (lines 1 to 4) cannot exceed 255 characters, alphanumeric.

Inclusive

1 character alphanumeric indicates the amount is tax-inclusive.

Invoice #

Invoice Code

8 characters, alphanumeric

Date

Invoice Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

Customer PO

Order Ref

20 characters, alphanumeric

Ship Via

20 characters, alphanumeric

Delivery Status

Always A

P=To be Printed
E=To be Emailed
B=To be Printed & Emailed
A=Already Printed or Sent

If field is left blank, the field will be set to P=To be Printed

*Item Number

Product Accounts Code

30 characters, alphanumeric. When importing, must match an preexisting item in the MYOB Premier company file.

Quantity

10 characters, numeric - allows 3 decimal places and decimal point.

Description

255 characters, alphanumeric

Price

Product Unit Price

11 characters, numeric, including 3 decimal places

Inc-Tax Price

Extended Price

15 characters (including 2 decimal places). If more than 2 decimals, MYOB Premier rounds to 2 decimals.

NOTE: Importing and exporting currency amounts

Discount

10 characters, numeric, including 2 decimal places

Total

Line Total

15 characters (including currency signs and negative signs) from the Dollars amount field.

NOTE: Importing and exporting currency amounts

Inc-Tax Total

Line Extended Total

15 characters (including 2 decimal places). If more than 2 decimals, MYOB Premier rounds to 2 decimals.

NOTE: Importing and exporting currency amounts

Job

Cost Centre

15 characters, alphanumeric. When importing, must match preexisting job number in the MYOB Premier company file. Manstat can optionally send the actual ManStat Job Code, please consider the practical limitations of this option before implementing.

Comment

255 characters, alphanumeric

Journal Memo

255 characters, alphanumeric

Salesperson Last Name

31 characters, alphanumeric. When importing, must match the name of an employee card in the MYOB Premier company file.

Salesperson First Name

20 characters, alphanumeric.

Shipping Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

Tax Code

3 characters, alphanumeric. When importing, must match a preexisting tax code in the Tax Code List.

Non-Tax Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB Premier rounds to 2 decimals.

NOTE: Importing and exporting currency amounts

Tax Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB Premier rounds to 2 decimals.

NOTE: Importing and exporting currency amounts

LCT Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB Premier rounds to 2 decimals.

NOTE: Importing and exporting currency amounts

Freight Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB Premier rounds to 2 decimals.

NOTE: Importing and exporting currency amounts

Inc-Tax Freight Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB Premier rounds to 2 decimals.

NOTE: Importing and exporting currency amounts

Freight Tax Code

3 characters, alphanumeric. When importing, must match a preexisting tax code in the Tax Code List.

Freight Non-Tax Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB Premier rounds to 2 decimals.

NOTE: Importing and exporting currency amounts

Freight Tax Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB Premier rounds to 2 decimals.

NOTE: Importing and exporting currency amounts

Freight LCT Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB Premier rounds to 2 decimals.

NOTE: Importing and exporting currency amounts

Sale Status

1 alphanumeric character. Letter "O" indicates an order; Q indicates a quote. Any other character or blank indicates the sale is an invoice.

Currency Code

3 characters, alpha. One code per sale/purchase. When importing, must match a preexisting currency code in the Currency List. Must match customer/supplier currency code.

Exchange Rate

11 digits, including 6 decimal places. If blank, current exchange rate substituted.

Terms
- Payment is Due

1 character, numeric. Use one of these codes to indicate when payment is due:
0 - COD
1 - Prepaid
2 - In a Given # of Days
3 - On a Day of the Month
4 - # of days after EOM
5 - Day of Month after EOM

- Discount Days

3 characters, numeric, based on Payment is Due code:

•	If code 0, 1, 2 or 4 indicates when payment is due, use a number of days from 0-999.

•	If code 3 or 5 indicates when payment is due, use a date from 1-31. (EOM=31)

- Balance Due Days

3 characters, numeric, based on Payment is Due code:

•	If code 0, 1, 2 or 4 indicates when payment is due, use a number of days from 0-999.

•	If code 3 or 5 indicates when payment is due, use a date from 1-31. (EOM=31)

- % Discount

2 numeric characters to the left of the decimal point and 2 numeric characters to the right of the decimal point (example: 00.10).

- % Monthly Charge

2 numeric characters to the left of the decimal point and 2 numeric characters to the right of the decimal point (example: 00.20).

Referral Source

20 characters, alphanumeric.

Amount Paid

15 characters (including 2 decimal places). If more than 2 decimals, MYOB Premier rounds to 2 decimals.

NOTE: Importing and exporting currency amounts

Payment Method

20 characters, alphanumeric.

Payment Notes

255 characters, alphanumeric. Available only if a Payment Method is entered.

Name on Card

50 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered.

Card Number

25 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered.

Expiry Date

10 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered.

Authorisation Code

255 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered.

BSB

25 characters, alphanumeric. Only available for cheque payment method type.

Account Number

25 characters, alphanumeric. Only available for cheque payment method type.

Drawer/Account Name

32 characters, alphanumeric. Only available for cheque payment method type.

Cheque Number

8 characters, alphanumeric. Only available for cheque payment method type.