Skip to main content
Solved

GI Parameter - filter the counted number after grouping

  • 31 July 2023
  • 1 reply
  • 56 views

Hi, I am creating a GI and meet some problem on parameter.

Here are my parameters requirement:

  1. No of PO (counted nbr, not ref nbr)

I am using COUNT at the aggregate function and grouping the record with vendor, the result of the ref num will become counting how many PO of the vendors. 

 

My question is how can I make the parameter to filter the counted number but not the ref number? attached with the GI XML, thank you.

 

 

1 reply

Userlevel 7
Badge +12

Hi @yansiongyu54 

Please review the suggestions below https://www.augforums.com/forums/acumatica-generic-inquiries/using-parameters-to-filter-aggregate-results/

Reply