1. Home
  2. /
  3. User Guides
  4. /
  5. Distribution
  6. /
  7. Accounting
  8. /
  9. Transfer group handling
  10. /
  11. Manual change of average...
  12. /
  13. (Accounting) Change the average...

(Accounting) Change the average cost when no separate cost handling

Related topics

The following describes the accounting transactions the system creates when you change the Average cost field in the Item file.

Prerequisites

Sep cost handling field in DIS control file N
Cost per warehouse Not active
Quantity in transit stock, whs CEN 96
Quantity in normal stock, whs CEN 52
Quantity in normal stock, whs STO 672
Quantity in transfer, whs CEN 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   9.10
(New average cost – Current average cost) * Quantity in normal stock CEN

(5 – 5.175) * 52 = -9.10

This transaction decreases the stock value for the stock on hand in warehouse CEN.
910 Manual average cost change 9.10   This is the cost for the stock value change in warehouse CEN. This could be accounted on a cost account in Financials.
901 Stock value   117.60
(New average cost – Current average cost) * Quantity in normal stock STO

(5 – 5.175) * 672 = -117.60

This transaction decreases the stock value for the stock on hand in warehouse STO.
910 Manual average cost change 117.60   This is the cost for the stock value change in warehouse STO. This could be accounted on a cost account in Financials.
907 Goods in transfer   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 in warehouse CEN. Goods in transfer are items entered on an Internal Replenishment Order (IRO) where the Internal Sales order has been confirmed in the delivering warehouse (delivered), but the Internal Purchase order has not yet been received in the receiving warehouse.
910 Manual average cost change 1.75   This is the cost for the stock value change for the goods in transfer in warehouse CEN. This could be accounted on a cost account in Financials.
902 Stock value transit stock   16.80
(New average cost – Current average cost) * Quantity in transit stock in warehouse CEN

(5 – 5.175) * 96 = -16.80

This transaction decreases the transit stock value in warehouse CEN. Since the Sep cost handling field is set to NO in the DIS control file, the Average cost in the Item file is used in this calculation.
916 Average cost change, transit DPC 16.80   This is the cost for the transit stock value change in warehouse CEN. This could be accounted on a cost account in Financials.

Related topics