Commonly used fields
There are a large number of possible fields in a for a product or item. Most of them are optional and not required in most cases. A few key fields are important because they are necessary to identify and use the item when importing item sales.
- This is mandatory as it identifies the item. It can be any string up to 30 characters, not necessarily a number.
- This can be any alphanumeric string up to 30 characters. If not supplied for a new item it will default to "New item"
- Up to 255 alphanumeric characters
- A value in this field indicates that the Item is sold, but not essential as TransPost assumes thet an item is sold if IncomeAccount is supplied.
- Base selling price
- This is mandatory for items that are sold. It can be supplied with or without a separator. e.g. 4-1100 and 41100 work equally well in TransPost
- This is mandatory for items that are sold. A 3 character Tax Code which must exist in the MYOB file (E.g. "GST" or "FRE"
- A value (e.g."Y" or "X" or 1) in this field indicates that the Base Selling Price is Tax/GST inclusive. This field cannot be used to change an existing item price to non-inclusive.
- A value in this field indicates that the Item is bought, but not essential as TransPost assumes thet an item is bought if ExpenseAccount is supplied.
- Expense Account to be used when purchasing this item. e.g. 5-1100 or 51100
- A 3 character Tax Code which must exist in the MYOB file (E.g. "GST" or "FRE"
- A value in this field indicates that the Item is inventoried, but not essential as TransPost assumes thet an item is inventoried if AssetAccount is supplied.
- Asset Account to be used to track value of the item on hand
All other fields accessible via ODBC may be used.
- Values in MYOB Custom Lists for Items, in Custom List #1, Custom List #2 or Custom List #3 as appropriate. The values must pre-exist in the appropriate Custom List in MYOB.
- Values, up to 255 characters long, which will be inserted into Item Details Custom Field #1, Custom Field #2 or Custom Field #3 as appropriate.
Other fields are also available. The names of the fields indicate the purpose.
Price Levels and Quantity Breaks
Only available in multi-user versions of MYOB
- Up to 4 quantity breaks, numbered 2 - 5. These fields specify the quantity over which price breaks are reached.
Note that QuantityBreak1 refers to normal prices for single or small quantities so is fixed at 0.0
- With each of the above quantity breaks you must supply the price levels A to F which apply to each specified price break.
For example PricelevelCQtyBreak1 specifies the base price for customers on Price Level C and PricelevelBQtyBreak3 sets the price applicable when a customer on Price Level B buys the amount specified in QuantityBreak3.
Note that PricelevelAQtyBreak1 is automatically set to the base selling price.