Does anyone have a report suggestion for getting invoiced and entered orders within the same report (attached) without having to rebuild all the structure.
Solved
Invoiced Orders and Entered Orders Report - MTD
Best answer by bwaldie
yeah i ended up rebuilding the report. report designer is just very cumbersome compared to ssrs. hopefully acumatica will address the quirks their designer has. GI’s are great except when you have people that just want a report emailed to them without having to navigate into your ERP solution.
Hi
Since your report already has the grouping structure built, the cleaner approach is to modify the main dataset to UNION ALL the Invoiced Orders query and the Entered Orders query into a single dataset, adding a constant field such as ‘OrderType’ in each SELECT to distinguish them.
Then adjust your existing Sum() expressions to conditionally total based on OrderType (e.g., =Sum(IIf([OrderType]='Invoiced',[Amount],0))).
This lets both sets of data use the same grouping and footer totals without rebuilding the report layout.
yeah i ended up rebuilding the report. report designer is just very cumbersome compared to ssrs. hopefully acumatica will address the quirks their designer has. GI’s are great except when you have people that just want a report emailed to them without having to navigate into your ERP solution.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.