(Accounting) Receiving goods on an internal purchase order, without landed costs, quality control and cost per warehouse

Related topics

The following describes the accounting transactions the system creates when you receive goods delivered from another warehouse, using the Internal Replenishment routine. In this example no quality control is performed and no landed costs are incurred during the transfer. Cost per warehouse is not active.

Note: This example corresponds to (Accounting) Deliver goods on an internal sales order.

Cost type = Standard

Prerequisites
The following prerequisites apply if the cost type is Standard cost:

Quantity on internal purchase order 125
Quantity dispatched on internal sales order 110
Quantity received 110
Standard cost in Item file 50.00
From warehouse CEN
To warehouse STO

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
901 Stock value 5500.00  
Cost price * Received quantity

50.00 * 110 = 5500.00

This transaction increases (debits) the stock value for warehouse STO, using the Standard cost in the Item file.

Note: When the internal purchase order is created, the purchase price will be retrieved from the Last purchase cost field in the Item file, irrespective of the cost type in the system. You can change the purchase price on the internal purchase order, but this will have no effect whatsoever. When the internal purchase order is received, the system will override the purchase price with the Standard cost from the Item file and will use this in the calculation of the stock value.

907 Goods in transfer, stock supply   5500.00 Warehouse CEN. This transaction decreases (credits) the Goods in transfer. When the internal sales order pick list was confirmed, this amount was debited on transaction type 907.

Note: If the Standard cost has been changed manually in the Item file during transfer of the goods, this amount differs from the amount debited on transaction type 907 when the internal sales order pick list was confirmed. The value of the goods in transfer has then been re-valued. See (Accounting) Receiving goods when the cost price has been changed during transfer.

Cost type = Average purchase cost

Prerequisites
The following prerequisites apply if the cost type is Average purchase cost:

Quantity on internal purchase order 125
Quantity dispatched on internal sales order 110
Quantity received 110
Average cost in Item file 50.00
From warehouse CEN
To warehouse STO

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
901 Stock value 5500.00  
Cost price * Received quantity

50.00 * 110 = 5500.00

This transaction increases (debits) the stock value for warehouse STO. The Average cost price is retrieved from the Item file. Note: When the internal purchase order is created, the purchase price will be retrieved from the Last purchase cost field in the Item file, irrespective of the cost type in the system. You can change the purchase price on the internal purchase order, but this will have no effect whatsoever. When the internal purchase order is received, the system will over write the purchase price with the Average cost from the Item file and will use this in the calculation of the stock value.

907 Goods in transfer, stock supply   5500.00 Warehouse CEN. This transaction decreases (credits) the Goods in transfer. When the internal sales order pick list was confirmed, this amount was debited on transaction type 907.

Note: If the Average cost has been changed during transfer of the goods, this amount differs from the amount debited on transaction type 907 when the internal sales order pick list was confirmed. The value of the goods in transfer has then been re-valued. See (Accounting) Receiving goods when the cost price has been changed during transfer.

Cost type = FIFO

Prerequisites FIFO

Quantity on internal purchase order 125
Quantity dispatched on internal sales order 110
Quantity received 110
From warehouse CEN
To warehouse STO

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
901 Stock value 5450.06  
Cost price on internal sales order line * Received quantity

Cost on IRO sales order line: 5450.00 / 110 = 49.546 (rounded)
Stock value: 49.546 * 110 = 5450.06

This transaction increases the stock value for warehouse STO. Note: The cost price on the internal sales order line is calculated when the goods are Dispatched from the delivering warehouse, i.e. when the internal sales order pick list is confirmed. (See (Accounting) Deliver goods on an internal sales order.)

The cost price is retrieved from the internal sales order line.

Note: When the internal purchase order is created, the purchase price will be retrieved from the Last purchase cost field in the Item file. You can change the purchase price on the internal purchase order, but this will have no effect whatsoever. When the internal purchase order is received, the system will always use the cost on the corresponding internal sales order line to calculate the stock value.

907 Goods in transfer, stock supply   5450.06 Warehouse CEN. This transaction decreases the Goods in transfer.

Note: When the internal sales order pick list was confirmed, the amount debited on transaction type 907 was 5450.00. This means that the 907 account will have a remaining amount of -0.06. This should be regarded as a rounding difference.

Related topics