Skip to Content
Author's profile photo ManiKumar Yandrapu

Open item Management activation process

Activation of Open item management:-

I would like to share one document, where you can learn how to activate the open item management with using of existing SAP tools. SAP given tool activates OI for GL accounts since ECC 600 onwards, if balances existed ,but suggestible to use from ECC 603 onwards as per SAP note 1770786.

What is open item management:- 

In technical point of view it is just check box of control data tab in GL master data (FS00).Check screen shot as marked.

Doc1.png

In Functional point of view, it would be control all outstanding’s ,which will be receive from customer’s and pay to vendor’s / Employees / Govt.authoirities etc. in each and every line item of respective GL account reports. It should be give clear report, which line item / invoice has to be paid to vendor and received from customers. One red / Green symbol as below mentioned will be appear in standard report like FBL3N, FBL5N, and FBL1N & FAGLL03 report ,if you marked as open item management check box in GL master. Red symbol states those line items are still open and yet to clear & green symbol line items states those line items are cleared.

Accounts to be managed as Open item management:-

  1. Bank clearing GL accounts: – All bank sub ledgers like Bank incoming payments & outgoing payment GL account must be select as open item management & it will be help us for bank reconcialtion purpose.
  2. Payable GL accounts :- Like salary payable ,commission payable ,wages payable Freight payable & other tax related GL accounts like VAT payable must be select as open item management & it will be guide to FI department line item was tracking whether outstanding line items are paid to vendor’s / employees and VAT authorities or not.
  3. GRIR Clearing accounts: – You easily recognize your contingency liability status of GRIR accounts, if you activated OI management.

Process to activate the OI Management:-

Case 1:- Activate open item management for GL account with existing all line items:-

Transaction code: – FAGL_ACTIVATE_OP

You can able to activate OI for all existing line items with using of above transaction. Let us assume there is one GL account as mentioned screen shot, which was not maintained as OI and posted several line items & now you want to activate open item management for all existing line items.

dOC2.png

FAGLL03 report view (Before activation of Open item management)

Doc3.png

Let us assume now business would like to activate all above line items as open with using of above program. Go to that transaction code & do as follows.

Doc4.png

Enter company code & GL account number, which is to be activating as OI & switch on date should be before the line items was posted with respect to above GL.In above case study my first document posted on 01.04.2013 ,that means switch on date should be earlier than 01.04.2013.  Document type & account for transfer posting is not required, if you enter switch on date earlier than my first document posting date & enter profit center and segment, which are mandatory & execute.

Mentioned log would shown

Doc5.png

Display must not be red mode, it should be green or yellow mode. Comeback from above screen & unselect test run & execute.

Doc6.png

Doc7.png

Check above log ,which was given information about how many line item has been activated as open items & any transfer document posted or not. Now go to FAGLL03 & check whether line item activated as open item management and also check GL master activated for OI check box or not.

Doc 8.png

/wp-content/uploads/2014/06/doc9_481813.png

Check mentioned applicable SAP notes, which can give more details.

1356457 – Function of FAGL_ACTIVATE_OP

1349772 – FAGL_ACTIVATE_OP: Standard open item management

1770786 – FAQ – Open Item Management – FAGL_ACTIVATE_OP

Regards

Mani Kumar

Assigned Tags

      25 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Murali Babu Nallamothu
      Murali Babu Nallamothu

      Thank you for sharing this Mani.

      Rgds

      MBN

      Author's profile photo Former Member
      Former Member

      Hi Mani,

      Useful thanks to share.

      Thanks

      Lakshmi

      Author's profile photo MOORTHY ESAKKY
      MOORTHY ESAKKY

      Nice helpful document

       

      Thanks for sharing..

       

      Moorthy Esakky

       

      Author's profile photo Narasimhulu Konnipati
      Narasimhulu Konnipati

      Nice document Mani garu....

      This helps as a reference document for all the consultants to provide the appropriate solution.

      Keep it up.

      Thanks,

      NSK

      Author's profile photo Sreekanta Marikeri
      Sreekanta Marikeri

      Thank you Mani Kumar....for sharing very good document....

      Author's profile photo ManiKumar Yandrapu
      ManiKumar Yandrapu
      Blog Post Author

      Thanks to all

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama

      Hello Mani,

      Very good document and we are expecting more contributions from your end.

      Could you pls clarify my doubt once?

      Before activing the OIM for any GL is it required to block the GL account at any level or transferring the balance to another GL account required.

      Please help me to get the answers these queries.

      Thanks & Regards,

      Lakshmi S

      Author's profile photo Atul Walvekar
      Atul Walvekar

      Hi lakshmi,

      As i know in ECC 6.0 FAGL_ACTIVATE_OP does not require blocking GL and transferring the amount , as you can see in log itself the program itself will carry all activities.

      @mani...please share your view...& thanks for your contribution .

      Regards

      Atul

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama

      Hi Atul,

      Thanks for your reply.

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Hi Lakshmi,

      As Atul mentioned, the program does the transfer automatically and transfers the postings back to the original GLs if the "Perform Reposting" tick is enable as shown in the screen shot in the above document.

      There were a series of steps to be followed (including blocking of GLs) in earlier versions before this T-Code was released.

      Regards,

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama

      Hi Ganesh,

      I am agreeing with your answer. Yes, in earlier versions of SAP we have to follow series of steps in order to enable the OIM in GL account.

      Thanks for your clarification.

      Regards,

      Lakshmi S

      Author's profile photo ManiKumar Yandrapu
      ManiKumar Yandrapu
      Blog Post Author

      Hi Lakshmi,

      Thansk! I agree with Mr.Atul and Ganesh. No additional psoting's required like transfer from one GL account to another and also not required block any GL while activating the OI.

      As per my knowldege ,you must do the transfer entry for tax related GL accounts,if GL master having tax category as < OR >.

      Regards

      Mani Kumar

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama

      Hi Mani,

      Yes, you are correct. Thanks alot for your clarification.

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Thanks for sharing.

      Very useful

      Thanks

      Muhammed Riyas C

      Author's profile photo Siwar TALEB
      Siwar TALEB

      Hello,

      Thanks for sharing, it's really useful.

      What about the deactivation of OIM?

      Are there any rules to follow?

      Many Thanks ,

      Regards

      Siwar

      Author's profile photo Rohit raj
      Rohit raj

      Hi Mani,

      Nice document.... I really appreciate your efforts for helping others by sharing superb documents.

      Regards,

      Rohit raj.

      Author's profile photo Former Member
      Former Member

      Hi,

      Nice document. Thanks for sharing your knowledge.

      Regards

      Karthi

      Author's profile photo Former Member
      Former Member

      Thanks much for the document !!

      we are using SAP 6.0 EHP7 while activating open item management i am getting error as "specify an account with which to write of the balance"

      Appreciate your help in this regard !!

       

      Regards

      Niranjan Emparala

       

      Author's profile photo M Ahmed
      M Ahmed

      Hi Sir,

      You are a GEM as always.!

       

      Author's profile photo Former Member
      Former Member

      Hi Expert

      I am facing following issue in the process of Switch to Open Management.

      1. Company code XXXX is not considered for the activation
      2. A commitment item is required for company code XXXX

      Please suggest resolution for the same as have searched in the portals for the same.

      Regards

      Archana

      Author's profile photo Syed Muhammad Fahad Raza Shah
      Syed Muhammad Fahad Raza Shah

      Hi,

      Nice document Manikumar.

      I am facing the same error as mentioned by Archana. Any solution to this as no SAP Note is found on below mentioned issues :

      A commitment item is required for company code XXXX

      Message No. FAGL_SWITCH_OP201

      Company code XXXX is not considered for the activation

      Message No. FAGL_SWITCH_OP051

       

      Thanks

      Fahad

      Author's profile photo Isac Taquedir
      Isac Taquedir

      Thank You,

       

      This is a very useful explanation. I did what you explained, but I had the error bellow.

       

      Regards

       

      Isac Taquedir

      Author's profile photo MIRZA FAROOQ
      MIRZA FAROOQ

      GOOD BLOG...THANKS!!

      Author's profile photo Abin Binoy
      Abin Binoy

      Hi,

      I have tried doing this to one of my existing GL where transactions happened in previous year with dates older than first transaction and also with current dates, but i am getting errors:

      1)Balance of ledger 2L differs from the account balance

      2)Company code XXXX is not considered for activation.

      Please help.

      Author's profile photo Salvador Sánchez Gómez-Guillamon
      Salvador Sánchez Gómez-Guillamon

      Great post!

      Just mention, that in S4HANA environment, new program is available for this purpose ZFINS_SWITCH_TO_OPEN_ITEM.

      SAP NOTE: 2302566

      Salvador