Skip to main content
Solved

How to display Child PO Qty for items tied to a Blanket Purchase Order


Forum|alt.badge.img

We have a generic inquiry that lists blanket purchase orders information. Unlike Blanket SOs, Blanket POs do not have a Child Orders tab- making it tricky to track child POs tied to them. 

 

SOOrder table has QtyOnOrders field, however POOrder table does not. How can I calculate Qty on Child POs and have it display on the GI?

The GI is not line specific it is only header specific. When I added POLine table, it replicates all the information which is not required.

The below snapshot is one from Blanket SO Gi, we would like to display something similar for the POs. How can we achieve this?

@lauraj46 - any ideas from you would be helpful as well! Thank you in advance! 

Best answer by lauraj46

Hi @kanupindi ,

See attached revised query.  Each result fields should either be grouped or have an aggregate function specified.  If you don’t want to SUM, you can choose MAX which will be the same for all records.

Take a look and let me know if you have other questions.

Laura

 

 

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

10 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • September 27, 2023

Hi @kanupindi ,

You will want to group on the parent fields and then use the Aggregate column to total the qty for the child orders.  Please attach the XML for your GI so far and I would be glad to take a look.

Laura


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 63 replies
  • September 27, 2023

Hi @lauraj46,

Thank you for your suggestion. I have attached the xml file below, thank you! 


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • Answer
  • September 27, 2023

Hi @kanupindi ,

See attached revised query.  Each result fields should either be grouped or have an aggregate function specified.  If you don’t want to SUM, you can choose MAX which will be the same for all records.

Take a look and let me know if you have other questions.

Laura

 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 63 replies
  • September 28, 2023

Hi @lauraj46, thank you for your suggestion. I will test this out and get back to you. Thank you!!


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 63 replies
  • September 28, 2023

Hi @lauraj46, thank you for your help. That worked - I just had to modify the relations and grouping to get accurate values. thank you again!


  • 2 replies
  • September 23, 2024

Hi @lauraj46 @kanupindi are you able to share a copy of this GI? As the link has expired. Thank you.


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • September 23, 2024

Hi @adelinejin ,

I’m reattaching the GI.  Hope this helps!

Laura


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • September 23, 2024

Hi @adelinejin ,

I am also attaching the xml file as a zip archive.  Maybe this will work better.

Laura


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • September 23, 2024

@adelinejin - you will likely need to wait until the below issue with the site is fixed

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • September 25, 2024

@adelinejin file downloads should be fixed


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