Skip to main content
Question

Year Filter and Grouping Conflict When Comparing Two Years by Day

  • February 20, 2026
  • 1 reply
  • 11 views
aryanjadhav50
Jr Varsity I
Forum|alt.badge.img+1

I have created a Daily Order Entry report to compare January 2025 and January 2026 side by side.

My requirement is to group the data only by Day (1–31) and combine both years into a single row per day.

In the report I have attached when I apply the year filter then in 2025 section I am getting the 2026 records as well and vice versa for 2026

I have already:

  • Updated the grouping conditions

  • Modified the date field formulas

  • Adjusted sorting

Has anyone faced this issue? What is the correct way to group by day only and compare two years side by side without getting duplicate rows?

I am attaching the screenshot and report file for reference.

Thanks.

Aryan Jadhav

1 reply

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • February 20, 2026

​@aryanjadhav50 You may need to have one year in the main report and use the relations to make sure data from only that year is coming in, and then in a subreport generate the prior year and then call in the subreport value to the main report.

Alternatively, you can try using variables or joining in the same table generating the data a second time and having one table alias be prior year (again using the relations to specify the dates of data to bring in) and then the other table alias being the current year, though you might be able to just use variables in the current report with the two table aliases, I’m not sure I’ve tried it before so I don’t have a working copy of this to draw off

    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