---
id: change/bcapps/11115
type: change
title: "#11115 [29.x ]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 (Department) when generating data, fixing incorrect figures that were appearing when dimension filters were combined with date filters.
tier: official
language: en
tags:
  - fix
  - releases/29.x
  - bc29
  - 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:06:11.196Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: 0c7b46a443adaa4cd4066a8cfa132d52eddc3a77
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/pull/11115
    title: "microsoft/BCApps#11115: [29.x ]Trial Balance (Excel) report shows incorrect figures and formatting differences compared to Trial Balance (Obsolete) report in Business Central v28.2"
    date: "2026-09-08"
    commit: 0c7b46a443adaa4cd4066a8cfa132d52eddc3a77
    t: null
    quote: null
links:
  learn: []
  objects:
    - object/report/4410
    - object/report/4406
    - object/report/4405
    - object/codeunit/4410
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 11115
repo: microsoft/BCApps
source_id: bcapps-prs
url: https://github.com/microsoft/BCApps/pull/11115
kind: pr
base_branch: releases/29.x
major: "29"
merged_at: "2026-09-08T07:33:00Z"
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: 296
  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:
  - 649255
systems:
  - finance
quote: null
joined_against:
  major: "29"
  commit: 1d24dd5ee2a734510f0556ccc69342d0e616db2f
---

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

[Pull request](https://github.com/microsoft/BCApps/pull/11115) · 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"](../../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#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).