Business Central Aged Receivables report in Power BI

(1) Share

Report

Posted on by RD-11011729-0

102

I need some help to create a Aged Receivables report as at a given date in Power BI with additional aged buckets. The user should be able to specify the date get this report. e.x. The user should be able to get a Aged Receivables report as at 31.03.2025

I'm able to produce the same data as the Aged AR report when looking at the Customer Ledger Entries table and applying the filters as shown below. What BC tales should I connect in Power BI to produce this report where user will have the ability specify the date like 31/03/2023 below

I do I connect this filtered data to the Power BI dashboard so that I can create my own AR report with the required aged buckets

Appreciate some help