VIEWS: 3 PAGES: 2 POSTED ON: 10/5/2011
C:\Docstoc\Working\pdf\5cb2c2b6-75a1-449c-b8da-92cb60945cf2.doc RESETTING OF AN ASSET WHY WOULD YOU RESET AN ASSET? The user is running AMDPCLOSE and receives an error. Next we have the user run AMDPCLOSE for ranges of assets versus all assets. This will identify the PROBLEM ASSET. The process monitor will have the following error “…unique contraint”. We have found this to occur when the user has made adjustments to an asset and used a budget period not equal to the original budget period at the time of the add. We have been told by PeopleSoft never to change the budget period. For the rest of the assets life they will have the same budget year. There may be times when the user cannot see the BUDGET PERIOD they need. They should call system to have the budget period activated. THE FOLLOWING PORTION EXPLAINS HOW TO RECOVER FROM THE ERROR. It involves SQL updates by DoIT both before the user can continue and in the middle of the user fixing the problem. NOTE: Before DoIT makes the updates be sure you know: * All the adjustment rows will be deleted this means you need to know ALL adjustments you have made to the asset before they are deleted. * DoIT will run a series of SQL updates. * Once this is complete you will consolidate your OLD adjustments into one new adjustment row. Do not include the adjustment from the current month at this point. * User will Run AMDPCALC for this open trans. This will update the depreciation amount. Note it will know not over-depreciate because the transaction date has not changed. Depreciation is figured out by taking the TRANSACTION date plus the life. * STOP ALL PROCESSING – and communicate to DoIT you are ready for the next SQL update. * DoIT will make the following updates to ensure that GL accounting entries for your OLD adjustments [adjustments made before the problem] do not get recreated, causing you to double count them. * Update the OPEN_TRANS – calc_dist_status to C for the applicable asset. This will prevent another set of accounting entries being created. * User will now add your current month adjustment. * User will continue on with you normal processing order. Page 1 of 2 C:\Docstoc\Working\pdf\5cb2c2b6-75a1-449c-b8da-92cb60945cf2.doc SQL UPDATES 1. In PS_Open_Trans , reset the Calc_Depr_Status to 'P' for asset_id being re-depreciated where trans_type = 'ADD'. Delete all other rows for the other trans types (TRF, RET, etc.) 2. Delete rows from PS_Depreciation except for trans_type = 'ADD' where the asset_id = 'xxxxxxxx' ( An ADD is ONLY used when Accum Depr is populated when doing an orignal EXPRESS ADD ). 3. Reset PS_Book Fields Update PS_Book set Begin _ Depr_DT = ' ', ( no space between quotes) Begin_Depr_Pd = 0, Begin_Depr_FY = 0, Begin_Calc_DT = ' ', Begin_Calc_PD = 0, Begin_Calc_FY = 0, Begin_Fraction = 0, RSV_Fraction = 0, Sched_Fraction = 0, Life_remaining = 0 where asset_id = '999999' . 4. Note: If asset has been retired or reinstated, you will need to remove these rows from PS_RETIREMENT. 5. Delete rows from PS_COST except for trans_type = „ADD‟, where the asset_id = „xxxxxxxx‟. 6. Delete rows from PS_ASSET_ACQ_DET where the SEQUENCE_NBR_6 NOT EQUAL TO 0, where the asset_id = „xxxxxxxx‟. 7. Rerun amdpcalc for open trans id . Actions to be done - Combination of USER and DoIT: 1. User - Re-enter all previous adjustments into one consolidated row. DO NOT enter the current month adjustment 2. User – Run AMDPCALC [Depreciation calculation] 3. DoIT Call DoIT to change the field CALC_DIST_STATUS on the PS_OPEN_TRANS record from P to C. 4. DoIT will inform you update was made 5. Now enter your current period adjustment. Be sure to use the same BUDPER as the original asset. 6. Continue month-end processing. Page 2 of 2
"reset C DocstocWorkingpdf5cb2c2b6 75a1 449c b8da 92cb60945cf2"