Fixed Assets Remaining Life

(0) Share

Report

Posted on by Charles Abetz

935

We currently have a problem with a client where they have an asset that should appear on the Depreciation reports but the remaining life on the asset/book is negative (which makes no sense).

I was wondering how to resolve this, ie: do a have to perform a reconcile (they have a lot of assets so I want to know how this will effect the performance of their system) or just manually update the value via a SQL script?

Regards

Charles

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Vinutha Holla 705 on at

Like (0)

Report

Run this following script against the company database:

select * from FA00100

Take note of the ASSETINDEX of the asset in question. You can then use this following script to update the asset to flag it as full depreciated:

update FA00200 set fullydeprflag= 'Y', REMAININGLIFEYEARS= 0, REMAININGLIFEDAYS= 0 where ASSETINDEX=XXX

NOTE: Please run the above script first in the TEST company and if everything goes fine perform the same in the LIVE company.

Was this reply helpful? Yes No