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?
Solved
Inventory parts which not onhand and not used for the last six months
+16Best answer by ShawnBerk
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.
+16inventory_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.
1 person likes this
+16ShawnBerk wrote:
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.