Finance | Project Operations, Human Resources, ...

Customer to Ledger Reconciliation Report wrong difference

(1) Share

Report

Posted on by WeepingAngel

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)

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
WeepingAngel 47 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No