Filter data for most recent record at the relationship level

  • 20 February 2024
  • 0 replies

Userlevel 5
Badge +1

Anyone know if it is possible to filter by the most recent record at the relationship level? For example:


In the above join between the Customer and the CRActivity tables, is it possible to add a condition in the active relations to limit to the most recent record? I’m trying to get the last activity date, and I know I can group the records by the Customer ID and set the Aggregate Function to MAX on the results grid to display the last activity date, but that is causing some other unwanted issues with other calculated fields.

0 replies

Be the first to reply!


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