I am fairly new to ACM and would like some help on editing my purchase orders GI. Just as the GI shows the Order qty and the Open qty, I need to be able to see the "total qty on receipts".
Additionally, I need a condition where it only displays the purchase orders where the "total qty on receipts" is not equal to the Order qty.
Can anyone give me the steps to do this?
Answer
Partial Received PO
Best answer by ricoybanez
This is the Result of the Inquiry, I forgot to attach.
+3
I used this condition and it works.
Rico P. Ybanez
+3
This is the Result of the Inquiry, I forgot to attach.
Rico P. Ybanez
+15
As
Dermot Comerford
This is exactly what I am looking for. Thank you!
Did you have to add an additional table to bring in the POLine.Received qty.
+3
I only used 2 tables
1. POOrder
2. POLine
Thanks
Rico P. Ybanez
Okay, for some reason I am getting too many lines. I only want to see one line pr PO.
Am I missing something?
+3
Disable your 2nd condition
Rico P. Ybanez
+12Look at the grouping tab to group by Order Number. Also you may want to consider getting your quantity records (ordered/received/open) all from the same table and that you’re only using the SUM features on the POLine records and not the POOrder records.
Megan Friesen, Contego Software Solutions, Canada
+3
Can you send the xml file for easy review of your GI.
Rico P. Ybanez
+3
Can you Group by OrderNbr
Rico P. Ybanez
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.