BC Observatoryunofficial, made by waldo
code change · featureFinanceofficial - Microsoftreviewed - checked by Opus

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

Open in Claude9894.mdPull request #9894

Pull request · 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

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