- SAP Managed Tags
Symptom
You execute the task for calculation of retained earnings (annual net income, ANI). The task log contains the Error/Warning message:
- G00 103 ( "Retained earnings/annual net income differ in B/S and I/S for &1 (LC)" )
- G00 104 ( "Retained earnings/annual net income differ in B/S and I/S for &1 (GC)" )
For example, "Retained earnings/ANI differ in B/S by 20.313.895,46- and I/S by 20.349.990,92- for XX01 (GC) Message no. G00104"
Troubleshooting Approach
1. Check any missing notes under ANI component according to the version of customer system.
E.g.
3225409 - Show B/S and IS difference in message when error exist
3500669 - Group Currency Value Is Cleared during the Annual Net Income Calculation
2. Verify the selected financial statement (FS) items for both BS and PL with Tcode: CXE5 and table FINCS_FSIASSGMT
Default clearing FS item of BS is 317000, while PL is 799000; but some customer may change the default value in their solution. Therefore have to ensure what the exact FS Item is at first.
Tcode: CXE5
spot the Item Role, for example, Item role S-ANI-BS from tab [ANI, B/S], likewise, under S-ANI-PL from second tab [ANI, I/S].
To determinate the accurate net income FS items. Have to search via table FINCS_FSIASSGMT by inputting the items Role acquired at Step1. in some cases, the selected FS item could be changed as per Fiscal Year/Period.
Also has below situation, no role maintained at all, but set net income FS Item directly at CXE5.
3. Check Local Currency key for the concerned Cons Unit with table FINCS_BUNIT_ATD;
Check Group Currency Key with Tcode: CXB1 through checking the given version.
4. Check Data of both BS and PL:
a. Export all of the B/S FS items from table FINCS_FSITEM with item type [AST + LEQ]
b. Delete the aforementioned selected FS item(317000) of BS type from the exported FS items at step a.
c. Run Tcode FINCS_TOT_LIST, and set search filters based on below condition:
all FS items (except 317000) + version + period + COA + CT indicator = BLANK + PL to 10
then leave the result there for future comparison with PL items.
Period: From Blank to Current period(as per customer reported, in my case, it is period 12)
FS items: Paste all of the FS item from step 3.b(except 317000).
CT indicator: 0 (note 3003971) have to use Green equal sign =
Posting level = From blank to 10
d. Export all of the P&L FS items from table FINCS_FSITEM with item type [INC + EXP]
e. Delete the aforementioned selected FS item(799000) of PL type from the exported FS items at step d.
f. Run Tcode FINCS_TOT_LIST, and set search filters based on below condition:
all FS item (except 799000) + version + period + COA + CT indicator = BLANK + PL to 10
then leave the result there for future comparison with BS items.
5. Conduct the comparison between the BS and PL, and locate the difference spot, various situations may happen depend on the scenarios.
In most cases, if LC=GC for the given Cons. Unit, follow the steps of KBA 3146025 - Group Reporting: Different amount in LC and GC with the same currency in reported (released) data, the difference could be fixed with the solution explained in the KBA . On some special cases, may only need to post one side entry to be balanced.
Case 1: LC and GC hold same amount at BS and PL respectively, however, not balanced between 2 sides(BS and PL)
After comparison, in this example, the imbalance amount 0.01 of FS item 999999 was identified.
double click the record concerned, the detail would be presented as below format.
Case2: The other case that the LC amount in between are equal, but GC amount has difference, this is typical case applicable to the KBA 3146025
Case3: LC amount are equal at 2 sides, while the TC of the BS side is doubled due to the FS item
In this article, we hope to share one common approach with you to help provide more precise and sophisticated steps to conduct the investigation when facing the message as described above.
| User | Count |
|---|---|
| 17 | |
| 7 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
