Difference in Balance between in Asset Register & GL Balance

[Former Member]

Hi All Experts,

I am facing one issue where Asset Register balance is different than GL Account balance. These assets are related to AuC assets.

What could be the reason behind this ? Does anybody have check points ?

Experts guidance will be appreciable.

Regards,

Sharvari Joshi.

[suma_mani · Accepted solution]

Hi Joshi,

Run the ABST2 / ABST report where you can get reasons.

Make sure no JV's entered in AUC GL account.

Run AFAR for all AUC assets ,if required.

Regards

Mani Kumar

[Former Member · Accepted solution]

Hi Mani,

Thanks for quick reply.

I found some discrepancy I don't know whether this is right behaviour or wrong...

Here the total transaction posted for whole year is 50,644 EUR but NBV is showing for just 650 EUR.

Here in another screen shot ...

in this fiscal year change carried out but only 650 EUR got carry forwarded not complete 50,644 EUR's... Isn't it wrong behaviour ?

can expert guide on this ?

Regards,

Sharvari Joshi.

[suma_mani · Accepted solution]

Hi Joshi,

Run AFAR in test mode for that same assets,you will come to know ,if any discrepancies. Uncheck the test run and update the vlaues ,if any balances.

AFAR is transaction where you can update / simulate discrepancies.

.

Regards

Mani Kumar

[Former Member · Accepted solution]

Hi Mani,

My asset is AuC asset hence it doesn't have any depreciation key. And I guess AFAR is to recalculate the Depreciation. Still I tried I got the same error.

My observation regarding above screenshot is heading right or wrong way ?

Any other clues ?

Regards,

Sharu...

[suma_mani · Accepted solution]

Hi Sharu,

Please review said notes which should guide you resolve the same error.

Note 124509 - Analysis of errors listed by reconciliation program

Note 382548 - Composite note reconciliation Asset Accounting

AFAR is enough to update values for AUC also. Kindly send input and output screen shots ,in mean time for further analysis. Meanwhile go through the above notes also,which you can briefly.

Regards

Mani Kumar

[Former Member · Accepted solution]

Hey Hi Mani / All Experts,

I have solved it self. I got two programs in Market Place.

Which updates the AA database.

Issue in my case was :

System was able to update document to ANEP table but failed to perform a summation to ANLC table.

SAP has given two programs which removes the inconsistencies between ANLC & ANEP as well carry forwards the CORRECT balance to next open fiscal year.

RACORR11 & RACORR55 are these two programs.

In case of any body faces same kind of problem please use these two READY program.

Thank you Mani .

Regards,

Sharu.

[suma_mani · Accepted solution]

Hi Sharu,

Noted & thank you verry much.

Regards

Mani Kumar

[Stalin_Sachin]

Hi All, I had the same issue and I took sometime to fix it.

I then understood that, asset reports work based on asset value date and GL reports based on posting date.

It is worth checking if any settlement was done (example, cost object to AUC or FA) with posting date previous month but AstValue date (BSEG-BZDAT) in current month. 

To obtain all docs for these asset posting, I had checked first BSEG table with BUKRS, GJAHR and BZDAT (note, value and ast value dates are different). then passing all these to BKPF, I understood, only two docs type PS and AA. So I then run BKPF with posting date of these two months to know if any postings are falling under Asset value date of different month. Do not forget that BSEG has no plus /minus sign so consider D/C-S/H indicator while totaling or do subtotal on D/C. It resolved my issue.

Thanks.

Sachin.