TransPost Help

Product/Item Fields

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.

ItemNumber
This is mandatory as it identifies the item. It can be any string up to 30 characters, not necessarily a number.
ItemName
This can be any alphanumeric string up to 30 characters. If not supplied for a new item it will default to "New item"
Description
Up to 255 alphanumeric characters
ItemIsSold
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.
SellingPrice
Base selling price
IncomeAccount
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
TaxCodeWhenSold
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"
SellPriceInclusive
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.
ItemIsBought
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.
ExpenseAccount
Expense Account to be used when purchasing this item. e.g. 5-1100 or 51100
TaxCodeWhenBought
A 3 character Tax Code which must exist in the MYOB file (E.g. "GST" or "FRE"
ItemIsInventoried
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.
AssetAccount
Asset Account to be used to track value of the item on hand

Other fields

All other fields accessible via ODBC may be used.

CustomList1/2/3
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.
CustomField1/2/3
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

QuantityBreakn
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

Pricelevel?QtyBreakn
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.