Item Costing Report

This report shows the prices, costs, total cost, margins and gross margin of items in inventory.

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.