BC Observatoryunofficial, made by waldo
code change · fixPurchasing & Payablesofficial - Microsoftreviewed - checked by Opus

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

Open in Claude11366.mdPull request #11366

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

Also merged into

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