Is there a query that provides stock status by Purchase Group? For example, the procurement team is using Purchase Group as a way to identify categories of purchased raw. Would like to see on hand qty and standard cost.
If using IEE, you coule use an advanced sub-query search from the Inventory Part in Stock overview that will allow searching by Purchase Group, like this:
CONTRACT = '&SITE' and QTY_ONHAND > 0 and PART_NO in (SELECT PART_NO from IFSAPP.PURCHASE_PART where CONTRACT = '&SITE' and STAT_GRP = '&P_GRP')
In Aurena of course, this no longer works, but you could do something similar as a quick report.
+1
Hi and thanks for the feedback. We are using Aurena, so the answer seems to be quick report.
Thank you for the kind reply.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.