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

Notifications

Announcements

No record found.

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 217

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
    217 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
    217 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
    217 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
    217 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

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…

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

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 464 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans