Transaction cannot be reversed.

(0) Share

Report

Posted on by niq

I am trying to reverse a vendor transaction due to wrong posting. the transaction date was August 31, 2018, posting profile was Goods. But when i click the Reverse transaction button, this error shows.

3583.Capture.JPG

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (2)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Niq,

There are two issues here:

1. The original transaction was posted in a previous year that is possibly already closed / put on hold

2. You try to reverse a complex transaction that includes sales tax, a vendor, items. Such complex transactions cannot be reversed with the reversal funtionality as too many subledgers (tax, vendor, item, ledger) are involved.

If you want to do a correction of this transaction you can only do that manually either by creating a new and corrective PO or a simple GL correction voucher. Please note that a corrective PO would possibly the best option as your item prices and transactions will get corrected. However, such a PO correction creates inventory transactions that you might not want to have. Therefore, a simple GL correction might be ok.

Best regards,

Ludwig

Was this reply helpful? Yes No
niq 80 on at

Like (0)

Report

Hi ludwig,

I am sure that the transaction was created within the current fiscal year( jan 2018-december 2018). i would go for the item # 2, the entries for the transaction were these:

The error says that it has something to do with the sales tax.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello niq,

Even if the transaction is posted within the same year/period you cannot reverse it with the standard reversal functionality because too many subledgers are involved.

From your voucher, I see that you have an item transaction, a vendor transactions, taxes and the ledger affected.

You can check all the subledgers affected by clicking on the transaction origin button.

If more than two subledgers are involved in a transaction you can - in general - not reverse it automatically but have to record a manual adjustment posting.

Best regards,

Ludwig

Was this reply helpful? Yes No
niq 80 on at

Like (0)

Report

Hi ludwig,

now I understand it. However, upon verifying the voucher entries of the transaction with our accounting manager. The only subsidiary ledger in the transaction is the 3000 Accounts payable - Goods. that is why i still don't know why it is still not reversible.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello niq,

You have (1) ledger, (2) vendor and (3) sales tax.

Such a transaction cannot be reversed automatically.

Without the sales tax posting it might be possible. This is something you can possibly test in a demo/test environment.

Best regards,

Ludwig

Was this reply helpful? Yes No
niq 80 on at

Like (0)

Report

Hi Ludwig,

I am getting your method on this. In fact, I made a reversal in my test environment as you have suggested. Same manner of posting the transaction. The entries are here:

And I was able to reversed it.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello niq,

Is this the same transaction and makes use of the same subledgers?

Irrespective of that, I would like to ask you taking a look at the following MS docs sites that provide some additional insights into reversing transactions:

docs.microsoft.com/.../reverse-a-transaction

You can find additional tips and hints there for reversing entries simply by entering a search term in the search box in the left navigation pane.

Hope this helps.

Best regards,

Ludwig

Was this reply helpful? Yes No
niq 80 on at

Like (0)

Report

Hi Ludwig,

This is a different transaction, that is why i couldn't figure what is wrong. In my test environment the reversal worked, but in my live production it didn't.

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

Like (0)

Report

Hello niq,

If it is not exactly the same transaction then it is difficult to say why you can reverse the transaction one time in TEST but not in LIVE.

Have you checked the transaction origin of this other voucher that could be reversed?

Can you find a single transaction that can be reversed in TEST but not in LIVE?

Best regards,

Ludwig

Was this reply helpful? Yes No
niq 80 on at

Like (0)

Report

Hi Ludwig,

I restored the live database into my test environment so I can try to manipulate the transaction.

Now I can't reverse the transaction.

Was this reply helpful? Yes No