Skip to main content

Inventory Part In Stock

  • September 19, 2024
  • 4 replies
  • 366 views

Forum|alt.badge.img+7

Hi all,

 

Is there any way to learn a quantity for an inventory part in a location for a specific time in past?

 

Thnaks

Ozge

4 replies

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • September 19, 2024

Hi @Ozge 

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

Did you check the “Inventory Transaction History”?


Forum|alt.badge.img+5

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.


Forum|alt.badge.img+5

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.


Michael Kaiser
Sidekick (Customer)
Forum|alt.badge.img+9
  • Sidekick (Customer)
  • September 27, 2024

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