Asset Depreciation Key, Useful Life, Depreciation Expense, Depreciated Too Early

[Former Member]

Hi Folks,

I hope all is well. Your CSUS College Student back at it again with another question. I work for the State too and they messed up their Depreciation Key when creating Assets. Now, I have to figure out how to fix deprecation for Assets.

Originally Assets were created with Depreication key LINR. LINR, regardless of the month that the Asset is purchased in, depreciates the first year in full and then uses the straightline method to calculate deprecation moving forward.

We updated the configuation and changed the deprecation key to ZINA, ZINA uses the straightline method from the month that the Asset was purchased and depreciates it monthly using the straightline method. This is what we want.

So, 1 solution is to Retire all of the Assets that have the LINR deprecation key and do a complex posting to the new assets using the ZINA deprecation key. However, this process was ruled out. We don't want to retire the Assets to fix them.

Now, we have Assets that have Depreciated too much. And, we have Assets that have fully depreciated when in actuality they still have a useful life. So, my question is how do we debit the asset (GL 2349009700) and credit Depreciation Expense (9033245118).

For Example: Asset 9700000000, Capitalized on 6/15/2012 for $6,245.79 with a 3 year useful life is fully depreciated. The correct useful life is 10 years. So, this Asset is not supposed to fully depreciate until 6/1/2022. As of today it should have 74 more months before it fully depreciates and it should be depreciating at 52.04825 on a monthly basis (6,245.79 divided by 120 months). How do I post $3,851.57 (74 months * 52.05) back to the Asset so it can continue depreciating at the normal monthly rate?

Thanks in advance! Let me know if I need to provide any additional information.

[former_member351125 · Accepted solution]

Change the depreciation key to your new depreciation key.

Change the UL of the asset

Calculate the expected depreciation of the asset as of the current year (2016).

Post a write-up to the asset to adjust the over depreciated amounts.

[Former Member · Accepted solution]

This worked. Thanks!

The write up recognizes the Forecast which is exactly what we wanted. The forecast recalculates once the write up is posted. So, this is resolves the issue.

Thanks!

[ajaycwa1981]

Hi Kory / Mukhtar

I dont think there is an issue with Useful Life here. So changing the useful of the asset does not arise, in my opinion

It is only an issue because of Period Control that the asset was depreciated for the full year and not from the month of purchase. Am I right?

If yes, then you have excess booked your depreciation. The only and quick solution is to do ABZU (Asset Write Up). So, here are the steps

1. Calculate outside SAP the amount excess charged per asset

2. Do ABZU in current year with value date = 01.01.2016 (Start of the Fiscal year) and Value calculated in (1)

3. After that, the depreciation should calculate as per ZINA

Regards

Ajay M

[former_member198650]

Hi Kory,

If your new depreciation key is based on useful life method, then change the dep.key & its useful life for the asset. After done changes, if you run depreciation in repeat mode, then system will post adj.entry for all open fiscal years. If you have closed the last fiscal year, then you have to post write up by ABZU for excess depreciation and from current year on wards system will post depreciation correctly.

Regards,

Mukthar