---
id: change/bcapps/10566
type: change
title: "#10566 [main] Trial Balance (Excel) report shows incorrect figures and formatting differences compared to Trial Balance (Obsolete) report in Business Central v28.2"
summary: 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.
tier: official
language: en
tags:
  - fix
  - main
  - bc30
  - report exr consolidated trial balance
  - report exr trial balancebudgetexcel
  - report exr trial balance excel
  - codeunit trial balance
system: finance
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:07:03.214Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: 99b78dced4332c93d5c58105cb3acd11d96a763d
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/pull/10566
    title: "microsoft/BCApps#10566: [main] Trial Balance (Excel) report shows incorrect figures and formatting differences compared to Trial Balance (Obsolete) report in Business Central v28.2"
    date: "2026-08-31"
    commit: 99b78dced4332c93d5c58105cb3acd11d96a763d
    t: null
    quote: The Excel report collects its data through codeunit 4410 "Trial Balance", which builds figures from the aggregation queries
links:
  learn: []
  objects:
    - object/report/4410
    - object/report/4406
    - object/report/4405
    - object/codeunit/4410
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 10566
repo: microsoft/BCApps
source_id: bcapps-prs
url: https://github.com/microsoft/BCApps/pull/10566
kind: pr
base_branch: main
major: "30"
merged_at: "2026-08-31T12:58:35Z"
author: Shikhverma
author_type: User
community_contribution: false
labels:
  - "AL: Apps (W1)"
  - "Team: Finance"
change_class: code
change_kind: fix
behavior_change: true
breaking: false
files:
  count: 5
  additions: 295
  deletions: 8
  al: 4
apps:
  - ExcelReports
objects_touched:
  - key: report/4410
    page: report/4410
    type: report
    id: 4410
    name: EXR Consolidated Trial Balance
    app: ExcelReports
    status: modified
  - key: report/4406
    page: report/4406
    type: report
    id: 4406
    name: EXR Trial BalanceBudgetExcel
    app: ExcelReports
    status: modified
  - key: report/4405
    page: report/4405
    type: report
    id: 4405
    name: EXR Trial Balance Excel
    app: ExcelReports
    status: modified
  - key: codeunit/4410
    page: codeunit/4410
    type: codeunit
    id: 4410
    name: Trial Balance
    app: ExcelReports
    status: modified
objects_unjoined: []
obsoletions: []
backports: []
fixes_issues: []
work_items:
  - 647661
systems:
  - finance
quote: The Excel report collects its data through codeunit 4410 "Trial Balance", which builds figures from the aggregation queries
joined_against:
  major: "30"
  commit: ecbc028c25dbe83b61313bc566e6c1d41184bb1c
---

# #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.

[Pull request](https://github.com/microsoft/BCApps/pull/10566) · 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"](../../objects/report/4410.md), ExcelReports: modified
- [Report 4406 "EXR Trial BalanceBudgetExcel"](../../objects/report/4406.md), ExcelReports: modified
- [Report 4405 "EXR Trial Balance Excel"](../../objects/report/4405.md), ExcelReports: modified
- [Codeunit 4410 "Trial Balance"](../../objects/codeunit/4410.md), 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).