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
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
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‟.
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
6. Continue month-end processing.
Page 2 of 2