Skip to main content
Question

PO Receipts Open Quantity

  • April 29, 2026
  • 4 replies
  • 33 views

Hello, 

 

In the GI is there a way to add the open qty section per PO receipt number and in Acumatica report designer? 

 

Thank you. 

4 replies

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • April 29, 2026

Hello,

Yes.  You can add just about anything you want to a GI, including adding Open Qty to the PO Receipts GI.  (I recommend exporting the GI to XML as a backup before making changes.)

Receipts can have multiple lines - do you want to see Inventory items and Open quantity per line?  If yes, each PO Receipt with multiple lines may be listed once for each line in the PO Receipts GI after your change.

If you want only the Sum of Open Quantity across all lines (each PO Receipt will continue to appear only once in the GI with this option): add the PO Receipt line DAC to the PO Receipts Generic Inquiry, add the Open Qty field and Group by PO Receipt Type & PO Receipt Nbr.

I hope this idea helps you.


  • Author
  • April 29, 2026

@Laura03 in the report designer is there a way for me to show open qty/back order per receipt line on that PO receipt without it duplicating and would you know how? as for the GI it would be open qty as a total for that one PO receipt and it doesn't duplicate. 


Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • April 29, 2026

Hello,

 

It will be helpful if you show screenshots of what you want so we can make the correct recommendation.


  • Author
  • April 29, 2026

@Laura03 thank you. The GI is grouped by receipt number.