---
id: change/bcapps/9894
type: change
title: "#9894 Suppress zero-value rows in Trial Balance by Period"
summary: The Trial Balance by Period Excel report now suppresses rows with zero values by default and adds an optional request-page parameter to include them when needed.
tier: official
language: en
tags:
  - feature
  - main
  - bc30
  - report exr trial bal by period excel
system: finance
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:10:10.533Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: cd497b72f977ec0716094a1ca7bf2e5ac45d3205
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/pull/9894
    title: "microsoft/BCApps#9894: Suppress zero-value rows in Trial Balance by Period"
    date: "2026-08-06"
    commit: cd497b72f977ec0716094a1ca7bf2e5ac45d3205
    t: null
    quote: The report should support that behavior explicitly without making it the default.
links:
  learn: []
  objects:
    - object/report/4408
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 9894
repo: microsoft/BCApps
source_id: bcapps-prs
url: https://github.com/microsoft/BCApps/pull/9894
kind: pr
base_branch: main
major: "30"
merged_at: "2026-08-06T10:20:02Z"
author: djukicmilica
author_type: User
community_contribution: true
labels:
  - "ADO: Sync"
  - "AL: Apps (W1)"
  - From Fork
  - "Team: Finance"
change_class: code
change_kind: feature
behavior_change: true
breaking: false
files:
  count: 2
  additions: 90
  deletions: 1
  al: 1
apps:
  - ExcelReports
objects_touched:
  - key: report/4408
    page: report/4408
    type: report
    id: 4408
    name: EXR Trial Bal by Period Excel
    app: ExcelReports
    status: modified
objects_unjoined: []
obsoletions: []
backports: []
fixes_issues: []
work_items:
  - 644914
systems:
  - finance
quote: The report should support that behavior explicitly without making it the default.
joined_against:
  major: "30"
  commit: ecbc028c25dbe83b61313bc566e6c1d41184bb1c
---

# #9894 Suppress zero-value rows in Trial Balance by Period

> The Trial Balance by Period Excel report now suppresses rows with zero values by default and adds an optional request-page parameter to include them when needed.

[Pull request](https://github.com/microsoft/BCApps/pull/9894) · merged into `main` (BC30) on 2026-08-06 by djukicmilica (community contribution) · 2 files (+90 -1), 1 AL · feature · tier official · reviewed (checked by Opus)

## What changed

- Added a Show Lines with Zero Values request-page option that is disabled by default
- Fixed the report to exclude zero-value dimension combinations unless explicitly requested
- Reduces workbook size by eliminating irrelevant rows from dimension combinations
- Users can still access the complete set of dimension combinations when needed
- Added regression test coverage for both suppressed and included zero-value scenarios
- Behaviour changes for users or extensions.

## AL objects touched

- [Report 4408 "EXR Trial Bal by Period Excel"](../../objects/report/4408.md), ExcelReports: modified

## Context

- Work items: AB#644914
- Labels: ADO: Sync, AL: Apps (W1), From Fork, Team: Finance
- Systems: finance
- From the description: "The report should support that behavior explicitly without making it the default."

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