Balance matching with AR03 & F.01 ?

[Former Member]

Hi,

All Experts,

I am trying to tally AR03 and F.01 for balances. My base is F.01 for further cross verification to other reports.

But it is not matching as previous years close is not next years opening.

Can anyone tell me what may be the reasons for not matching balances from these T.codes ?

And important one

Is it the best practice to match AR03 & F.01 ?

Regards,

Pankaj.

Edited by: pankaj_ab on Aug 13, 2009 12:02 PM

[Former Member · Accepted solution]

Hi,

Ideally AR03 (run for book depreciation) values and F.01 values should match. If it is not, you can execute the following two transaction codes -

1)F.16 to carry forward the GL balances.

2) ABST2 - this will show you if there are any differences in the Asset values and the values in the Asset reconciliation accounts

Hope this helps.

Thanks and Regards,

Anit

[Former Member · Accepted solution]

Hi,

Anit.

Can you please tell me what exactly ABST2 shows ?

I run ABST2 and there are some amounts I saw in for year 2009. So what exactly it means ?

Regards,

Pankaj.

[Former Member · Accepted solution]

Hi Pankaj,

ABST2 will show you if there is any difference between the reconcilaition accounts (GL) and the asset values in the AA module.

AR03 takes value from FI-AA module where as F.01 will take values from FI-GL. Sometimes there will be gap in posting. For examples, wrong upload of asset legacy value.

Thanks and Regards,

Anit

[Former Member · Accepted solution]

Hi Pankaj,

I am having limited access to transactions at my clients site so I am not able to give you the entire details. I suggest that you select the transaction ABST2 (Path - Easy access>>Fixed Assets >>Periodic Processing >>Year-End Closing >>Account Reconciliation) and press F1. The help explains the use and also gives the note no. which needs to referred in case of any differences.

Thanks and Regards,

Anit

[Former Member · Accepted solution]

Hi,

Anit.

Very excellent answer. I gone through note. The parameters I used for checking are :-

in AR03 Plant , then Report date , 31.03.2008 and for F.01 FSV version , Reporting year 2007 and comparision year 2007.

Beacuse I want to match it for 2007's closing and with 2008's opening.

Please corerct me If my selction criteria is wrong !

I am taking Plant for AR03 and for same in F.01 I am taking same number of Profit Center, I think this may be cause ?

Regards,

Pankaj.

Edited by: pankaj_ab on Aug 17, 2009 2:27 PM

[Former Member · Accepted solution]

Hi Pankaj,

The selection criteria (the date range) is correct. I would suggest you to first tally at the company code level and then go further break downs of plant/ profit center etc. This will help you to first determine that things are okay at global level then you can check on the account assignments.

Thanks and Regards,

Anit

Edited by: Anit Mangat on Aug 17, 2009 6:05 PM

[Former Member · Accepted solution]

Hi,

Anit.

Thnaks for concerning problem.

I gone through the SAP Note No. 104567 for Error message in ABST2. The error description in note given as follows :-

Mmy Error Message is MQ557.

Error in RAEWUC1B (MQ557).

a) Create an asset history sheet for the affected accounts.For

performance reasons, you are recommended to restrict by account

assignment or by asset classes.Enter 0020 as the sort version, the

year-end of the current year as the report date and activate

'Posted depreciation'.

History sheet for the current year does not agree if you

cross-check the values.In this case, RAABST01 should be started for

the account affected.For incorrect fixed assets a depreciation

recalculation should be executed.

History sheet for single values and total values does not fit.In

most cases the reason is a fixed asset without acquisition date.

b) The key date values do not match the value of the balance

display.There may be a variety of reasons for this.

The error occurs only on the business area level.In Financial

Accounting you must post a transfer between the business areas

directly to the account using ABF1/FB01 or reverse the original

document.

RAABST01 finds missing line items - these must be regenerated using

RACORR05.

The account was posted manually.You can see this using the line

item display of the account.These manual postings must be

reversed.It may be necessary for you to create a separate account

which is not posted to by FI-AA and post the difference amount to

this account.

I used ABST2 and I found all amounts only for 2009 year , whereas I am looking for 2007 closing and 2008 opening.

In which I found descripancies. So I gone through report RAABST01 and stucked.

Can any one please tell me which Reconciliation Account I must use here ?

Regards,

Pankaj.

Edited by: pankaj_ab on Aug 19, 2009 11:27 AM

[Former Member · Accepted solution]

Hi Pankaj,

This would mean that 2007 fiscal year has been closed and there were no descrepancies. In the RAABST01 report, you need to give the asset reconciliation accounts - Asset and accumulated depreciation account.

Thanks and Regards,

Anit

[Former Member · Accepted solution]

Hi,

Anit.

Good Morning !

I almost solved my FI-AA & FI-GL difference issue. We had asset legacy upload problem so that we are facing this kind

problem.

The best practice for matching balances is not AR03 to F.01 but S_ALR_87011963 to FS10N.

If we are taking 2008 fiscal year in FS10N then we must enter 31.03.2009 in S_ALR_87011963. Same for all fiscal years.

And this best practice is recommended by SAP itself. We got some root causes in ABST & ABST2 for that.

Post capitalization is the only solution on such issues, by opening previous periods.

Thanks for usefull insights and information on this.

All the best.

Regards,

Pankaj.

[Former Member · Accepted solution]

Hi Pankaj,

Thanks a lot for sharing the useful information.

All the best.

Thanks and Regards,

Anit