(Accounting) Change the average cost in normal stock

Related topics

The following describes the accounting transactions the system creates when:

  • you change the Average cost field in the Item file and the items are only stocked in one warehouse
  • Cost per warehouse is active and you change the Average cost field in the Item/warehouse file

Prerequisites

Quantity in normal stock 90
Quantity in transfer 10
Current average cost 5.175
New average cost 5.00

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
901 Stock value   15.75
(New average cost – Current average cost) * Quantity in normal stock

(5 – 5.175) * 90 = -15.75

This transaction decreases the stock value for the stock on hand in normal stock.

910 Manual average cost change 15.75   This is the cost for the stock value change. This could be accounted on a cost account in DC1 Financials.
907 Goods in transfer/stock supply   1.75
(New average cost – Current average cost) * Quantity in transfer

(5 – 5.175) * 10 = -1.75

Decrease of stock value of goods in transfer. Goods in transfer are items in transfer from one warehouse to another. Note: This transaction is not created if no goods are in transfer when the average cost is changed.

910 Manual average cost change 1.75   This is the cost for the stock value change for the goods in transfer. This could be accounted on a cost account in DC1 Financials. Note: This transaction is not created if no goods are in transfer when the average cost is changed.

Related topics