If you are using asset management for the first time, you will need to cleanup the value prior to start depreciating the assets. Here are some notes on how this can be done.

1. Enter all assets in the system
2. Void the assets that you want deleted
3. Void the groups, classification and locations you want deleted.
4. make sure assets that are active are not allocated to any void items
5. Set the Original cost to the value you want to start using asset managet as at date

Note the script below will remove all void items and reset the values - USE CAREFULLY *******
-- Asset Cleanup Script
-- Remove all void asset records from the database
delete from LT_AM_JOURNALS where ACTIVITY_ID in (select ID from LT_AM_ACTIVITY where ASSET_ID in (select id from LT_AM_ASSET where VOID = 1))
delete from LT_AM_ACTIVITY where ASSET_ID in (select id from LT_AM_ASSET where VOID = 1)
delete from LT_AM_ASSET where VOID = 1
delete from LT_AM_CLASSIFICATION where VOID= 1
delete from LT_AM_GROUP where VOID= 1

-- Reset book value and updated cost to ORIGINAL COST
-- Only do this if you want to initiate the use of Asset Management
update LT_AM_ASSET set UPDATED_COST = ORIGINAL_COST, book_value = ORIGINAL_COST

---

Systems Engineer - Link Technologies