This seems like a simple task, but I haven’t been able to find instructions that have worked.
I have an inquiry screen with a simple Filter DAC for the header and a Details DAC for the grid.
The grid contains a column “Commission”, and I need a summary field to display “Total Commission” either in the header or on the grid footer.
I’ve found an article Calculating Grid Totals on an Inquiry Form - Acumatica Developers Blog and followed the last (most advanced) example and I’m still getting inconsistent results when I have a mixture of header filters, shared filter tabs, and ad-hoc user filters applied.
I’ve been working on this for a few days and trying many different things, but always with mixed results.
If nothing else works, I’m willing to consider adding an action button that has to be clicked to refresh the total.
In a regular Generic Inquiry, a summary field can be defined for the footer, and the column total will reflect the total for all records in the grid view, regardless of how filters are applied to it. When paging is enabled, it will still show the total for all pages, not only records on the current page.
I want to apply this same type of calculation on my custom screen so that the total displays the sum for ALL records in the currently filtered data set.
Is there no object I can access that holds all the records in the filtered data set? The counter at the bottom displays total number of records and if paging is turned on, it displays for example, (1-200 of 12345 records). So I know the system knows which records are in the data set.
This screen also has a number of actions that can be performed on multiple selected records, which is why we’re not using a Generic Inquiry screen.