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

Notifications

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... / Aged Accounts Receivab...
Small and medium business | Business Central, N...
Suggested Answer

Aged Accounts Receivables Report Sum Issue

(0) ShareShare
ReportReport
Posted on by MikhailC 30

Hello,

I have an issue with the Aged Accounts Receivables Report where the sum of all the values in the Balance column does not equal the Total(LCY). There is a difference of around 250 EUR between the sum and the total values. 

Has anyone experienced something like this before, or has any idea how to go about this? Any help would be appreciated.

I have the same question (0)
  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 211 User Group Leader on at

    Are you running using customer currency or not? You should review how you are running in relation to foreign currency as this is highly unusual

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,739 Super User 2025 Season 2 on at

    Hi, The data for the Aged Accounts Receivables Report comes from Cust. Ledger Entry, I think you can investigate these problem in Customer Ledger Entries.. 

    pastedimage1654130809852v1.png

    Hope this helps.

    Thanks.

    ZHU

  • MikhailC Profile Picture
    MikhailC 30 on at

    Most of the values are in EUR(LCY), however there are a couple of values which are in USD. I suspect that this is the issue then as the total would be calculated by converting all the USD values into LCY.

    The total and the sum still don't fully match up even when the USD values are converted with exchange rates, although the difference between them is less now.

  • MikhailC Profile Picture
    MikhailC 30 on at

    I figured out what the issue was. I obtained the converted values from the Amount(LCY) field in the Customer Ledger Entries table for the respective USD transactions. I was initially converting the values to EUR from USD using the exchange rate on the posting date for the transaction, which did not give good results. When summed the values give an amount equal to the total. 

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at

    Great work, thank you for sharing root cause / solution.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November 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,066

#2
YUN ZHU Profile Picture

YUN ZHU 658 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 595

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans