(Accounting) Receiving goods on an internal purchase order, with quality control, without 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 quality control is performed and cost per warehouse is set to not active, there are no landed costs.

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

Cost type = Standard or Average purchase cost

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

Quantity on internal purchase order 125
Quantity dispatched on internal sales order 110
Quantity received 110
Quantity approved 100
Cost in Item file 50.00
From warehouse CEN
To warehouse STO

Created transactions

The system creates the following transactions when the reception note is confirmed:

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
940 In quality control 5500.00  
Purchase/cost price * Received quantity

50.00 * 110 = 5500.00

Warehouse STO. This transaction increases (debits) the In quality control account with the value of the goods received. 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 internal purchase price on the purchase order, but this will have no effect whatsoever. When the internal purchase order is received, the system will overwrite the purchase price with the Standard cost or Average cost price from the Item file and will use this in calculating the In quality control value.

907 Goods in transfer   5500.00
Purchase/cost price * Received quantity

50.00 * 110 = 5500.00

Warehouse CEN. This transaction decreases (credits) the Goods in transfer by the value of the goods received.

The system creates the following transactions when the quality control note is confirmed:

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
901 Stock value 5000.00  
Purchase/cost price * Approved quantity

50.00 * 100 = 5000.00

Warehouse STO. This transaction increases the stock value in the receiving warehouse with the approved goods value.

940 In quality control   5500.00
Purchase/cost price * Approved quantity

50.00 * 110 = 5500.00

Warehouse STO. This transaction decreases the account for items in quality control. When the items were received, this account was increased by the Cost price * Received quantity.

941 Non-conforming stock value 500.00  
Purchase/cost price * Rejected quantity

50.00 * 10 = 500.00

Warehouse STO. This transaction increases the non-conforming stock value. 10 pieces are added to the non-conforming stock, since they were not approved.

Cost type = FIFO

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

Quantity on internal purchase order 125
Quantity dispatched on internal sales order 110
Quantity received 110
Quantity approved 100
Cost price on internal sales order line 49.546
From warehouse CEN
To warehouse STO

The system creates the following transactions when the reception note is confirmed:

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
940 In quality control 5450.06  
Purchase price (Cost on IRO sales order line) * Received quantity

49.546 * 110 = 5450.06

Warehouse STO. This transaction increases (debits) the In quality control account with the value of the goods received. Note: When the internal purchase order is created, the purchase price will be retrieved from the Last purchase cost field in the Item/warehouse file for the delivering warehouse. When the internal purchase order is received, the system will always overwrite the purchase price with the cost price from the corresponding sales order line and use this in calculating the Goods received awaiting costs and stock values.

907 Goods in transfer   5450.06
Cost on IRO sales order line * Issued quantity

49.546 * 110 = 5450.06

Warehouse CEN. This transaction decreases (credits) the Goods in transfer account with the value of the goods received. Note: When the internal purchase order is created, the purchase price will be retrieved from the Last purchase cost field in the Item/warehouse file for the delivering warehouse. When the internal purchase order is received, the system will always overwrite the purchase price with the cost price from the corresponding sales order line and use this in calculating the Goods received awaiting costs and stock values.

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.

Cost price on internal sales order line: Total stock value / quantity
5450.00 / 110 = 49.545454 rounded to 49.546

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

The system creates the following transactions when the quality control note is confirmed:

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

49.546 * 100 = 4954.60

Warehouse STO. This transaction increases the stock value in the receiving warehouse with the approved goods value.

940 In quality control   5450.06
Cost price * Received quantity

49.546 * 110 = 5450.06

Warehouse STO. This transaction decreases the account for items in quality control. When the items were received, this account was increased by the cost price * received quantity.

941 Non-conforming stock value 495.46  
Cost price * Rejected quantity

49.546 * 10 = 495.46

Warehouse STO. This transaction increases the non-conforming stock value. 10 pieces are added to the non-conforming stock, since they were not approved.

Related topics