Hi -

Do you know how records are inserted in the Inventory Receipt Transaction Consumptions (whinr114) table ??

Any help would be appreciated.

Thanks

When goods are received, the value of the inventory will increase accordingly. At receipt this is reflected in the “Inventory Receipt Transactions” (whina1512m000). Note: the table is whinr112.

As soon as stock is issued, the inventory value will decrease. At that moment a record will be logged in whinr114. First one or more records in whinr112 are selected for which the received quantity is not yet consumed. To order in which the whinr112-records are selected depends on the inventory valuation method. E.g. in case of LIFO, the latest records will be selected first.
When a new whinr114 record is inserted it is linked with 1 or more whinr112-records. In that case it is known for which order line(s) and on what date the consumption was done. This is important in case of running an inventory valuation in the past.

Also the amounts which are logged at the moment of issue depend on the inventory valuation method:
- FTP: the cost price is retrieved from the CPR-module.
- MAUC: the MAUC is logged
- LOT price: the lot price is retrieved
- LIFO/FIFO: the amount of the linked whinr112-record is taken.

In all cases the amount is increased by (item and/or warehouse) issue surcharges if these are defined.

The whinr114-records are visible in session “Inventory Receipt Transaction Consumptions” (whina1514m000).