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 described here:

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.