(Accounting) Receiving fictitious items on an internal purchase order, no cost per warehouse

Related topics

This example describes the accounting transactions the system creates when you receive fictitious items, delivered from another warehouse, using the Internal Replenishment routine. In this example Cost per warehouse is set to NOt active

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

Prerequisites

Quantity on internal purchase order 125
Quantity dispatched on internal sales order 110
Quantity received 110
Standard cost in Item file 0.00
Cost price on internal sales order line 50.00
From warehouse CEN
To warehouse STO
The item belongs to an item type where the Fict zero cost allwd field is set to NO and the Fict std cost retr field is set to YES in the Fictitious item types table, i.e. the cost price has to be entered on the internal sales order.

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
903 “Stock value” fictitious item 5500.00  
Cost price * Quantity received

50.00 * 110 = 5500.00

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

Tip: Normally you should not account transaction type 903 on the same account as transaction type 901 in DC1 Financials. Since the stock value in DC1 Distribution is set to Not updated for fictitious items, you will never be able to reconcile the stock account in DC1 Financials with the stock valuation list in DC1 Distribution, if you account these two transaction types on the same account in DC1 Financials.

Note: Since the item belongs to an item type with the Fict zero cost allwd field set to NO and the Fict std cost retr field set to YES, the cost price has to be entered on the internal sales order line when the internal sales order is entered in the Work with sales orders routine. In this example 50.00 was entered.

Note: If the Fict zero cost allwd field is set to YES, you do not have to enter any cost price on the internal sales order line. If you do not enter any cost price on the internal sales order line, the system does not create any accounting transactions at all when the pick list is confirmed, nor are any transactions created when the goods are received in the receiving warehouse.

907 Goods in transfer   5500.00 Warehouse CEN

Related topics