Company: Link Technologies Case No: L12380 Logged By: Sanjay (Link Technologies) on 07 Jul 2011 04:34PM Priority: Not Applicable Product: Other Group: To be assigned Time Taken: 0.00 Assigned To: Sanjay (Link Technologies) Circulation: Sanjay Resolve By: Thursday, 07 July 2011 04:34 PM [4672 days since logged date] Status: Closed

Subject: Cleanup and Reset Asset Records Summary:     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 Audit Notes:

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12380 in the subject line of all emails regarding this issue. Document size: 1.3 KB For call complaints, please contact the Managing Director of the company using this form.