Items Fields

Importing and Exporting Overview > Importing data into MYOB Accounting Plus > Importing and exporting fields> 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.

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.