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 |
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 |
- Discount Days |
3 characters, numeric |
- Balance Due Days |
3 characters, numeric |
- % 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.