Items Fields

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.
Inventory	1 character. Any non-blank character signifies that the item is inventoried.
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-3	30 characters, alphanumeric. Must match an existing list entry.
Custom Field 1-3	30 characters, alphanumeric.
Primary Vendor	31 characters alphanumeric. Must match the name of a vendor card in your card file. (If the vendor is an individual, MYOB Accounting Plus matches on the last name, followed by a comma and a space, followed by the first name.)
Vendor Item Number	30 characters alphanumeric.
Tax When Bought	1 character. Any non-blank character signifies that the item is taxable when bought.
Buy Unit Measure	5 characters, alphanumeric.
# 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.
Tax When Sold	1 character. Any non-blank character signifies that the item is taxable when sold.
# 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.)

*This is a required field for importing.