#10566 [main] Trial Balance (Excel) report shows incorrect figures and formatting differences compared to Trial Balance (Obsolete) report in Business Central v28.2
Trial Balance Excel reports now correctly apply Global Dimension filters when generating figures, fixing an issue where department filters were ignored and aggregated data included excluded dimensions.
- 5files
- 4AL files
- 4objects
Pull request · merged into main (BC30) on 2026-08-31 by Shikhverma · 5 files (+295 -8), 4 AL · fix · tier official · reviewed (checked by Opus)
What changed
- Codeunit Trial Balance now reads the Global Dimension 1 and 2 filters from the G/L Account request record
- Dimension filters are applied with SetFilter on the query dimension columns, for both the ending-date and opening-balance passes
- Fixes inflated totals when a department filter is combined with a date filter
- Covers the standard, budget and consolidated reports that use the query-based path; by-period and prev-year reports are out of scope
- Tests added for the Trial Balance Excel reports
- Behaviour changes for users or extensions.
AL objects touched
- Report 4410 “EXR Consolidated Trial Balance”, ExcelReports: modified
- Report 4406 “EXR Trial BalanceBudgetExcel”, ExcelReports: modified
- Report 4405 “EXR Trial Balance Excel”, ExcelReports: modified
- Codeunit 4410 “Trial Balance”, ExcelReports: modified
Context
- Work items: AB#647661
- Labels: AL: Apps (W1), Team: Finance
- Systems: finance
- From the description: “The Excel report collects its data through codeunit 4410 “Trial Balance”, which builds figures from the aggregation queries”
Source: metadata of a merged pull request in microsoft/BCApps (bcapps): title, labels, changed paths and counts, with a summary in our words. No source text and no description beyond one short quote (D10, D61).