Solved

PO Receipt To PO ReceiptlLine Relationship In GI


Userlevel 4
Badge

Hi All,

I am trying to get OpenOrderQty to show on a GI that is based on Purchase Receipts screen. I have linked POReceipt to POReceiptLine as per DAC Table, however the value for OpenOrder QTY does not show up.

If someone can let me know what is missing in order to make this work, it would be wonderful.

Kind regards,

Calvin Law

icon

Best answer by Calvin 4 July 2022, 17:53

View original

4 replies

Userlevel 4
Badge

Hi there! I think you will need to add a grouping by PO receipt nbr for it to then sum up all the open qty lines.

Userlevel 4
Badge

Hi @hayleehicks18,

Thank you for the suggestion, I tried to add the PO Receipt NBR to grouping but it did not show any value to OpenOrderQty field. 

Kind regards,

Calvin

Userlevel 4
Badge

Hi All,

I have tried to link POReceiptLine with POLine by Inventory ID and it removed all the non related Line. 

Kind regards,

Calvin

Userlevel 7
Badge

Thank you for sharing your solution @Calvin !

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved