Field |
Description and Character Limits |
*Co./Last Name |
Must match a preexisting card in your MYOB software 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 BusinessBasics 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 through 4) cannot exceed 255 characters, alphanumeric. |
Invoice # |
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 |
Ship Via |
20 characters, alphanumeric |
Already Printed |
1 character. Any non-blank character signifies that the invoice is already printed or sent. |
*Item Number |
30 characters, alphanumeric. Must match an preexisting item in your MYOB BusinessBasics company file. |
Quantity |
10 characters, numeric - allows 3 decimal places and decimal point. |
Description |
255 characters, alphanumeric |
Price |
11 characters, numeric, including 3 decimal places |
Total |
Dollar amount field 15 characters (including dollar signs and negative signs). |
Job |
5 characters, alphanumeric. Must match preexisting job number in your MYOB BusinessBasics company file. |
Comment |
255 characters, alphanumeric |
Journal Memo |
255 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. Must match a preexisting tax code in the Tax Code List. |
Tax Amount |
15 characters, numeric, including 2 decimal places |
Freight Amount |
15 characters, numeric, including 2 decimal places |
Freight Tax Code |
3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List. |
Freight Tax Amount |
15 characters, numeric, including 2 decimal places |
Sale Status |
1 alphanumeric character. Q indicates a quote. Any other character or blank indicates the sale is an invoice. |
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 |
- Balance Due Days |
3 characters, numeric |
Amount Paid |
15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB BusinessBasics 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. |
Authorization Number |
255 characters, alphanumeric. Available only if a credit card or debit card method of payment is entered. |
Check No |
8 characters, alphanumeric. Available only if a check method of payment is entered. |
*This is a required field for importing.