Field |
Description and Character Limits |
*Item Number |
30 characters, alphanumeric. |
Item Name |
30 character, alphanumeric |
Buy |
1 character. Any non-blank character signifies that the item is bought. |
Sell |
1 character. Any non-blank character signifies that the item is sold. |
Stock |
1 character. Any non-blank character signifies that the item is stocked. |
Asset Acct |
Linked asset account. Must be valid, preexisting MYOB 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). |
Income Acct |
Linked income account. Must be valid, preexisting MYOB 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). |
Expense/COS Acct |
Linked expense or cost of sales account. Must be valid, preexisting MYOB software 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). |
Item Picture |
File name of the graphic. 255 characters, alphanumeric. |
Description |
255 characters, alphanumeric. |
Use Desc. On Invoice |
1 character. Any non-blank character signifies that the item description and not the item name should be used on the invoice |
Custom List 1 |
30 characters, alphanumeric. Must match an existing list entry. |
Custom List 2 |
30 characters, alphanumeric. Must match an existing list entry. |
Custom List 3 |
30 characters, alphanumeric. Must match an existing list entry. |
Custom Field 1 |
30 characters, alphanumeric. |
Custom Field 2 |
30 characters, alphanumeric. |
Custom Field 3 |
30 characters, alphanumeric. |
Main Supplier |
31 characters alphanumeric. Must match the name of a supplier card in your card file. (If the supplier is an individual, MYOB Accounting Plus matches on the last name, followed by a comma and a space, followed by the first name.) |
Supplier Item Number |
30 characters alphanumeric. |
VAT Code When Bought |
3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List. |
Buy Unit Measure |
5 characters, alphanumeric. |
No. Items/Buy Unit |
4 characters, numeric. |
Reorder Quantity |
10 characters, numeric, including 3 decimal places. |
Minimum Level |
10 characters, numeric, including 3 decimal places. |
Selling Price |
11 characters, numeric, including 4 decimal places. |
Sell Unit Measure |
5 characters, alphanumeric. |
VAT Code When Sold |
3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List. |
No. Items/Sell Unit |
4 characters, numeric. |
Quantity Break 1 |
This amount, which must be 0.000, is set automatically by MYOB Accounting Plus. |
Quantity Break 2 |
10 characters, numeric including 3 decimal places. Must be greater than zero but less than Quantity Break 3. |
Quantity Break 3 |
10 characters, numeric including 3 decimal places. Must be greater than Quantity Break 2 but less than Quantity Break 4. |
Quantity Break 4 |
10 characters, numeric including 3 decimal places. Must be greater than Quantity Break 3 but less than Quantity Break 5. |
Quantity Break 5 |
10 characters, numeric including 3 decimal places. Must be greater than Quantity Break 4. |
Price Level A-F, Qty Break 1 |
11 characters, numeric including 4 decimal places. |
Price Level A-F, Qty Break 2-5 |
11 characters, numeric including 4 decimal places. (Price levels are available only when valid quantity breaks have been designated for the item.) |
Inactive Item |
If the field is blank or the letter N appears in the field, the item won't be marked; the item will have an active status. If the field contains a Y or any non-blank character (other than N), the item will be marked; the item will have an inactive status. For information about updating the status of existing records, see Updating the status of cards, items, activities or accounts. |
*This is a required field for importing.