Weirdness with Filters on GI MasterFinPeriod

  • 30 November 2022
  • 0 replies

Userlevel 5
Badge +2

I’ve discovered something a bit odd. I’ve replicated it with this trivial GI.

Run the query:

Now Apply a filter to the results:

(if you want to try this, use the Fin. Date from any record in your result set)


Now go back to the query, remove the grouping, run it and apply same filter:

This time I get the expected result:

The filter works on End Date with grouping enabled. Fin. Date is the only column with the issue. 

As a workaround in any GI with grouping enabled and using MasterFinPeriod I’ve had to switch to using End Date instead, which is Fin. Date + 1, and adjust any criteria against this column accordingly. 

Any ideas what’s going on?

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