We had an issue in Treasury wherein some transactions had double postings so in order to resolve this issue we made the following steps:
- reversed the said transaction in TM07
- ran TPM10 for posting of reversal
- settled the transactions in TM06
- repost correct transaction through TBB1
Most of the transactions were processed without errors. However there are three transactions that we can not settle in TM06 because of an error that says "Transaction XX in Company Code XXX has status REVERSED. When we checked the transaction in TM03 the activity is "1 Contract" and status "3 REVERSED". We tried to change the status/activity so we can push through with the settlement but it would not allow us. Please advice us why this is happening and what we can do to resolve this. Thank you!
This is also my idea after simulating the scenario in QA server. But the question is, how was the transaction reversed twice? I processed around 100++ transactions simultaneously and once only. All other transactions were processed correctly except the four transactions that I described. Do you have any explanation for this? Thank you!
normally it doesn't happen that a transaction is reversed completely from the status "Settlement" already. It can be that they were reversed once before already, or that you reversed them accidentally twice though, or they were not settled in the first place, or maybe they were created with the wrong activity processing category in cutomizing (i.e. processing without settlement, field ABWTYP).
We have another issue in relation to this one. Since the transactions were reversed twice, the client wants to know if all related documents (purchase, interest accrual, etc) previously posted for the said transactions were reversed. When we tried to check the contract, document numbers of cash flows is not shown anymore. How do we find all posted documents including reversal documents in relation to a specific security transaction? Please advice.
even if the transaction is reversed, you have all the history of the transaction. Posted documents in TRM and FI are still posted until you reverse them to - they will be set to status "to reverse" in TRM, but you have to run TPM10 to reverse them in TRM and automatically also in FI.
Accruals you can reverse with TBB5 or TPM45, depending on which transaction you used for accrual (TBB4 or TPM44 respectively), valuations with TPM2.
In TPM20 you can set the flag to show posting journal also for reversed business transactions, so you can find the posting documents there.