Cost Tier table schema

1 minute read time.

The cost tier is an important costing feature provided by IM which allows the system to track the actual cost at which an item was purchased every time. 

Sage 500 stores the cost in table timCostTier. Here is the schema for that table:

A cost tier stores the cost at which an item was added into the inventory and its quantity. The cost of an item is divided into four factors:

Direct Cost, Freight Cost, Sales Tax Cost and Other Cost.

The direct cost (TotMaterialCost) is the one that is charged by the vendor, excluding all other costs.

The freight cost (TotFreightCost) is that associated with the freight charges for that purchase.

The sales tax cost (TotSTaxCost) is that portion which is paid as sales tax for that purchase.

The other cost (TotOtherCost) is that portion which is not covered in freight and sales tax, such as handling or insurance.

The total cost is the sum of the direct, freight, sales tax and other costs.

For manufactured (make) items there are additional cost buckets used to track the cost to manufacture the  item: TotOtherMfgCost, TotOutsideCost, TotRunFixCost, TotRunVarCost, TotSetFixCost, and TotSetVarCost.

The quantities of an item in a cost tier are tracked in two ‘buckets’ – OrigQty and QtyUsed. The original quantity indicates the total quantity that was added in the cost tier. The quantity used indicates the quantity that has been removed from the cost tier. 

The cost and quantities in a cost tier are tracked by the system for every IM transaction. IM posting updates the cost tiers when the IM transactions or any other module transactions that affect inventory are posted  such as: PO Receipt Of Goods and Vendor Returns, SO Shipments and Customer Returns, MF Progress, Material Issue, Production Entry returns and Material Issue Reversal Transactions.