Jul 16, 2020

Changing a GL Account to Open item managed in S/4 HANA

For those like me that are coming from the old Era of SAP ECC6.0 or before, we used to have 2 different Abap programs that we could run to Switch ON/OFF the Open Item Management flag out of a GL Account Master Data.
Programs
RFSEPA03  Switch OFF Open Item Management
RFSEPA02  Switch ON Open Item Management

This was really helpful because either during Project or Production Support, somehow there was always the need to Flag or Unflag a GL account in terms of "Open Item Management". With the help of those 2 programs, we were able to troubleshoot this requirement.

Now in S/4 HANA those 2 programs are obsolete and cannot be used anymore. They have been replaced by a new program FINS_SWITCH_TO_OPEN_ITEM, it even has its own Tcode too FAGL_ACTIVATE_OP or FINS_ACTIVATE_OIM.

But first to be able to have access and use this program you need to implement an OSS Note that will bring this program into your environment ( 2745769 - FINS_SWITCH_TO_OPEN_ITEM: Activation of Open Item Management ).

Once the OSS Note is Implemented, you can Execute the program.



  • With this program you can either Activate or De-activate the Open Item Management of any GL Account.
  • It has to be run Account by Account, you cannot execute multiple GL Accounts at the same time.
  • But, you can do it for Multiple Company Codes.
  • You can Switch on at a specific Date.

For the "Test run" mode you can do it online, but once you remove the Test run it needs to be executed in the Background and then you will have to review the Execution Log.

Once the program executed, you can verify you GL Account Master Data (FS00) and you will see that the "Open Item Management" flag has been removed or added to the GL record.


If your Company and/or Project needs to implement this, or any of the functionalities described in my Blog, or advise about them, do not hesitate to reach out to me and I will be happy to provide you my services.

20 comments:

  1. What about already posted documents? Do we need to to transfer to any other GL or not?

    ReplyDelete
    Replies
    1. No, you do not need to do anything with posted documents. That is if you were changing the currency of the Account that you have to transfer them out and then back again. But not for changing the Open item flag.

      Delete
  2. What if there are archived documents?

    ReplyDelete
    Replies
    1. What difference would that make ? You are changing the flag of a GL Account which is Master Data, nothing on FI Documents. I don't understand your question.

      Delete
  3. Thanks for this blog. Very useful. In my client they have already posted documents in the GL and now we want activate open item management as it is GR/IR account which has to be cleared using f.13. In this case once I activate the open item management for that GL will the old documents posted without open item management selection. How can we clear them ?

    ReplyDelete
    Replies
    1. Unfortunately old posted line items that were not Open Items, will not turn into Open items after changing the GL accounts. Changes for future line items and not for the past line items.

      Delete
    2. suppose i have posted a entry in GL GR/IR account which is only line item management. then i noticed that the GR/IR account is not managed open item management. now i want to make this as open item management then how to do it also i want the gl posted earlier line item only want to make that entry open item. can we do that.can u give me an example with screen shot.

      Delete
    3. Hi, I don't understand properly what is your requirement. If you could please re-articulate it ?
      What I can tell you is that whatever has been posted, cannot be modified to make open item managed or not. This is only going forward.

      Delete
  4. I have many accounts where I have to deactivate OIM. Are there any programs that can handle many accounts at the same time?

    ReplyDelete
    Replies
    1. No, you will have to do it one account a time. If you have many accounts to do, it means that your Chart of Accounts was in really bad shape.

      Delete
  5. Yes you are right. Now I have accidentally disabled OIM on an account. when I now try to activate OIM again I get an error that says that there are archived (deleted) records in the account and therefore OIM can not be activated. What can I do about it?

    ReplyDelete
    Replies
    1. I have no idea, I have not faced that issue yet.

      Delete
  6. I have an GL account to activate Open item management but while executing this program system is giving error Company code XXXX is not considered for the activation. Can you suggest how can I activate Open Item Management for my Company code.

    ReplyDelete
    Replies
    1. No idea about it, you might want to read the long text of the error to see if it gives you a little bit more info. Maybe the GL Account is already IO Managed in that specific CoCode ?

      Delete
  7. Hi I implemented the OSS but cannot access the Tcode FINS_ACTIVATE_OIM..

    ReplyDelete
    Replies
    1. You could access the program directly by calling it through SE38 (FINS_SWITCH_TO_OPEN_ITEM). If an Abaper implemented the OSS Note for you, he might have not done the creation of the Tcode if the Note does not do that automatically. But call the program directly

      Delete
  8. Hi Adrian.. I have read all the comments.. thanks for your response to each of them. Now I am going to activate OIM.. and i expect the changes for old transactions only.. So how to do.. Should i go with this only option "Creating new GL account with OIM and move the balances from the old GL to new GL??? How to do for a bulk transactions (Ex. 5 Years of data). Pls advise..

    ReplyDelete
    Replies
    1. when you turn on Open Item in an account, you do it from now on, not retroactively. You are trying to say that you need to do this for the last 5 years ?? You are telling me that your business have not reconciled that account for the last 5 years?, now you are going to make it OI Managed and want to re-post line items for the last 5 years ??? It does not make any sense to do that. No one is going to reconcile 5 years. I would not repost anything bigger than the current year (at a maximum). But in my case, I would tell them that this is from now on, for the past they should do it the way they were doing it in until today (most likely Excel).

      Delete
  9. hello Adrian,
    how to execute OIM conversion program in S4 Hana public cloud multi tenant? is there a fiori app available?
    thanks
    Juan

    ReplyDelete
    Replies
    1. I would not know if that option is on the S/4 HANA Cloud product. I only work with on-premise S/4 HANA solution. Try to look around for OSS Notes that would talk about this for the Cloud product.

      Delete