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?
Solved
Partial Received PO
Best answer by ricoybanez
This is the Result of the Inquiry, I forgot to attach.
+5
I used this condition and it works.
+5
This is the Result of the Inquiry, I forgot to attach.
+16
As
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.
+5
I only used 2 tables
1. POOrder
2. POLine
Thanks
Okay, for some reason I am getting too many lines. I only want to see one line pr PO.
Am I missing something?
+5
Disable your 2nd condition
+13Look 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.
+5
Can you send the xml file for easy review of your GI.
+5
Can you Group by OrderNbr
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.