The transactions described are created when you use the Work with inventory, Warehouse movement routine.
Where created
The transactions are created in the DSR711C program.
| Transaction type | Description | Debit/Credit | Additional info |
|---|---|---|---|
| 901 | Stock value | D/C | |
| 902 | Stock value transit stock | C | When you move an item from the transit stock |
| 907 | Goods in transfer, stock supply | D/C | If the goods are on an Internal Replenishment Order (IRO) and are in transfer between warehouses and the movement causes an average cost change. |
| 910 | Average cost change | D/C | If the cost type is Average purchase cost and an item is moved either from the non-conforming stock or transit stock to the normal stock and the average cost differs from the cost price on the non-conforming certificate. |
| 937 | Standard cost difference/Inventory movement | D/C | If the cost type is Standard cost and an item is moved from the non- conforming stock to the normal stock and the standard cost differs from the cost price on the non-conforming certificate.
If the cost type is standard and Cost per warehouse is active and an item is moved between warehouses where the item has a different standard cost in each of these. |
| 942 | Non-conforming stock value | D/C | If you move an item from / to the non-conforming stock. |
| 947 | Rounding difference/Non-conforming stock | D/C | Only if the cost price is FIFO. |
Description
When goods are moved from “normal” stock in one warehouse to another, or within the same warehouse, the system creates two transactions of type 901. Both have the same amount, which is the cost value of the goods in question, depending on the cost type in the system, (i.e. Standard cost, Average purchase cost or FIFO).
If goods are moved from transit stock to “normal” stock transaction type 902 reduces (credits) the stock value for the “from” location or warehouse and transaction 901 increases (debits) the stock value for the “to” location or warehouse. Note that both the “from” and “to” warehouse may be the same.
If goods are moved from or to non-conforming stock the system creates transaction type 942 for the non-conforming stock.
In Financials you can have different accounts for each warehouse in Distribution. In that case the credit transaction is accounted on one account and the debit transaction is accounted on another.
Transit stock
If the cost type is Average purchase cost and you move goods from transit to normal stock, the system will calculate a new average cost price after the movement of goods, if the average transit cost differs from the normal average cost price. This affects the value of the existing stock on hand and goods in transfer. Note: This only applies if the Sep cost handling field in the DIS control file is set to YES.
Goods in transfer
Goods in transfer are items entered on an Internal Replenishment Order (IRO) where the Internal Sales order has been confirmed in the delivering warehouse (delivered), but the Internal Purchase order has not yet been received in the receiving warehouse.
To ensure that the stock value and goods in transfer are correct, the transactions for average cost change (915) and stock value/goods in transfer (901/907) are accounted for each warehouse, (i.e. the same way as if the average cost price was changed manually in the Item file).
Non-conforming stock
Goods entered on a non-conforming certificate (in non-conforming stock) could have a different cost price than goods in normal stock. If the cost type is Average purchase cost and you move goods from the non-conforming stock to the normal stock, the system will calculate a new average cost price after the movement, if the cost price on the non-conforming certificate differs from the normal average cost price. This affects the value of the existing stock on hand and goods in transfer.
If the cost type is Standard cost and you move goods from the non-conforming stock, the system creates transaction type 937 if the cost price on the non-conforming stock differs from the Standard cost in the Item file.
Cost per warehouse
If Cost per warehouse is active and the cost type is Standard and there is a difference between the costs in the “from” and “to” warehouses, the system creates a transaction type 937 to account for this difference.
Rounding difference
The system may create transaction type 947 if the cost type is FIFO and you move goods from the normal stock to the non-conforming stock. See (Accounting) Move item to non-conforming stock.
Note: You cannot enter fictitious items in the Stock movement routine.
Related topics
- (Accounting) Move item from normal stock in one warehouse to normal stock in another
- (Accounting) Move item from transit stock
- (Accounting) Move item to non-conforming stock
- (Accounting) Move item from non-conforming stock to normal stock, with standard cost
- (Accounting) Move item from non-conforming stock to normal stock, with average purchase cost
- (Accounting) Move item from non-conforming stock to normal stock, with FIFO
- (Accounting) Move item within non-conforming stock