cancel
Showing results for 
Search instead for 
Did you mean: 

difference in asset report & g.l account balance

Former Member
0 Kudos


Hi All,

we have 3 assets in assets report (AW01 & S_ALR_87011994) whose balance is not matching from gl account used for asset posting in AO90.

Could you please suggest how there can be difference in asset report & gl account balance.

Regards

Deepak

Accepted Solutions (0)

Answers (4)

Answers (4)

João_FI_FIN-CS
Active Contributor
0 Kudos

Hi Deepak,

Run the ARMO tcode to know if there's a difference in procceses executed.

JPA

Former Member
0 Kudos

Hi Deeppak;

     I have same issue and while searching on forums and another related sites I found something is mentioned related to such issue suggests you may need to correct values on Acc. Dep. G/L balances if the G/L is less than the AA balances through direct post on the Acc. Dep. reconciliation balances through OAMK and change the status for the account to be NOT RECONCILIATION ten post then return it.

Another reason could be is related to rounding if the differences are pretty small so you may need to check OAYO.

If that was helpful or giving you a glim for answer please do not forge helpful answer marks.

Best regards;

Ahmad Mahmud;

Former Member
0 Kudos

Hi Deepak,

The T code S_ALR_87011994 will always show plan values up to the end of the year. But GL account balances will show posted amount only and not the planned amount.

So If you want to compare reports and GL balances use T code S_ALR_87011990 and tick depreciation posted check box in further settings and then compare with GL balances.

Hope it solves.

Regards,

G.Sethuraman

Former Member
0 Kudos

hi,

Please look that you haven't post any transaction directly in GL code with using asset number.

Please run ABST 1 and which will tell the difference as well.

ManyThanks

Former Member
0 Kudos

Hi Preeti,

thanks for input. I am runnign t code AW01 where we have acquiation value, accumulates start depreciation & monthly depreciation.

Since our asset report does not match to g.l account, I can not use any table to extract this data.

Could you pleaes advise any asset report where we have acqusion value, accumulate start depreciation & monthy depreciation.

Please suggest

Regards

Deepak

Former Member
0 Kudos

Hi Deepak ,

Can you Please try Asset histroy report S_ALR_87011990 - Asset History Sheet

Former Member
0 Kudos

Hi Preeti,

Please refer screeshot of AW01. Here 4000 is acquistion value & 249.99 is starting accumulated depreciation when this asset get start depreciated in SAP.

Now we need asset report with these both values & monthly depreciation.

Please advise

former_member351125
Contributor
0 Kudos

Actually you need to analyze this scenario deeply as there are so many reasons why the assets are not matching with the GL account.

1. Legacy assets

     if this is a legacy asset make sure that the GL account balance is equal to the asset balances as of the transfer year

     to do this you can compare AHS (AR02) and GL balance (FAGLB03) as of the year of transfer

     if there is a discrepancies between the GL and asset, then there is a problem during migration

2. Manual Adjustment

     Make sure that there is no manual adjustment posted on the GL accounts as manual adjustments or postings will only reflect to GL and not in asset

     to check this go to GL line item report and analyze all transactions and make sure that there is no adjustment posted on asset GL accounts.

3. Human Error

     It is possible that you are comparing values in asset history sheet to your gl accounts not correctly.

     to make sure check again the mapping of your asset classes to account determination and then to the GL accounts.

Thanks!
Jhero

former_member351125
Contributor
0 Kudos

Do you know how to use asset history sheet report? Transaction code AR02?