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.
+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.
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.