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
- 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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.