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.
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:-
- 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.
- 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.
- 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
Thank you for sharing this Mani.
Rgds
MBN
Hi Mani,
Useful thanks to share.
Thanks
Lakshmi
Nice helpful document
Thanks for sharing..
Moorthy Esakky
Nice document Mani garu....
This helps as a reference document for all the consultants to provide the appropriate solution.
Keep it up.
Thanks,
NSK
Thank you Mani Kumar....for sharing very good document....
Thanks to all
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
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
Hi Atul,
Thanks for your reply.
Regards,
Lakshmi S
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,
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
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
Hi Mani,
Yes, you are correct. Thanks alot for your clarification.
Regards,
Lakshmi S
Thanks for sharing.
Very useful
Thanks
Muhammed Riyas C
Hello,
Thanks for sharing, it's really useful.
What about the deactivation of OIM?
Are there any rules to follow?
Many Thanks ,
Regards
Siwar
Hi Mani,
Nice document.... I really appreciate your efforts for helping others by sharing superb documents.
Regards,
Rohit raj.
Hi,
Nice document. Thanks for sharing your knowledge.
Regards
Karthi
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
Hi Sir,
You are a GEM as always.!
Hi Expert
I am facing following issue in the process of Switch to Open Management.
Please suggest resolution for the same as have searched in the portals for the same.
Regards
Archana
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
Thank You,
This is a very useful explanation. I did what you explained, but I had the error bellow.
Regards
Isac Taquedir
GOOD BLOG...THANKS!!
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.
Great post!
Just mention, that in S4HANA environment, new program is available for this purpose ZFINS_SWITCH_TO_OPEN_ITEM.
SAP NOTE: 2302566
Salvador