Skip to main content

Notifications

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.

  • Verified answer
    Vaibhav Sangave Profile Picture
    217 on at
    RE: Customer reconciliation showing difference which can not be justified

    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

  • Vaibhav Sangave Profile Picture
    217 on at
    RE: Customer reconciliation showing difference which can not be justified

    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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Customer reconciliation showing difference which can not be justified

    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
    RE: Customer reconciliation showing difference which can not be justified

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

  • Suggested answer
    Junaid Idrees Profile Picture
    on at
    RE: Customer reconciliation showing difference which can not be justified

    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
    RE: Customer reconciliation showing difference which can not be justified

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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Customer reconciliation showing difference which can not be justified

    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

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

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

#1
Martin Dráb Profile Picture

Martin Dráb 510 Most Valuable Professional

#2
Saalim Ansari Profile Picture

Saalim Ansari 315

#3
Adis Profile Picture

Adis 312 Super User 2025 Season 1

Overall leaderboard

Product updates

Dynamics 365 release plans