Skip to main content
Solved

PO Receipt To PO ReceiptlLine Relationship In GI


Forum|alt.badge.img
  • Jr Varsity III
  • 65 replies

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

Best answer by Calvin

Hi All,

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

Kind regards,

Calvin

View original
Did this topic help you find an answer to your question?

4 replies

hayleehicks
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 106 replies
  • June 28, 2022

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.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • June 28, 2022

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


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • Answer
  • July 4, 2022

Hi All,

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

Kind regards,

Calvin


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2527 replies
  • July 8, 2022

Thank you for sharing your solution @Calvin !


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings