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?