Skip to main content

Hi,

We want to learn the inventory part not onhand and no used for the last six months. Do ifs have a report? Or should we write an SQL query? If should we write, which view and parameters should we look?

inventory_part_in_stock_uiv view has last_activiy_date column but when something changes on inventory part it also changes. 

Start with the Inventory Transactions History overview - inventory_transaction_hist2 and define a data set through a query that is what you consider usage (this can vary by company).  Do this by selecting the site and transaction codes at a minimum that you want to show as your dataset.  You can filter this by your 6 month criteria, then use that as the sub-query or comparison to the current quantity on hand.  Then you could determine the items that haven’t had movement against your selected usage codes, but are still showing in stock.  We call this slow-moving inventory.

 

Start with the Inventory Transactions History overview - inventory_transaction_hist2 and define a data set through a query that is what you consider usage (this can vary by company).  Do this by selecting the site and transaction codes at a minimum that you want to show as your dataset.  You can filter this by your 6 month criteria, then use that as the sub-query or comparison to the current quantity on hand.  Then you could determine the items that haven’t had movement against your selected usage codes, but are still showing in stock.  We call this slow-moving inventory.

 

Thank you Sir. 

Reply


Terms & ConditionsCookie settings