Customer/Ledger reconciliation - ledger balance is 0

(0) Share

Report

Posted on by Josh_

126

Hi all,

Im Printing a Customer / Ledger reconciliation report in gl -> reports -> recon -> customers. my question is why some values in ledger balance column is showing 0 amount? .

I've check the tables like SubledgerJournalAccountEntry and its AccountingCurrencyAmount has an amount in it, can anyone explain why its coming incorrectly or its happening because of its transaction.

Thanks in Advance

3113.01.PNG

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Kenneth Sy,

That is an interesting question :-)

Can you check the DNW00... voucher where you have a $0 ledger balance to find out why there is a customer balance only?

Please check the vouchers and their transaction origin.

Would be great if you could post a screenprint of what you see in the Transaction origin Screens.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Josh_ 126 on at

Like (0)

Report

Hello Ludwig Reinhard,

thanks for your response :)

this is the output in transaction origin

Thanks

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Aha. This is interesting.

The ledger balance is actually reversed with the original posting (+/- amounts)

Do you know how this voucher was created?

Try to follow the origin by clicking on the original document button and then open the Journal/form...

Best regards,

Ludwig

Was this reply helpful? Yes No
Josh_ 126 on at

Like (0)

Report

Hi ludwig

Is this the one?

How can check if theres a problem in the transaction?

thank you

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Yes,

Can you select 'show' and check what has been recorded in this free text invoice?

I suspect that an invoice line has been created that posts a transaction on the AR summary account.

Best regards,

Ludwig

Was this reply helpful? Yes No
Josh_ 126 on at

Like (0)

Report

Hi ludwig,

Pardon for late response.

Yes, theres a line that has been recorded, its actually weird but do you have any idea why is this happened?

kind regards,

kenneth

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Kenneth,

Can you share some details of the free text invoice and your customer posting profile setup?

Maybe a comment, description or attachment provides more details?!

If you can't find anything specific select the audit trial button on the voucher form to find out who posted the invoice and try to ask him/her.

Best regards

Ludwig

Was this reply helpful? Yes No
Vaibhav Sangave 217 on at

Like (0)

Report

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.

Was this reply helpful? Yes No