Skip to main content
Solved

How to calculate a date column in a Processing Screen using aggregated data from other tables

  • December 5, 2025
  • 2 replies
  • 23 views
B
Captain I
Forum|alt.badge.img+2

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?

Best answer by Django

You’re probably looking at using a view delegate for that. You’ll be able to run a query, even against a projection, and then access/process each record to do what you need it to do.

But, if you can make a projection to do the work then using that will allow you to offload the processing/calculation of that field to the database engine instead of within a view delegate which will yield you faster results.

2 replies

D
Captain II
Forum|alt.badge.img+7
  • Django
  • Captain II
  • Answer
  • December 5, 2025

You’re probably looking at using a view delegate for that. You’ll be able to run a query, even against a projection, and then access/process each record to do what you need it to do.

But, if you can make a projection to do the work then using that will allow you to offload the processing/calculation of that field to the database engine instead of within a view delegate which will yield you faster results.

Chris Hackett
B
B
Captain I
Forum|alt.badge.img+2
  • bihalivan15
  • Author
  • Captain I
  • December 5, 2025

You’re probably looking at using a view delegate for that. You’ll be able to run a query, even against a projection, and then access/process each record to do what you need it to do.

But, if you can make a projection to do the work then using that will allow you to offload the processing/calculation of that field to the database engine instead of within a view delegate which will yield you faster results.

I also need to apply a filter on the field (calculating the number of days from the current date). If I do this in the view delegate, the start row breaks. What to do about this?

Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved