Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
suma_mani
Active Contributor
65,989

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.

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.

FAGLL03 report view (Before activation of Open item management)

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.

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

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

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.

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

25 Comments
Muralinag14
Active Contributor
0 Kudos

Thank you for sharing this Mani.

Rgds

MBN

Former Member
0 Kudos

Hi Mani,

Useful thanks to share.

Thanks

Lakshmi

narasimhulu_konnipati
Active Contributor
0 Kudos

Nice document Mani garu....

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

Keep it up.

Thanks,

NSK

mariks
Participant
0 Kudos

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

suma_mani
Active Contributor
0 Kudos

Thanks to all

former_member183378
Active Contributor
0 Kudos

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

former_member192833
Active Participant
0 Kudos

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

Former Member
0 Kudos

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,

suma_mani
Active Contributor
0 Kudos

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

former_member183378
Active Contributor
0 Kudos

Hi Atul,

Thanks for your reply.

Regards,

Lakshmi S

former_member183378
Active Contributor
0 Kudos

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

former_member183378
Active Contributor
0 Kudos

Hi Mani,

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

Regards,

Lakshmi S

Former Member
0 Kudos

Thanks for sharing.

Very useful

Thanks

Muhammed Riyas C

siwar_taleb
Employee
Employee
0 Kudos

Hello,

Thanks for sharing, it's really useful.

What about the deactivation of OIM?

Are there any rules to follow?

Many Thanks ,

Regards

Siwar

former_member193801
Participant
0 Kudos

Hi Mani,

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

Regards,

Rohit raj.

Former Member
0 Kudos

Hi,

Nice document. Thanks for sharing your knowledge.

Regards

Karthi

0 Kudos
Nice helpful document

 

Thanks for sharing..

 

Moorthy Esakky

 
Former Member
0 Kudos
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 Kudos
Hi Sir,

You are a GEM as always.!

 
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
i_taquedir
Explorer
0 Kudos

Thank You,

 

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

 

Regards

 

Isac Taquedir

mirza_farooq2
Explorer
0 Kudos
GOOD BLOG...THANKS!!
0 Kudos

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

0 Kudos
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.
former_member257510
Participant
0 Kudos
Great post!

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

SAP NOTE: 2302566

Salvador
Labels in this area