Is there a way to filter the fields in a drop down list for a parameter in report designer to only show for a particular value (e.g., only list invoices for a particular customer rather than all customers)? We don’t want to use “Additional Sort and Filters” or filter the column since we want the viewer to get to the data without having to add filters.
Thank you!
Best answer by yhartman
View originalHi,
The way Acumatica solves this issue is by designing a DAC specific to the report. The DAC contains all the fields with the required filters. In Acumatica the DACs are usually suffixed with “ReportParameters.”
Haven’t done a lot of reports in Acumatica. I see this in the DAC for Customer ID:
We limit which customers are the choices that users can choose:
And then since the customer is one of the choices in the report parameters, want to only have the invoices for the specific customer in the Reference Number list. Do I use ARInvoice.CustomerIDReportParameters in the Data Field? Thank you.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
