Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Customer to Ledger Reconciliation Report wrong difference

Posted on by 41
Hello,
 
We have a problem with the Customer/Ledger reconciliation report that we've managed to find in Contoso as well so I will showcase this with Contoso data. 
 
 
Could anyone please explain why the report is showing the Difference as 0 in the first section? This is pure Contoso, no customizations. Company USMF, we are running the report for the date March 31, 2015. The same issue is both with the parameters Differences only = yes and no.
 
This transaction always pops up with a difference in the second section, but difference = 0 in the first section. We would expect to see the difference as (Customer balance - Ledger balance) in both cases. This way the total sum of differences (both by account, as well as the grand total) is not correct.
 
Is this a bug or are we missing some interpretation?
 
I did find one other thread which described pretty much this same problem but the reply was that this is standard behaviour?? Solved: Wrong data in Ledger reconciliation report after changing customer group (dynamics.com)
  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,039 Super User 2024 Season 2 on at
    Customer to Ledger Reconciliation Report wrong difference
    Hi ,
     
    I think there is some issue with this type of transaction. 
     
    I tried looking in to it and seems this is intercompany transaction and same voucher is also available in DEMF company .
     
    ON your screenshot as well on first line it doesn't show the journal number and it might be because of intercompany
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,902 Super User 2024 Season 2 on at
    Customer to Ledger Reconciliation Report wrong difference
    Hi WeepingAngel,
     
    It might be related to your demo data. Are you able to create a new environment and check it with a fresh demo database? I do assume there is no customization in this area.
  • WeepingAngel Profile Picture
    WeepingAngel 41 on at
    Customer to Ledger Reconciliation Report wrong difference
    Hi André, I've updated our environment to the latest version we've got available but the situation still persists.
     
     
    I noticed you ran the report with Show details = No. My screenshot is for Show details = Yes.
    If I run the report with Show details = No like you, then I get the expected amounts, but they are actually still different than yours. :D 
     
     
    I find it very strange that the totals would differ depending on whether we are showing details or not. 
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,902 Super User 2024 Season 2 on at
    Customer to Ledger Reconciliation Report wrong difference
    Hi WeepingAngel.

    I just tried to reproduce the issue and I have the correct results. I ran the report using version 10.0.40.2. If you are on an older version, it might have been a bug that is solved. Or it is a data issue in your demo environment.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

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,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,336 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans