Sales Fields - Service

Importing and Exporting Overview > Importing data into MYOB Accounting Plus > Importing and exporting fields > Sales Fields - Service

Field

Description and Character Limits

*Co./Last Name

Must match a preexisting card in your MYOB Accounting Plus 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 when the designation chosen for the card is Individual, MYOB Accounting Plus requires that you include both the last name and the first name.

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

Invoice No.

8 characters, alphanumeric

Date

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

Customer PO

20 characters, alphanumeric

Deliver Via

20 characters, alphanumeric. If the deliver via method does not exist in the delivery methods list, it will be ignored

Already Printed

1 character. Any non-blank character signifies that the invoice or purchase order is already printed or sent

Description

255 characters, alphanumeric

*Account No.

Must be valid, preexisting MYOB Accounting Plus account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).

*Amount

15 characters (including pound sign, comma and negative sign). If no decimal entered, MYOB Accounting Plus appends .00. If more than 2 decimals, MYOB Accounting Plus rounds to the nearest cent.

Job

5 characters, alphanumeric. Must match preexisting job number in your MYOB Accounting Plus company file.

Comment

255 characters, alphanumeric

Journal Memo

255 characters, alphanumeric

Slsmn Last Name

31 characters, alphanumeric. Must match the name of an employee card in the MYOB software company file.

Slsmn First Name

15 characters, alphanumeric.

Delivery Date

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

VAT Code

3 characters, alphanumeric. Must match a preexisting VAT code in the VAT Code List.

VAT Amount

15 characters, numeric, including 2 decimal places

Carriage Amount

15 characters, numeric, including 2 decimal places

Carriage VAT Code

3 characters, alphanumeric. Must match a preexisting VAT code in the VAT Code List.

Freight VAT Amount

15 characters, numeric, including 2 decimal places

Sale Status

1 character. O indicates the sale is an order, Q indicates the sale is a quote. Any other character or no character indicates the sale is an invoice.

Currency Code

3 characters, alpha. One code per sale/purchase. 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 No. of Days
3 - On a Day of the Month
4 - No. of days after EOM
5 - Day of Month after EOM

- Discount Days

3 characters, numeric
If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999.
If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)

- Balance Due Days

3 characters, numeric
If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999.
If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)

- % Discount

2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.

- % Monthly Charge

2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.

Referral Source

20 characters, alphanumeric.

Amount Paid

15 characters (including pound sign, comma and negative sign). If no decimal entered, MYOB Accounting Plus appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.

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 method of payment is entered.

Card Number

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

Expiration Date

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

Authorisation Number

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

Cheque No

8 characters, alphanumeric. Available only if a cheque method of payment is entered.

Inclusive

1 character alphanumeric indicates the tax is inclusive.

*This is a required field for importing.