Item Costing Report

The total cost is calculated based on the items cost method and type as follows:

• If the cost method is average or standard, or the cost type is standard:

  (item warehouse quantity-on-hand + item warehouse non-nettable stock) * item unit cost

• If the cost method is LIFO/FIFO:

  item quantity * item unit cost

• If the cost method is Specific (lot tracked):

  lot-location quantity-on-hand * lot-location unit cost

• If the cost method is Specific (not lot tracked):

  item-location quantity-on-hand * item-location unit cost

The gross margin shows the profitability of each item, and is calculated as the total price minus the total cost. A grand total of all items is also included.

You can sort this report by total cost or gross margin. You can print it for a range of items and product codes. You can select which ABC codes, sources, and material types to include. In addition, you can elect to include stocked and/or non-stocked items.