Production Detail Report Modification - Regroup RAW MATERIALS to Summate by Item

Kinetic ERP
1

Please advise on how to modify the Production Detail Report to Summate the RAW MATERIALS (ProdDtl_JobMtl subreport) by FIRST Product Group (we have this down) and then a summation by PART NUMBER instead of JobAsm, OprSeq, MtlSeq, etc.

We just need the hierarchy to be:

PRODUCT GROUP
----> Part #
---------> all the other Detailson the JobMtl subreport.I’ve tried SO MANY THINGS. The grouping changes DO NOT WORK. Changing the params on the main ProdDtl & ProdDtl_JobMtl to look @ Part # don’t work.

I’ve tried so many different things, and checked the code on the back end of the report, creating a new subreport. Etc, it does not work. :frowning:

I am at a loss.

2

Welcome, Andrea. If you can post a marked up copy of the out-of-the-box report showing what you would like it to be would help us in providing you some direction.