Skip to main content

Notifications

Business Central forum
Suggested answer

Creating an aged AR report similar to the built in Business Central report.

Posted on by 2

I am trying to create the aged AR report in Power BI.  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. 

I need to know what happens behind the scenes when I Filter Totals By "Date Filter" as shown below in order to produce the same data,   I want the user to be able to input a date in Power BI to filter the same way.
 

What tables should I be using and how should they be related?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 71,222 Super User 2024 Season 2 on at
    Creating an aged AR report similar to the built in Business Central report.
    Hi, This is FlowFilters, which can be used to filter the value of Flowfield.
    More details:
     
    Hope this helps as well.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,422 Super User 2024 Season 2 on at
    Creating an aged AR report similar to the built in Business Central report.

    The 'Filter totals by' option applies a date filter to all FlowFields on the page. FlowFields, such as the amount fields, are dynamic calculations based on underlying transactions. When you use this filter, it shows only the transactions that contribute to the FlowField values within your specified date range.

    For example, if you set a date filter for the last month, the FlowFields will display totals based only on transactions from that period. This is similar to how you would apply a posting date filter to ledger entry tables in PowerBI.

    I've written a detailed blog post about FlowFields that you might find helpful for further understanding here

     

    Valentin Castravet
    Work: Zander ERP Services
    Blog:  Dynamics 365 Business Central Insights
    LinkedIn:  www.linkedin.com/in/valentin-c-0500a247/

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,782 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,067 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans