Closing existing transactions on Production system

[Former Member]

Dear Gurus

I have a requirement to close some 60A transactions from the production system, (these deals are for another subsidiary which will have its own separate system going forward) my understanding is that

step 1 will be to reverse cleared documents, step 2 reverse all posted flows step 3 reverse the actual transactions on ftr _edit

Kindly advise if there are other steps to be done and best practise to execute this requirement.

regards

Victor

Edited by: Victor Nkomo on Jul 1, 2011 12:39 PM

[lorenz_sperl · Accepted solution]

Hi Victor,

...to be precise regarding the sequence (in case you want to move the deals with their entire "history"):

1) reverse cleared documents (-> FI-module)

2) fully reverse the actual transactions (FTR_EDIT)

3) reverse all posted flows (TPM10)

Finally, check TPM13 regarding posting-status...

Regards,

Lorenz

[Former Member · Accepted solution]

Thanks Lorenz

Am I correct to say after closing these transactions I can still display them through ftr_edit or on a report and for Audit puposes how does one archive reversed or terminated transactions.

Secondly executing first step to reverse cleared documents (note that these are cleared docs as a result of valuation: unrealised gain/loss) its derived fixed flows as a result of execution of TPM1 not TBB1). When i execute FBRA i get error

"The clearing document is a reversal that cannot be posted with FB08

Message no. F5A428

and when execute FB08 i get error

Not possible to reverse the document in financial accounting

Message no. F5673

Kindly assist

Regards

Edited by: Victor Nkomo on Jul 4, 2011 8:11 AM

Edited by: Victor Nkomo on Jul 4, 2011 11:26 AM

[Former Member · Accepted solution]

Hi Viktor

What Lorenz meant is if you have cleared the valuation finance documents. If you have not cleared them, then you do not have a need to reset/reverse them.

You can use TPM2 to reverse the actual valuation document.

You can still display the document using FTR_EDIT.

Hope this helps.

Thanks

Regards

Morgan

[Former Member · Accepted solution]

Viktor

You have to reverse the actual flows/transaction in FTR_EDIT before you execute TPM2 or TPM10.

Thanks

Regards

Morgan

[Former Member · Accepted solution]

Hi Morgan

Yes I did first reverse the transaction on ftr_edit, does that mean if. I successfully execute TPM2 there is no need to reverse cleared documents on FI? Secondly for audit purposes can one archived reversed transactions? Thank you in advance

Victor

[Former Member · Accepted solution]

Hi Viktor

Yes. If you are able to reverse flows successfully, that means your Finance documents are not linked to anything else. So all you need to do is just post the reversed flows in TPM2 or TPM10.

For audit purposes the reversed transactions will show up in every standard S_ALR report & you can also view them in R_EDIT as they are all still present int he table VTBFHA & VTBFHAPO.

I am not sure about archiving. I have not done that. I will defer this to someone else who is good at that.

Thanks

Regards

Morgan

[Former Member · Accepted solution]

Thanks Morgan, one more thing leaving cleared documents on FI won't those cleared documents affect the financials if not reversed on FI side?

[Former Member · Accepted solution]

Hi Viktor

To understand what a clearing document is, here we go: Every financial line item of a GL account that is open item managed is linked/locked to another line of a document. This is called as clearing. Meaning, you associate a credit to a debit or the other way round.

So in the case of your valuation financial document, if you do not have a clearing document associated to each line of the valuation document that you posted using TPM1, you can reverse it using TPM2/TPM10.

You only need to worry about clearing documents if you have cleared those valuation document line items using F-03 or F.13 tcodes (basically matched those debits/credits against some bank document or something else). Typically we do not do this & hence there was no need for you to worry. But then Lorenz' advice was generic to make sure that you go to the valuation document & double click in FB03 & you make sure there is no clearing document against each of the line items of the valuation document so that you do not come back & tell us there is an error.

Hope this helps.

Regards

Morgan

[Former Member · Accepted solution]

Thanks Morgani my problem has been resolved