By using this website, you agree to our Terms of Use (click here)
I am building a GI that pulls the PO Receipt Lines and the corresponding APTran Invoice entries. I need to not show a duplicate receipt quantity from the PO Receipt when there are multiple APTran Invoice entries.
I am fine with either zeroing out the PO Receipt Line Quantity for the second record or combining the APTran Invoice entries as one. I would actually prefer the second option.
Any help on this is greatly appreciated.
Thanks,
Kemp
You need to join APTRan.ReceiptNbr and APTran.ReceiptLineNbr to POReceipt.ReceiptNbr and POReceipt.LineNbr.
I suspect you forgot to include the LineNbr in the join.
Royce,
I found they originally wrote it to pull the order quantity instead of the receipt quantity. I changed the field, and it is now pulling the correct numbers.
Â
I have only been working with Acumatica since September, so it is taking me some time to follow the tables and relations.
Thanks,
Kemp
Royce,
So, after another review of the GI, I found that the receipt is showing the total receipt quantity instead of the quantity relating to the AP Invoice quantity. Is there a way to adjust this in the GI?
Attached is an example of the output. The names and numbers have been modified to protect the innocent. 😎
Â
Totals are on APInvoice. You might be better off building your own GI from scratch rather than modifying one for which you may not fully know the intenion of the original developer, especially since you are new to the platform.
Online Members
