Inventory Part In Stock

Hi @Ozge 

I am afraid not on the screen “Inventory Part In Stock”.

Did you check the “Inventory Transaction History”?

Hello.

You should check “Inventory Value per Period” and setting up all prerequisites such as aggreagtion of transaction periods. Then at least you can see the stock of each part for past periods.

Or like Link suggested, go to inventory transaction history and calculate all increases and decrease until the specific time in past.

Hi @Ozge ,

You can use the PL/SQL block below.

select * from ifsapp.INVENTORY_TRANSACTION_HIST2 a
where a.location_no = '&inventory_loc'

Best regards.

Hi Oszge,

we solved it the good old ETL way.
Every night we import the InventoryPartInStock (IPIS) table into the DWH and suffix it with yyyy_mm_dd.
In the DWH we have a “delta” logic which takes plus and minus (since the go live) from every part into a FACT_ table. Because you have also an IPIS_first_of_month in the DWH you can create reports as you like.

HTH
BR
Michael