web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / logic for Aged AR report
Small and medium business | Business Central, N...
Answered

logic for Aged AR report

(0) ShareShare
ReportReport
Posted on by IIMO 30

Hello, 

I am working on a Power BI report to show the AR amount for customer on the last day of month. For example if the user select feb 2020, I want to display AR value for the customer on that day.

I can get the amount from Aged Accounts receivable(standard report in BC) report when I select the 02/29/20 on the report for the customer. I do not know what logic or what table that AGed AR uses to calculate that value, I want to display that value in the power Bi report

I have the same question (0)
  • Suggested answer
    John Ray Patajo Profile Picture
    John Ray Patajo 837 on at

    Hi,

    Use Customer Ledger Entries and check the application to Detailed Customer Ledger Entries table.

    Regards.

  • Kelbi Profile Picture
    Kelbi 10 on at

    Did you solve this?  I tried to left join customer Ledger entry on detailed customer Ledger entry (entry no), to get closed at date and due date on the detailed customer entry - but i dont get all the Logic behind the ar report to get the right result.

  • Verified answer
    IIMO Profile Picture
    IIMO 30 on at

    Yes,

    Its calculation of everything in the detail customer ledger entry with a posting date prior to your as of date

  • Kelbi Profile Picture
    Kelbi 10 on at

    Thank you. I made burets with 1-30 etc. Which works fine, but i have some troubles with the Logic behind not due yet. Sometimes it includes payments and creditmemes after the as of date, and sometimes not.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,260 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,515 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,373

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans