Skip to main content
Question

Report Designer, Grouping information and Summing information Help

hstone
Freshman II
Forum|alt.badge.img

I am working on updating a report and need a couple more tweaks that I can not figure out. This is the code I am using and the output I am getting.

 

I need the run time summation in the group Header Section 1 and I need the production orders in the section to be grouped together my the material needed for those items. Let me know if you need more information to figure out what I am asking for:

 

Thanks in advance!

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • 729 replies
  • March 11, 2025

​@hstone It sounds like you need to update the grouping conditions. In the out of the box version of the report only the Work Center ID is being grouped:

Adding in the [AMProdItem.InventoryID] could do this but then if there are different Production Numbers the system will have to decide which one to show

Samvel Petrosov
Chris Hackett
2 people like this
  • Samvel Petrosov
    Samvel Petrosov
  • Chris Hackett
    Chris Hackett
hstone
Freshman II
Forum|alt.badge.img
  • hstone
  • Author
  • Freshman II
  • 22 replies
  • March 11, 2025

​@BenjaminCrisman There are different production numbers with different inventory ids is part of the problem. For our Lasers we start with the same raw material and cut the different items so I am looking for a way to group the raw material to best utilize the material and the time on the machine for changing over. Any advice to that direction would be great!

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
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