leading and non leading ledger balances do not match in FAGLB03

[Former Member]

Hi,

Balance for period 5 as per FAGLB03 for leading ledger (0L) is say $104.

The same balance as per nonleading ledger is $176.

I checked in FAGLF03 and no difference exists there.

The issue is only with period 5, the other periods display the balance right.

There is some balance from period 6 that adds up in the credit line items balance and thats the reason for difference.

Please suggest.

Regards,

Soujanya.

[Former Member · Accepted solution]

It is possible to assign the company code to a different fiscal year variant on the non-leading ledger than the one on the leading ledger. Meaning, a posting in period 5 on the leading ledger may be in period 6 on the non-leading ledger. Could you please check if that is the case in your system? If yes, I guess that explains it.

Also, use transaction code GCAC to perform ledger comparison, to see the differences.

[Former Member · Accepted solution]

Hi Srikant,

Thanks for replying. You are right. Fiscal year variant(Z1-year dependent; April to March) of 0L was different to that of non leading ledger X1 until the start of 2011 calender year(K4 - system defined and year independent).

Around February this year it was changed and aligned in accordance to Z1. activate non leading ledger still shows K4 as the assigned FYV. However, periods 2,3 and 4 show right results. The issue is with period 5.

Where a part of period 6 values have got added up to period 5 values in FAGLB03. My doubt is, when it has been working right for 3 periods, what is it with 5th period, that the postings are getting mixed up.

This is an inventory FG account that I have been referring to. Would there be a possibility of FI period having closed first and then MM period or vice-versa and during such time the 6th period postings could have got added upto the 5th period.

If I need to weed out this possibility, is there a way that I could check.

I'm yet trying to check GCAC.

Regards,

Soujanya.

[Former Member · Accepted solution]

Hi all,

Any ideas please??

In other words from my previous posts:

1. Earlier this year (around February) the non leading ledger's (Fiscal Year Variant - K4) was changed in accordance to leading ledger's FYV - YY which is April to March (year dependent).

2. So, the periods in FAGLB03 are divided based on calender months for non leading ledger (X1).

3. As the periods in leading ledger(0L) are year dependent the open and close dates are different than the calender months.

4. That's how calender month(or old K4's fiscal period of X1) August, has 2 0L's fiscal periods i.e. 5 and 6 (5th period closing date was 27.08.2011) and the 6th period start date is 28.08.2011

5. For X1 - non leading ledger when I drill down on the balance of 8th calender month i.e. August , it shows some balance from period 6, where it should not. It should only give us the results of period 5.

6. The results were right for periods 2, 3 and 4 in accordance to 0L's year dependent results. Wondering what went wrong in period 5.

As this is a month end closing issue, would appreciate any clues fast.

Regards,

Soujanya.

[Former Member]

Hi,

Non leading ledger's closing date was mainitained wrong. There were certain changes made about sometime back pertaining to FYV, which was not documented.

Both leading and non leading ledger should have had the closing date as on 27.08.2011, however it was maintained as 28.08.2011 in non leading ledger and hence the issue arose only with non leading ledger.

Regards,

Soujanya.