Cancel a customers' payment in accounts receivable module

(0) Share

Report

Posted on by niq

Hi,

I'm trying to cancel a payment of a customer but the error message says "Unable to find ledger transaction for reversal. Verify that a ledger transaction exists for the cash account or bridging account."

What will I do with this.

Thank you

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi niq,

Where and how did you search for that customer payment and how did you try to cancel it?

Is it related to a check or electronic payment?

Have you used a bridging account for the payment that has already been offset (cleared) against a bank account?

Some additional information would help here :-)

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
niq 80 on at

Like (0)

Report

Hi Ludwig,

The payment was posted through the payment journal, the method of payment used was "check"

Then I am cancelling this payment in the customer transaction.

When I clicked the cancel payment button the error says

Hope these details help.

THank you Ludwig

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi niq,

I would expect that this reversal is not possible from the customer transactions form because (a) you have more than a single subledger involved (customer + bank) and (b) you have a check created./posted.

Can you do the reversal manually instead?

Ludwig

Was this reply helpful? Yes No
niq 80 on at

Like (0)

Report

Hi Ludwig,

How will i manually reverse this? Using the journal voucher?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi niq,

Yes, you can for example post the reversal in a daily GL journal or in the payment journal as you like to get your accounts right.

Has your customer actually paid the invoice?

If he hasn't just make sure that you chase her/him to get your money asap :-)

Best regards,

Ludwig

Was this reply helpful? Yes No
niq 80 on at

Like (0)

Report

Yes It was already paid.

I haven't tried manual reversals.

Can you give me an example for this.

Thank you

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi niq,

First check the original voucher that needs to be reversed. You can do this by opening the voucher and view the original document (Journal) where the transaction was posted).

You can then create another journal with the same posting types (bank & customer) but with an opposite sign of the amount. This will reverse your transaction.

However, before doing that can you check how the payment was posted because you mentioend that the invoice is already posted.

Was the payment just posted in the way DR (bank) vs. CR (customer)?

Can you find out if this payment has also been settled probably against a different (wrong) invoice? You can find this out in the closed transaction editing form from the customer record where you have to find your customer payment and AX will show (mark) the open invoices that have been matched against that payment.

Best regards,

Ludwig

Was this reply helpful? Yes No
niq 80 on at

Like (0)

Report

Hi Ludwig,

DR (Bank)

CR (Accounts Receivable)

That is how the payment was posted.

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

Like (1)

Report

Hi niq,

You can simply reverse this posting by flipping the DR and CR accounts.

This should be something that you can realize straightforward.

Yet, be aware and check also the things I mentioned especially in regards to the settlement.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I do have a doubt.

If we reverse the paid check manually, the status (Paid) will change cancelled?

Financially, the amount get reverse, but the status will not change right, it still show status(paid). Is there any problem when audit.

Buy doing manual reverse is the correct way, is there any impact when audit.

Thanks,

Rajasekar P

Was this reply helpful? Yes No