How to see Summarized view of generic inquiry for Ageing category of Production order

Hi ​@vishalsharma49 
 

In Generic Inquiry, aggregation and grouping must be configured separately. Using =Count([AMProdItem.ProdOrdID]) in the Data Field formula will not work correctly for grouped results.

Here is the correct approach:

1. In the Results Grid tab:

   • Keep your Aging Category calculated field as it is (do not apply any aggregate function to it).

   • Add AMProdItem.ProdOrdID as a normal field (do not use a formula).

   • In the Aggregate Function column for ProdOrdID, select COUNT.

   • Do not write =Count() in the Data Field.

2. In the Grouping tab:

   • Add the Aging Category field (your calculated field) to the grouping list.

   • Do not add ProdOrdID to the Grouping tab.

This setup tells the system to:

• Group records by Aging Category.

• Count the number of ProdOrdID values inside each group.

After this, your GI will show one row per Aging Category with the total number of production orders in each bucket.

If you still get unexpected results, check that:

• Aging Category is marked as Visible.

• There are no other fields in the Results Grid without an aggregate function (unless they are also included in the Grouping tab).
  
  
  Please let me know if any problem occurs.

Hi ​@aryanjadhav50 Aging category group is not there so is there any other alternate way ?

For this Scenario i think we can try two ways 
 

Option 1 – Recreate Aging Category as a non-aggregated calculated field

Make sure:

• The Aging Category formula does not contain any aggregate functions.

• Aggregate Function column for Aging Category is empty.

• It is added as a normal calculated field in Results Grid.

Then:

• Add AMProdItem.ProdOrdID

• Set Aggregate Function = COUNT

• Add Aging Category in the Grouping tab

If it still does not appear in the Grouping tab, delete and recreate the calculated field.

Option 2 – Use DateDiff directly in Grouping instead of Aging Category

Instead of grouping by the text category (0–30 Days, 31–60 Days, etc.), you can:

1. Add a calculated numeric field:
   =DateDiff('d',[AMProdItem.StartDate],Today())

2. Add this numeric field to the Grouping tab.

3. Then create multiple COUNT columns using conditional formulas like:

   Case When DateDiff <= 30 Then 1 Else 0 End
   Aggregate Function = SUM

   Case When DateDiff Between 31 And 60 Then 1 Else 0 End
   Aggregate Function = SUM

This gives you separate columns for each aging bucket instead of rows.

I hope this works..!!