(Accounting) Receiving less than the quantity issued from delivering warehouse without landed costs, quality control and cost per warehouse

Related topics

The following describes the accounting transactions the system creates when you receive less than the quantity issued from the delivering warehouse. In this example Cost per warehouse is set to not active.

Cost type = Standard or Average cost

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

Quantity on internal purchase order 125
Quantity dispatched on internal sales order 125
Quantity received 100
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 5000.00  
Cost price * Received quantity

50.00 * 100 = 5000.00

This transaction increases the stock value for warehouse STO. The cost price is retrieved from the Item file. If the cost type is Standard, the cost price is retrieved from the Standard cost field. If the cost type is Average purchase cost, the cost price is retrieved from the Average cost field.

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 stock value if the cost type is average.

907 Goods in transfer, stock supply   6250.00
Purchase price * Dispatched quantity

50.00 * 125 = 6250.00

Warehouse CEN. This transaction decreases the Goods in transfer. Note: The dispatched quantity is the quantity confirmed on the internal sales order pick list and is used in order to balance the goods in transfer account. If the Standard or 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.

919 Stock supply diff. negative 1250.00  
Goods in transfer – Stock value

6250.00 – 5000.00 = 1250.00

Warehouse CEN. This transaction accounts the difference between the Stock value and the Goods in transfer.

Cost type = FIFO

Prerequisites

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

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
901 Stock value 4584.00  
Purchase price (Cost on IRO sales order line) * Received quantity

45.84 * 100 = 4584.00

This transaction increases the stock value for warehouse STO. 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 overwrite the purchase price with the cost on the corresponding internal sales order line and use this in calculation of the stock value.

907 Goods in transfer, stock supply   5730.00
Cost price * Dispatched quantity

45.84 * 125 = 5730.00

Warehouse CEN. This transaction decreases the Goods in transfer. Note: The dispatched quantity is the quantity confirmed on the internal sales order pick list and is used in order to balance the goods in transfer account.

919 Stock supply difference negative 1146.00  
Goods in transfer – Stock value

5730.00 – 4584.00 = 1146.00

This transaction accounts the difference between the Stock value and the Goods in transfer. Any differences will always be accounted to the delivering warehouse, in this example warehouse CEN.

Related topics