I’ve discovered something a bit odd. I’ve replicated it with this trivial GI.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/b704875a-8f67-47ce-a4d0-5c00ceff72cd.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c22b23c3-e349-4e04-99f6-4315b5c7666a.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/ad355660-f6e1-4888-8b39-0d32731e07fb.png)
Run the query:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c097f9a8-eef2-4e1f-9bc1-9c346977eefb.png)
Now Apply a filter to the results:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/5568e276-efbd-4b3b-83b2-7271b6303e00.png)
(if you want to try this, use the Fin. Date from any record in your result set)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/f4fc0bab-4a3b-4f93-a1d2-9c2ef80bce9b.png)
Now go back to the query, remove the grouping, run it and apply same filter:
This time I get the expected result:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/dd9125f8-6d17-431f-ad9f-678f39214731.png)
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?