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.
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.
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
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.
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
Yes I checked that and aging is matching with customer balance list report.
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?
These are posted through accounts receivable payments. Customer transactions. (Posting type customer balance)
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
Martin Dráb
510
Most Valuable Professional
Saalim Ansari
315
Adis
312
Super User 2025 Season 1