Difference in ABST2 (accum. depreciation in asset balance bigger than gl balance)

[Former Member]

Dear Experts,

Really need your help. We are facing problem which is in report ABST2 amount of accumulated depreciation in asset balance (1st LC AA column) bigger than accumulated depreciation in gl balance (1st LC Bal. GL column). We already checking in FBL3N there is no manual posting. Our questions are :

1. How to know which asset number that affected variance/difference in ABST2?

2. How to posting adjustment?, because we analyzed that if we posting adjustment through asset number tcode, difference must be still exist in ABST2.

Actually we are on audit interim , so this issue must be closed maks on Oct 31, 2014.

Thanks in advance

Best Regards,

Meita

[raymond_moynihan · Accepted solution]

Hello Meita,

ABST2 can only show the difference between GL and FI-AA on an accounting
level, you will see no asset numbers nor document numbers. It'll show
the difference in amount in total for the account.

So if you see difference in ABST2, you can run ABST (RAABST01) that
then shows the details of the differences detected via ABST2 (RAABST02).
In order for the report to pick up the details of these differences, you
will have to make sure that the G/L account is line item managed.
(FS03 -> 'Line item dispaly' must be set).

If the account is not line item managed, but you want it see the details
by running RAABST01 then you have the option to set the indicator for
this account by running report RFSEPA01. This report will built up the
information that was absent due to the indicator not having been on in
the G/Ll account master data.
Once this infomation is available in your G/L account you can run
RAABST01 which will then show you the differences lined out for all
assets affected and the corresponding G/L account. Basically there
should be a entry in your BSEG table with a document number for each
transaction that has been done on the asset IF and only IF the area is
set up to post to G/L obviously.

With this two reports plus the G/L report FS10N you should be able to
work out where the differences come from.

I would also refer you to the following blog.

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/10007

hope this helps

regards

Ray Moynihan

[Former Member · Accepted solution]

Hi Ray,

Thanks for your information, its very helpful.

I already find the cause is accumulated depreciation on data migration is not correct. So its affected different calculation in sub ledger asset and gl balance.

I already solve the problem.

Best Regards,

Meita

[João_FI_FIN-CS]

Hi Meita,

In fact what this program does, is take the total from ANLC table, compact them and put these totals in the EWUFIAASUM table and then compare with GL accounts to reconcilation.

JPA