---
id: change/bcapps/11366
type: change
title: "#11366 Filter top customer and top vendor Excel reports on the posting group"
summary: The Top Customer and Top Vendor Excel reports now correctly filter on posting group by joining detailed ledger entries to their parent ledger entries, since posting group fields in detailed entries are often unfilled on existing tenants.
tier: official
language: en
tags:
  - fix
  - main
  - bc30
  - query exr top customer balance
  - query exr top vendor balance
system: purchasing
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:05:14.057Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: c3f7c5e53e9cd78850d4ac5dd2dd6557cd0e61fb
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/pull/11366
    title: "microsoft/BCApps#11366: Filter top customer and top vendor Excel reports on the posting group"
    date: "2026-09-15"
    commit: c3f7c5e53e9cd78850d4ac5dd2dd6557cd0e61fb
    t: null
    quote: The Top Customer and Top Vendor Excel reports returned nothing when you filtered them on a posting group.
links:
  learn: []
  objects:
    - object/query/4403
    - object/query/4401
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 11366
repo: microsoft/BCApps
source_id: bcapps-prs
url: https://github.com/microsoft/BCApps/pull/11366
kind: pr
base_branch: main
major: "30"
merged_at: "2026-09-15T08:39:47Z"
author: Explorer986
author_type: User
community_contribution: false
labels:
  - "AL: Apps (W1)"
  - "Team: SCM"
change_class: code
change_kind: fix
behavior_change: true
breaking: false
files:
  count: 3
  additions: 199
  deletions: 2
  al: 2
apps:
  - ExcelReports
objects_touched:
  - key: query/4403
    page: query/4403
    type: query
    id: 4403
    name: EXR Top Customer Balance
    app: ExcelReports
    status: modified
  - key: query/4401
    page: query/4401
    type: query
    id: 4401
    name: EXR Top Vendor Balance
    app: ExcelReports
    status: modified
objects_unjoined: []
obsoletions: []
backports:
  - number: 11495
    base: releases/29.x
    url: https://github.com/microsoft/BCApps/pull/11495
fixes_issues: []
work_items:
  - 649289
systems:
  - purchasing
  - sales
quote: The Top Customer and Top Vendor Excel reports returned nothing when you filtered them on a posting group.
joined_against:
  major: "30"
  commit: ecbc028c25dbe83b61313bc566e6c1d41184bb1c
---

# #11366 Filter top customer and top vendor Excel reports on the posting group

> The Top Customer and Top Vendor Excel reports now correctly filter on posting group by joining detailed ledger entries to their parent ledger entries, since posting group fields in detailed entries are often unfilled on existing tenants.

[Pull request](https://github.com/microsoft/BCApps/pull/11366) · merged into `main` (BC30) on 2026-09-15 by Explorer986 · 3 files (+199 -2), 2 AL · fix · tier official · reviewed (checked by Opus)

## What changed

- Fixes filtering on posting group in Top Customer and Top Vendor Excel reports
- Reads posting group from parent ledger entry instead of detailed entry to avoid blank values
- Uses join on mandatory key field to preserve all rows and aggregation results
- No breaking changes to filter element names or Transfer Filters functionality
- Added test coverage for the corrected behavior
- Behaviour changes for users or extensions.

## AL objects touched

- [Query 4403 "EXR Top Customer Balance"](../../objects/query/4403.md), ExcelReports: modified
- [Query 4401 "EXR Top Vendor Balance"](../../objects/query/4401.md), ExcelReports: modified

## Also merged into

- [#11495](https://github.com/microsoft/BCApps/pull/11495) into `releases/29.x` on 2026-09-16

## Context

- Work items: AB#649289
- Labels: AL: Apps (W1), Team: SCM
- Systems: purchasing, sales
- From the description: "The Top Customer and Top Vendor Excel reports returned nothing when you filtered them on a posting group."

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