#11115 [29.x ]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 (Department) when generating data, fixing incorrect figures that were appearing when dimension filters were combined with date filters.
- 5files
- 4AL files
- 4objects
Pull request · merged into releases/29.x (BC29) on 2026-09-08 by Shikhverma · 5 files (+296 -8), 4 AL · fix · tier official · reviewed (checked by Opus)
What changed
- Global Dimension 1 and 2 filters are now read from the G/L Account request record in the Trial Balance codeunit
- Dimension filters are applied with SetFilter on the query dimension columns for both the ending-date and opening-balance passes
- The standard, budget and consolidated Excel trial balance reports now offer the dimension filters as request filter fields, like the obsolete Trial Balance report
- By-period and previous-year reports use a separate path and are not covered
- Tests added for the dimension-filtered figures
- 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#649255
- Labels: AL: Apps (W1), Team: Finance
- Systems: finance
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).