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

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).

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)

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.

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
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).



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)
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.









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.