Importing/Exporting - Items Fields

Items Fields

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
Custom List 2
Custom List 3

30 characters, alphanumeric (each field); each entry must match an existing list entry

Custom Field 1
Custom Field 2
Custom Field 3

30 characters, alphanumeric (each field)

Primary Vendor

31 characters, alphanumeric. 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.

*Required Field: When importing, this field must have a valid matching import field.

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 Custom List 2 Custom List 3	30 characters, alphanumeric (each field); each entry must match an existing list entry
Custom Field 1 Custom Field 2 Custom Field 3	30 characters, alphanumeric (each field)
Primary Vendor	31 characters, alphanumeric. 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.