Skip to main content
Solved

PO Receipt To PO ReceiptlLine Relationship In GI

  • Jun 28, 2022 6:36 PM UTC
  • 5 replies
  • 240 views
  • Translate All
Jr Varsity III
Forum|alt.badge.img

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

5 replies

hayleehicks
Varsity I
Forum|alt.badge.img+1
  • hayleehicks
  • Varsity I
  • Jun 28, 2022 6:59 PM UTC

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.

Translate
Haylee Hicks // i-Tech Support // Senior ERP Client Success Manager
    Jr Varsity III
    Forum|alt.badge.img
    • Calvin
    • Author
    • Jr Varsity III
    • Jun 28, 2022 8:03 PM UTC

    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

    Translate
    Jr Varsity III
    Forum|alt.badge.img
    • Calvin
    • Author
    • Jr Varsity III
    • Answer
    • Jul 4, 2022 3:53 PM UTC

    Hi All,

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

    Kind regards,

    Calvin

    Translate
      Chris Hackett
      Community Manager
      Forum|alt.badge.img
      • Chris Hackett
      • Acumatica Community Manager
      • Jul 8, 2022 6:51 PM UTC

      Thank you for sharing your solution @Calvin !

      Translate
      Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
      Freshman II
      • SunnyM
      • Apr 24, 2026 7:57 PM UTC

      ​@Calvin that didn't work for me on the PO receipt GI. Do you know of another way to show open qty? 

      Translate
      Terms & ConditionsAccessibility statement
      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