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 :
Finance | Project Operations, Human Resources, ...
Answered

Customer reconciliation showing difference which can not be justified

(0) ShareShare
ReportReport
Posted on by 219

I assume this problem was not solved, I have similar issue in customer recon. Report shows customer balance as 0 and ledger balance as amount same as original transaction amount.

3884.recon.png

I verified transactions and they are nothing but accounts receivable payments (In some cases prepayments) and second line is different transaction with opposite impact. These 2 transactions are settled with each other but I dont understand the report as voucher posting is customer balance and account is restricted for manual entries.

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Vaibhav,

    Are those vouchers posted directly posted on ledger accounts or were they posted as ordinary customer transactions / invoices in the customer module?

    Can you share details of those vouchers and their transaction origin?

    Best regards,

    Ludwig

  • Vaibhav Sangave Profile Picture
    219 on at

    These are posted through accounts receivable payments. Customer transactions. (Posting type customer balance)

  • Suggested answer
    Junaid Idrees Profile Picture
    on at

    Hi Vaibhav Sangave,

    Did you check, Is your customer balance list/Customer Aging reports closing balance is matching with your ledger account or all reports are showing the similar result?

  • Vaibhav Sangave Profile Picture
    219 on at

    Yes I checked that and aging is matching with customer balance list report.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Vaibhav,

    Do you mind sharing a screenprint of the transaction origin of those vouchers?

    Also, can you check whether the AR summary accounts that were used when posting those vouchers are still setup in the AR customer posting profiles?!

    Many thanks and best regards,

    Ludwig

  • Vaibhav Sangave Profile Picture
    219 on at

    So strangely I am still having the difference but the transactions I attached above are no longer present. I believe I need to spend more time to understand behaviour ( I suspect users have done settlements so it may have removed difference but its a guess). I will come back and update. Apologies for inconvenience.

  • Verified answer
    Vaibhav Sangave Profile Picture
    219 on at

    So finally I was able to identify difference. Issue was related to posting profiles. User had configured same ledger account as main account as well as prepayment account. When the report was generated user applied posting profile filter. Subsequently when the prepayment payments were settled against invoices the difference went away. If the report is generated without posting profile as filter and then compared it is matching

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 March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 689

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 258 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans