Skip to Content

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

To report this post you need to login first.

19 Comments

You must be Logged on to comment or reply to a post.

  1. 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

    (0) 
    1. 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

      (0) 
    2. Ganesh K.B.

      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,

      (0) 
      1. 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

        (0) 
    3. ManiKumar Yandrapu 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

      (0) 
  2. 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

    (0) 
  3. Niranjan Emparala

    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

     

    (0) 

Leave a Reply