#9195 Fix Aged Accounts Receivable (Report 120) performance on large ledger history

The Aged Accounts Receivable report (Report 120) now reads only the four columns it needs from Detailed Cust. Ledg. Entry inside its per-row loop. This lowers the per-row SQL cost on databases with long ledger history.

3files

3AL files

1objects

Pull request · merged into main (BC30) on 2026-07-09 by ventselartur · 3 files (+3 -0), 3 AL · performance · tier official · reviewed (checked by Opus)

What changed

SetLoadFields added to the Detailed Cust. Ledg. Entry loop for Entry Type, Posting Date, Amount and Amount (LCY)
Reduces per-row SQL cost in a loop that scales with detailed ledger history
Same change applied to the W1, ES and NA base layers

AL objects touched

Report 120 “Aged Accounts Receivable”, Base Application: modified
src/Layers/ES/BaseApp/Sales/Reports/AgedAccountsReceivable.Report.al: modified, not in the BC30 snapshot

Context

Work items: AB#640854
Systems: sales

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