Skip to Content
author's profile photo Former Member
Former Member

Carry forward of balances


Hi all,

We Have a balance in one of intial upload account for past 3 years, Balance did not got carried forward for the latest year, But previous years it was getting carried forward properly,

We are re done the FAGLGVTR. But still it is not happening. Seen in FS00 it is balance sheet item and no such changes we made from PL to Balance sheet.

Note only one account of intial upload is not getting carried forward, Other intial upload account the balances got carried forward.

PLease suggest.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 07, 2014 at 03:30 PM

    hi daya,

    there is detailed explanation for that situatiın at below snote

    1930937 - FI-GL: Problems with the balance carryforward in FAGLGVTR

    the content of snote is :

    Symptom

    When you use transaction FAGLGVTR to execute a balance carryforward in General Ledger Accounting (new), an account balance does not appear to be carried forward correctly to the new fiscal year.

    This SAP Note describes the relevant procedure if such a scenario arises.

    Other Terms

    SAPFGVTR

    Reason and Prerequisites

    Problems with a balance carryforward are rarely caused by a program error.
    Most problems are caused by:

    • Misunderstandings in relation to how the balance carryforward program works
    • Inconsistent totals tables
    • Incorrect Customizing
    • Authorization problems (Example: If some user authorizations are missing, the system may not fully display some account balances when you try to display them. When you compare these account balances with the result list in transaction FAGLGVTR, differences seem to arise.)

    To ensure a faster error analysis, carry out the following steps.

    Solution

    1) General: How the balance carryforward program works
    When you execute a balance carryforward in General Ledger Accounting (new), an account balance is carried forward to the new fiscal year. The following rules apply to the balance carryforward:

    Program run:
    The program can be repeated as often as required.
    If the balance carryforward has already run for the current fiscal year, postings in the previous fiscal year are automatically carried forward to the current fiscal year.

    Balance sheet accounts:

    • Balance sheet accounts are carried forward onto themselves.
    • Balance sheet accounts are transferred with all additional account assignments.

    Profit accounts (P&L accounts):

    • Profit accounts are carried forward to the retained earnings account (see transaction OB53).
    • In the standard system, profit accounts are carried forward to the retained earnings account without additional account assignments unless you have made the following settings:
    • You have activated document splitting. The document splitting characteristics of the profit accounts are carried forward automatically.
    • Additional characteristics are carried forward if you have maintained them manually in transaction GLCF ("Enter Detail Specifications for P & L Accounts").

    2) Analysis:

    If you notice that the balances of a ledger have been carried forward incorrectly, answer the following questions before you contact SAP Support:

    • Was the program executed in the update run?
    • Did problems (error messages) occur during the program run (FAGLGVTR)?
    • Are there inconsistencies in the affected totals table?
    • How was the error detected? (Which program was used for this purpose?)
      Did the user have the necessary authorizations?
      Is the affected account a balance sheet account or profit account?
    • Have the current corrections already been implemented?

    The following description explains the questions in detail:

    Was the program executed in the update run?

    The process control of transaction FAGLGVTR contains the "Test run" indicator. The data is only carried forward correctly to the new fiscal year if this has been deactivated.

    Did problems occur during the program run (FAGLGVTR)?

    If problems occur during the balance carryforward, these are logged. You can display these messages at the end of the program run by choosing "Messages".

    Are there inconsistencies in the affected totals table?

    Inconsistencies in relation to object numbers can cause incorrect updates. Start the report FAGL_OBJCHECK. If the result list displays only green traffic lights, the totals table does not contain any inconsistencies in relation to object numbers.

    How was the error detected? (Which program was used for this purpose?) Is the affected account a balance sheet account or profit account?

    Often, the result list in the balance carryforward program is compared against other programs (for example, the G/L account balance display (FAGLB03), ledger comparison programs or custom reports).

    However, such comparison programs may produce incomplete results if some necessary authorizations, Customizing settings, and/or filter conditions are missing.

    For this reason, you must first examine whether the balance carryforward program works correctly. In other words, are the balances in the ledger carried forward correctly to the new fiscal year? For the individual accounts, this means:

    Checking the balance sheet accounts:

    Do the balances of all periods from the prior year correspond to the balance in period 0 of the subsequent year?

    To check this point, implement the attached auxiliary program ZZ_CHECK_BAL_CARRYFORWARD_GL. This program reads the balance for a balance sheet account cumulated across all periods from the prior year and reads the balance in period 0 of the new fiscal year.

    The list output of the program ZZ_CHECK_BAL_CARRYFORWARD_GL for a balance sheet account looks, for example, as follows:

    Ld CoCd Year Account Crcy Amnt in GC LC B/S Exit RetEarnAct X1 1000 2013 110000 EUR 4,600.00 5,710.44 X X X1 1000 2014 110000 EUR 4,600.00 5,710.44 X X

    Description of each line:
    Line 1: Balance across all periods in the fiscal year 2013
    Line 2: Balance across the period 0 in the fiscal year 2014


    Description of each column:
    Ld = Ledger X1
    CoCd = Company code 1000
    Crcy = Currency key for the transaction currency
    LC = Value in the local currency (currency of the company code)
    GC = Value in the third currency (additional local currency)
    B/S: XBILK = Is the account a balance sheet account (X = Yes)?
    Exit: XBILK: What is the value after the exit CALL_EXIT_SAPLGVTR_001 has run? (If the balance sheet account is the same as the exit, no change has been made).
    RetEarnAct: Is the account a retained earnings account (X = retained earnings account).
    EK: P&L statement account type (not listed here)


    In this example, the balances of both years correspond and, as a result, the balance carryforward program runs correctly.
    At the end of the list output (summary), the system, once again, explicitly lists all balance sheet accounts that contain differences in the balance carryforward. If no accounts are listed there, the balance carryforwards in the balance sheet accounts are correct.

    Checking the retained earnings accounts:

    For calculations in relation to the retained earnings accounts, you must specify the complete account interval as a parameter in the report ZZ_CHECK_BAL_CARRYFORWARD_GL.


    Notes
    When you perform an SAP Notes search, use the search term "SAPFGVTR" to search for current SAP Notes that could be related to your problem.


    3) SAP Support Ticket
    If you still think that the balance carryforward program is updating the balances incorrectly, you should submit a message to SAP Support.
    To ensure that SAP Support can process your message as efficiently as possible, your message should satisfy the following prerequisites:

    • It should contain answers to the above questions.
    • You should have implemented the report ZZ_CHECK_BAL_CARRYFORWARD_GL.

    please follow the snote for your problem

    best regards,

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ehran,

      Thanks for this..We have implemented the program as said above, and for that GL we are geeting a difference, But wanted to know why this GL balance is not getting carried forward....This program only tell what is the difference and waht balacne has not got transfered,....But i wanted to know, If balance is not carried forward what is solution for this.

      Pls help

  • Posted on Jan 07, 2014 at 04:39 PM

    Hi Ram,

    Please check mentioned SAP notes

    1714547 - Balance carryforward is not correct

    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.