I am creating a Processing Screen in Acumatica and I need to calculate a value for one of the grid columns.
The calculation should work like this:
I need to fetch data from other tables.
Apply grouping/aggregation (for example, MAX(date) per some key).
Display the result in a column in the Processing Screen grid.
I am looking for the best practice approach to implement this in Acumatica.
Specifically, I am not sure whether I should:
Use a Projection DAC with Select + GroupBy to pre-calculate the value.
Use PXFormula or some other BQL trick.
What is the recommended way to compute aggregated values from other tables for a Processing Screen column in Acumatica?