---
id: change/bcapps/10412
type: change
title: "#10412 Fixes in Excel reports for Aged Accounts."
summary: Aged Accounts Excel reports now properly handle customers and vendors with historical balances outside the selected date range and correctly assign transactions to aging buckets.
tier: official
language: en
tags:
  - fix
  - main
  - bc30
  - report exr aged acc payable excel
  - report exr aged accounts rec excel
  - table exr aging report buffer
system: finance
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:07:44.267Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: 32b36e1b41600c9699379a5b7482bbe82b7df83c
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/pull/10412
    title: "microsoft/BCApps#10412: Fixes in Excel reports for Aged Accounts."
    date: "2026-08-24"
    commit: 32b36e1b41600c9699379a5b7482bbe82b7df83c
    t: null
    quote: The aged buckets were not covering the whole history for a customer, only bounded to the end date supplied.
links:
  learn: []
  objects:
    - object/report/4403
    - object/report/4402
    - object/table/4401
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 10412
repo: microsoft/BCApps
source_id: bcapps-prs
url: https://github.com/microsoft/BCApps/pull/10412
kind: pr
base_branch: main
major: "30"
merged_at: "2026-08-24T15:25:02Z"
author: mynjj
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: 4
  additions: 246
  deletions: 84
  al: 3
apps:
  - ExcelReports
objects_touched:
  - key: report/4403
    page: report/4403
    type: report
    id: 4403
    name: EXR Aged Acc Payable Excel
    app: ExcelReports
    status: modified
  - key: report/4402
    page: report/4402
    type: report
    id: 4402
    name: EXR Aged Accounts Rec Excel
    app: ExcelReports
    status: modified
  - key: table/4401
    page: table/4401
    type: table
    id: 4401
    name: EXR Aging Report Buffer
    app: ExcelReports
    status: modified
objects_unjoined: []
obsoletions: []
backports: []
fixes_issues: []
work_items:
  - 642030
systems:
  - finance
quote: The aged buckets were not covering the whole history for a customer, only bounded to the end date supplied.
joined_against:
  major: "30"
  commit: ecbc028c25dbe83b61313bc566e6c1d41184bb1c
---

# #10412 Fixes in Excel reports for Aged Accounts.

> Aged Accounts Excel reports now properly handle customers and vendors with historical balances outside the selected date range and correctly assign transactions to aging buckets.

[Pull request](https://github.com/microsoft/BCApps/pull/10412) · merged into `main` (BC30) on 2026-08-24 by mynjj · 4 files (+246 -84), 3 AL · fix · tier official · reviewed (checked by Opus)

## What changed

- Added a new aging bucket from 0D to cover all historical activity before the main period
- Fixed bucket assignment logic for ending dates by using index-based retrieval instead of descending list comparison
- Removed due date filter to include all outstanding balances regardless of due date status
- Filtering for customers/vendors without due balance now considers full history, not just the selected period
- Added comprehensive tests for historical balances, bucket assignment, and not-yet-due transactions
- Behaviour changes for users or extensions.

## AL objects touched

- [Report 4403 "EXR Aged Acc Payable Excel"](../../objects/report/4403.md), ExcelReports: modified
- [Report 4402 "EXR Aged Accounts Rec Excel"](../../objects/report/4402.md), ExcelReports: modified
- [Table 4401 "EXR Aging Report Buffer"](../../objects/table/4401.md), ExcelReports: modified

## Context

- Work items: AB#642030
- Labels: AL: Apps (W1), Team: Finance
- Systems: finance
- From the description: "The aged buckets were not covering the whole history for a customer, only bounded to the end date supplied."

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