Cost each item by standard, moving average, FIFO or LIFO
An item’s costing method now decides what its stock is worth and what leaves in cost of sales. Standard stays the default; nothing changes for an item until you set another method.
Set the method on the item’s costing record (open the item, Costing). Standard values and issues stock at the standard cost, as before. Moving average re-averages the item’s cost on every receipt and issues at the average. FIFO and LIFO open a cost layer for every receipt and issue from the oldest (FIFO) or newest (LIFO) layers, at what those layers cost.
- Cost of sales on a delivery, parts used on a work order, material issued to a production order and inventory losses all leave at the item’s method.
- A landed cost voucher raises the cost of the layers it names, and a reversal takes it back exactly.
- Supply Chain › Inventory › Inventory Costing: Inventory Valuation shows the value by method beside the value at standard; Cost Layers the open layers; Costing Method Changes every change of method.
A method cannot simply be edited while the item has stock in cost layers. Use Cost Revaluations › Post a revaluation: it closes the open layers, puts the stock under the new method at the unit cost you give, and posts the difference to inventory against the inventory adjustment account.
- Open Supply Chain › Inventory › Inventory Costing › Cost Revaluations.
- Post a revaluation: pick the item, the new method and the unit cost of the stock on hand, and say why.
- The document is numbered CRV-, the journal is posted, and the change is written to Costing Method Changes.