Skip to Content

FAGL_ACTIVATE_OP Active open items for GL

Dear Experts

By using FAGL_ACTIVE_OP we are facing problem regarding line items.

in GL LC margin there are four line items, during execution line items info is remove and system is generating only one OPEN items.

How can we will get line items wise OPEN items not in TOTAL?

(That means four OPEN items line)

if not

Only GL is active for open items from specific period, this also serve our purpose.


Urgent. Pls. help to solve this.


Input screen of FAGL_ACTIVATE_OP

Before execution of FAGL_ACTIVATE_OP (GL balance with line items)

After execution of FAGL_ACTIVATE_OP (GL balance with line items)

GL info

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 07, 2014 at 08:23 AM

    Hi

    I think the SWITCH ON date is important here.. You have to ensure that this date is earlier than the date of the 1st line item.. All the line items after this date are created as Open Items

    In your case, your doc date is 31.07 and OI Date is 1st Aug.. Thats where the problem lies, in my opinion

    Change your date to say, 01.01.2013 and that should work

    br, Ajay M

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2014 at 08:15 AM

    Hi Hossain,

    please follow the snote

    1770786 - FAQ - Open Item Management - FAGL_ACTIVATE_OP

    content is;

    Symptom

    This note answers the most frequently asked questions for FAGL_ACTIVATE_OP / FAGL_SWITCH_TO_OPEN_ITEM / switch to open item management activation / ledger specific clearing activation.

    Other Terms

    1356457 , FAQ , FAGL_ACTIVATE_OP , Open Item Management , OIM , FAGL_SWITCH_TO_OPEN_ITEM , RFSEPA02 , Ledger specific clearing, XOPVW, XLGCLR , subsequent activation.

    Reason and Prerequisites


    The terms used in the note are as below.

    T-code : Transaction code.
    OIM : Open item management.
    FAGL_ACTIVATE_OP : Transaction code used for open item management or ledger specific clearing activation.
    FAGL_SWITCH_TO_OPEN_ITEM : Report behind the T-code FAGL_ACTIVATE_OP.

    FAGL_ACTIVATE_OP is the T-code used to convert G/L account to open item management which are already managed on line item basis or to convert G/L account to ledger specific clearing account. The report behind this T-code is FAGL_SWITCH_TO_OPEN_ITEM.
    There are two options provided in the selection screen for FAGL_ACTIVATE_OP.

    1. Ordinary open item management.
    2. Open item management for clearing specific to ledger groups.

    Please go through the report documentation which can be accessed as mentioned below.
    1. Go to the T-code SE38
    2. Enter the program name : FAGL_SWITCH_TO_OPEN_ITEM .
    3. Choose the radio button "Documentation" to understand the usage of this T-code.

    List of questions answered in this note:

    Q01. From which release of SAP is this program or T-code available?

    Q02. What is the function of the T-code FAGL_ACTIVATE_OP and what is the impact if you do not use this T-code for converting the account to OIM?

    Q03. Why is it necessary to run the "update mode" in background?

    Q04. Some of the common scenarios under which the T-code fails to activate open item management and throws up a valid error message.

    Q05. How do you read the execution log of FAGL_ACTIVATE_OP?

    Q06. What are the mandatory fields in the selection screen while trying to execute the T-code?

    Q07. What is an activation date?

    Q08. What does "Transfer posting" mean and how does it happen?

    Q09. What does "Perform Reposting" mean?

    Q10. What will be the impact if reposting is not done?

    Q11. Will the T-code work if there are ledger specific postings present in the account prior to activation?

    Q12. Is it possible to reset the documents which have been cleared by FAGL_ACTIVATE_OP?

    Q13. What are the necessary steps to be taken if the balances do not match in all the ledgers?

    Q14. How to resolve the error message "Balance of ledger &1 differs from the account balance"?

    Q15. What is the impact if the customer has treasury postings on the account prior to activation?

    Q16. What are the steps to be taken in case the extraction of data to BW fails after usage of FAGL_ACTIVATE_OP?

    Q17. What is the impact if the account has material posting (technically at line item level BSEG-KOART = 'M')?

    Q18. What are the tables which get updated during the activation of normal "Open item management"?

    Q19. What are the tables which get updated during the activation of "Clearing specific to ledger group"?

    Q20. What is the pre-requisite for activation of "Clearing specific to ledger groups"?

    Q21. What is the general consistency check report which could be run for checking consistency per company code per fiscal year per period?

    Solution

    Kindly refer to the attached notes to solve the already known issues.

    Q01. From which release of SAP is this program or T-code available?

    FAGL_ACTIVATE_OP is available only as of ECC 6 EHP 3 onwards and it is not possible to down port it to lower releases. For lower releases you could use "Remote consulting" service of SAP (Please refer to the note 83020 to know about remote consulting) for OIM activation of G/L accounts.

    Q02. What is the function of the T-code FAGL_ACTIVATE_OP and what is the impact if you do not use this T-code for converting the account to OIM?

    FAGL_ACTIVATE_OP is the T-code used to convert G/L account to open item managed account ( As a prerequisite the account has to be line item managed to use this functionality ).

    You can choose between ordinary open item management and open item management for clearing specific to ledger groups as per your business requirements.

    Explained below is the functionality of the T-code with respect to "Open item management" activation with the help of a simple example.

    Assumption: Only one ledger is involved i.e ledger 0L.

    Let us say that account balance is equal to 1000 EUR and 1000 EUR is distributed across the profit centre and segment as mentioned below for ledger 0L.

    Ledger 0L:

    Profit center P1 and Segment S1 : 400 EUR

    Profit center P2 and Segment S2 : 600 EUR

    The system performs the following steps to convert the account to "Open item management".

    1. Some of the elementary level validations are performed before the actual process of activation starts.

    2. 1000 EUR is written off from the original account to the account mentioned in the selection field under "Account for Transfer Posting" by posting a FI document.

    This is called "Transfer posting" document because the amount is transferred from the original account to the account mentioned.

    This document will also be behaving as the clearing document which will clear the documents which have been posted prior to the activation date.

    After this transfer posting is done, the second type of transfer postings are done on the original G/L account to make the balance zero per account assignment.

    3. A document is posted in ledger 0L with 400 EUR credit for profit center P1 and segment S1 and 400 EUR debit for profit center blank and segment blank.

    4. A document is posted in ledger 0L with 600 EUR credit for profit center P2 and segment S2 and 600 EUR debit for profit center blank and segment blank.

    The above postings are ledger specific postings to ledger group 0L.

    Now, the balance on the account is zero per account assignment.

    5. Account is blocked for posting in order to make sure that no postings happen while the activation process is on.

    6. Open item management is activated.

    7. As mentioned in point 2, the "Transfer posting" document will hard clear all the documents with posting date prior to activation date.

    If the checkbox "Perform Reposting" is on, then a new single line is reposted back to the original account hence, maintaining the account balance as 1000 EUR as it was before the activation.

    6. The 1000 EUR is reposted (as an open item) to the original account with the account assignment entered in the selection screen under "Account assignments".

    Now, there will be only one single open item for the account. If you do not perform reposting, then this open item will not be created.

    7. Closing checks are performed.

    After this the account will be an open item managed account and the documents posted with posting date greater than the switch date will be eligible for clearing .

    The repercussions of not using this T-code for converting the account to OIM are as mentioned below.

    If you have a company code for which document splitting is active then the relevant tables of splitting ( FAGL_SPLINFO and FAGL_SPLINFO_VAL ) will not be having information for the historic documents. Hence, clearing will not be possible for these documents.

    By using this T-code, the prior document gets hard cleared so you do not have to worry for them at all.

    Hence it is advisable to always use this T code for ECC 6 EHP3 pack level and above for converting the account to OIM. Usage of any other means for converting the account to OIM will be dealt under Remote consulting service of SAP.

    Q03. Why is it necessary to run the "update mode" in background?

    It is mandatory to run the program in the background for update mode because the actual database updates happen here and this could be time consuming resulting in 'time out' termination. However, the test run can be done in the foreground because it is way less time consuming. It is always advisable to do the test run before the actual update.

    For further details please refer to the note 1581977.

    Q04. Some of the common scenarios under which the T-code fails to activate open item management and throws up a valid error message.

    1. Error message FAGL_SWITCH_OP 018:

    One of the pre requisite for converting an account to "Open item managed" is to have same balance in all ledgers. Balances can differ in the ledgers for three circumstances.

    1. If ledger-specific postings are already present on this account.

    2. If a ledger has been subsequently implemented in the system.

    3. If the account has an inconsistency.

    2. Error message FAGL_SWITCH_OP 002 / 044.

    This error message can arise due to archiving which has taken place for prior year documents, and the balances from the totals no longer match the total of the line items.

    3. Open item management has already been activated for an account and there are line items as well as open items on that account prior to the activation. In such cases, it is considered as master data change of the account which will be dealt under Remote Consulting.

    4. Also, if you have more than one ledger in a company code and the fiscal year variant is different for different ledgers, then the program stops.

    Please refer to the note 1356457 under the heading "Different fiscal year variants" for more details.

    Q05. How do you read the execution log of FAGL_ACTIVATE_OP?

    Please go to the T-code SLG1 and enter:

    Object: FAGL

    Sub object: OPENITEM

    Then press F8 to have a look at the required log.

    Q06. What are the mandatory fields in the selection screen while trying to execute the T-code?

    G/L account, Company code and the Switch date are the mandatory fields.

    Apart from that, you can see that under "Account assignments" block, there are few fields which are mandatory based on the customizing for Document Splitting in New GL (in table FAGL_SPLIT_FIELD).

    If your company codes do not having document splitting active, then none of the account assignments will be mandatory. A known program error related to this has been solved by the note 1776819.

    Q07. What is an activation date?

    The activation date is either the current date (if you choose any of the dates in the current period) or the last date of the posting period ( if you choose any of the past period or fiscal years ).

    If you want to see all existing items as open items, the activation date must be earlier than the earliest posting date of all items.

    Please refer to the note 1356457 under the heading "the activation date" for more details about the activation date.

    For the New GL migrated system, the activation date must be equal to or greater than the migration date. It is not allowed to have a prior date than the migration date.

    Q08. What does "Transfer posting" mean and how does it happen?

    In cases where the account has a balance not equal to zero then in order to make the account balance zero, the current account balance is transferred to a dummy account via a posting referred to as "Transfer posting"

    Thereafter, ledger specific transfer postings are done so that the balances in all the ledgers are same per account assignment per currency.

    Please have a look at answer for Q02 for details about the transfer postings.

    Q09. What does "Perform Reposting" mean?

    By "Perform Reposting" checkbox being selected, the amount which was transferred from the original account using "Transfer postings" will be posted back to the original account hence, bringing the account balance back to the original amount. Therefore, a single open item will be created with the account assignments entered in the selection screen. This means that the original account assignments of the old open items are not considered for reposting.

    If you want to keep the original account assignments, you can use the activation date for the OIM with a date BEFORE the first posting to the account.

    With this all items would be set to OPEN ITEM managed, and so the account assignments should 'stay' in the system, as the transfer posting would not be required.

    But, please keep in mind that the activation date must be GREATER than the migration date if you have done migration in your system.

    Q10. What will be the impact if reposting is not done?

    If the reposting is not done ( as this is optional ), in that case the single open item which is the summation of historic line items will not be created.

    Q11. Will the T-code work if there are ledger specific postings present in the account prior to activation?

    No. In case you have ledger specific posting(s) in the system then please ensure that the notes 1722813, 1772143 and 1776642 are implemented in the system.

    It is better to use a new account in case you have ledger specific postings.

    Please create OSS message under component FI-GL-GL-X if you want to use the same account in spite of having ledger specific postings. We shall analyze the situation and provide optimum solution.

    Q12. Is it possible to reset the documents which have been cleared by FAGL_ACTIVATE_OP?

    You should NEVER TRY TO RESET the cleared item because it leads to further inconsistencies in the system and SAP will NOT be responsible for the same.

    The functionality of the program is such that the historical documents of the accounts gets hard cleared by a 'Transfer posting' document and you just have one single line item which is now open. This open item is the aggregate of all the historical lines items of the account.

    The hard clearing is performed technically by the program.

    If document splitting is active, the split information might be missing in the database for historical data and hence any hard cleared line items if reset can never be cleared again.

    So, kindly choose the activation date based on your requirements.

    Also have a look at the note 1779607 which tells very clearly that SAP does not perform any maintenance if data inconsistencies arise as a result of resetting of the hard cleared lines. Hence, this will be treated as Remote Consulting.

    Q13. What are the necessary steps to be taken if the balances do not match in all the ledgers?

    If the balances do not match in all ledgers, then you need to check if there are any ledger specific postings existing in the system.

    If such is the case, then you need to open an OSS message under component FI-GL-GL-X.

    Q14. How to resolve the error message "Balance of ledger &1 differs from the account balance"?

    Please check if note 1404013 is already implemented in the system. If the error still exists, then kindly raise an OSS message in the component FI-GL-GL-X.

    Q15. What is the impact if the customer has treasury postings on the account prior to activation?

    Please refer to the note 1466099, the implementation of which will enable the tool to throw an error message for treasury related postings. However having treasury related postings, the account will not be considered for OIM activation.

    Q16. What are the steps to be taken in case the extraction of data to BW fails after the usage of FAGL_ACTIVATE_OP?

    Please check if you have already implemented the note 1454826. If the error still exists, then raise a message in the component FI-GL-GL-X.

    Q17. What is the impact if the account has material posting(s) (technically at line item level BSEG-KOART = 'M')?

    Accounts having material posting before activation date cannot be converted to open item managed accounts. You will get the error message FAGL_SWITCH_OP 093 while trying to switch to open item management. A known bug related to this issue has been resolved by the note 1497351.

    Q18. What are the tables which get updated for a normal "Open item management"?

    Tables BSIS (open items) and BSAS (cleared items) are updated.

    Q19. What are the tables which get updated for a "Clearing specific to ledger group"?

    Tables FAGLBSIS (open items) and FAGLBSAS (cleared items) are updated.

    Q20. What is the pre-requisite for activation of "Clearing specific to ledger groups"?

    The account which is being activated for clearing specific to ledger group must have the flag "Only balance in local currency" checked (technically at table level SKB1-XSALH = 'X'). Else the error message "FAGL_POSTING005; A/c with clearing specific to ldgr grp only permitted in local crcy" will occur during activation.

    In case you already have documents posted to this account with the flag "Only balance in local currency" not checked, and then you need to take up a small conversion project for converting all the prior posted documents from current currency value to the local currency value. Else, the error message "Activation not possible; balances in foreign crcy exist for account" will occur during activation.

    Q21. What is the general consistency check report which could be run for checking consistency per company code per fiscal year per period?

    Report TFC_COMPARE_VZ is the basic consistency check report for New GL system to check the consistency of the company codes per fiscal year per period.

    SAPF190 is the consistency check report for classic GL system.

    Best regards,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.