View a list of all types of fields: Field descriptions for importing and exporting
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 a valid, preexisting MYOB account number. 5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234). |
Income Acct |
Linked income account. Must be a valid, preexisting MYOB account number. 5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234). |
Expense/COS Acct |
Linked expense or cost of sales account. Must be valid, preexisting MYOB AccountEdge account number. 5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits (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 (each field).When importing, each entry must match an existing list entry |
Custom Field 1 |
30 characters, alphanumeric (each field) |
Primary Vendor |
31 characters, alphanumeric. When importing, must match the name of a vendor card in the card file. (If the vendor is an individual, MYOB AccountEdge matches the name in this format: Lastname, Firstname.) |
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 must be 0.000; set automatically by MYOB AccountEdge. |
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 blank or the letter N appears in the field, the item won't be marked; it will have active status. If the field contains a Y or any non-blank character (other than N), the item will be marked; it will have inactive status. |
Standard Cost |
10 characters, numeric including 4 decimal places. |
Default Ship/Sell Location |
10 characters, alphanumeric. When importing, must match a preexisting location in the MYOB AccountEdge company file. |
Default Recvd/Auto Location |
10 characters, alphanumeric. When importing, must match a preexisting location in the MYOB AccountEdge company file. |
*Required Field: When importing, this field must have a valid matching import field.