(Accounting) Move item from normal stock in one warehouse to normal stock in another

Related topics

The following describes the accounting transactions that are created when you move an item from “normal” stock in one warehouse to another.

Cost per warehouse is not active

Prerequisites

Quantity 10
Cost 10
From warehouse CEN
To warehouse STO

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
901 Stock value   100.00
Cost price * Quantity moved

10.00 * 10 = 100.00

This transaction decreases (credits) the stock value in the “from” warehouse (Warehouse CEN). The cost price for the item is retrieved from the Item file if the cost type is Standard cost (Standard cost field) or Average purchase cost (Average cost field). If the cost type is FIFO, the cost price is retrieved from the oldest active transaction in the FIFO file. If the quantity in the oldest transaction does not cover the entire moved quantity, the system also uses the second oldest transaction, and so on.

901 Stock value 100.00  
Cost price * Quantity moved

10.00 * 10 = 100.00

This transaction increases (debits) the stock value in the “to” warehouse (Warehouse STO). The cost price for the item is retrieved from the Item file if the cost type is Standard cost (Standard cost field) or Average purchase cost (Average cost field). If the cost type is FIFO, the cost price is retrieved from the oldest active transaction in the FIFO file. If the quantity in the oldest transaction does not cover the entire moved quantity, the system also uses the second oldest transaction, and so on.

Cost per warehouse is active and cost type = Standard cost

Prerequisites

Quantity 10
Items standard cost (CEN) 10.00
Items standard cost (STO) 12.00
From warehouse CEN
To warehouse STO

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
901 Stock value   100.00
Cost price (CEN) * Quantity moved

10.00 * 10 = 100.00

This transaction decreases (credits) the stock value in the “from” warehouse (Warehouse CEN). The cost price for the item is retrieved from the Standard cost field in the Item/Warehouse file for the CEN warehouse.

901 Stock value 120.00  
Cost price (STO) * Quantity moved

12.00 * 10 = 120.00

This transaction increases (debits) the stock value in the “to” warehouse (Warehouse STO). The cost price for the item is retrieved from the Standard cost field in the Item/Warehouse file for the STO warehouse.

937 Standard cost difference/Inventory movement   20.00
Difference in cost * Moved quantity

(12.00 – 10.00) * 10 = 20.00

This transaction increases (credits) Standard cost difference/stored in Warehouse STO. Note: If Cost per warehouse is active and the cost type is either Average purchase cost or FIFO then the transactions created will be the same as in the first example.

Related topics