What-If Report Is Showing Wrong Amount for NBV Basis Method with Backdated DPIS at the Last Period of 1st Year
(Doc ID 2616372.1)
Last updated on DECEMBER 02, 2019
Applies to:
Oracle Assets - Version 12.1 and laterInformation in this document applies to any platform.
Symptoms
What-If Depreciation Report is showing wrong depreciation amount for Depreciation Method using NBV basis(like JP-DB XXYR) with back-dated DPIS at the last period of 1st fiscal year.
Condition
- Depreciation Method using NBV basis(like JP-DB XXYR)
- Addition with back-dated DPIS and non depreciation reserve
- Go to the next period after addition
Steps to Reproduce
*Calendar is beginning of January
1. 2017-01 *** Addition
Cost : 240000
YTD depreciation : 0
Accumulated depreciation : 0
Date in Service : 01-DEC-2016
Depreciation method : JP-DB 3YR (.536)
Salvage value : 10% (=24000)
Depreciation limit amount : 95%
2. 2017-01 *** Run Depreciation and go to the next period
3. 2017-02 *** Check the asset
Cost : 240000
YTD depreciation : 20961
Accumulated depreciation : 20961
Date in Service : 01-DEC-2016
Depreciation method : JP-DB 3YR (.536)
Salvage value : 10% (=24000)
Depreciation limit amount : 95%
FA_DEPRN_SUMMARY***
PERIOD COUNTER DEPRN_AMOUNT DEPRN_RESERVE DEPRN_ADJUSTMENT_AMOUNT
------- ------- ------------ ------------- -----------------------
2016-12 24204 0 0
2017-01 24205 20961 20961 10720
4. 2017-02 *** Run What-If Depreciation Report
What-If Depreciation Report ***
Period Fiscal New
Name Year Depreciation Depreciation
-------- ------- ------------ ------------
2017-01 2017 20,961+ 20,961+
2017-02 2017 10,241+ 10,241+
2017-03 2017 10,241+ 10,241+
2017-04 2017 10,241+ 10,241+
2017-05 2017 10,241+ 10,241+
2017-06 2017 10,241+ 10,241+
2017-07 2017 10,241+ 10,241+
2017-08 2017 10,241+ 10,241+
2017-09 2017 10,241+ 10,241+
2017-10 2017 10,241+ 10,241+
2017-11 2017 10,241+ 10,241+
2017-12 2017 <477> <477> <--- ### Wrong ###
-------- ------- ------------ ------------
2018-01 2018 5,231+ 5,231+
2018-02 2018 5,231+ 5,231+
2018-03 2018 5,231+ 5,231+
2018-04 2018 5,231+ 5,231+
2018-05 2018 5,231+ 5,231+
2018-06 2018 5,231+ 5,231+
2018-07 2018 5,231+ 5,231+
2018-08 2018 5,231+ 5,231+
2018-09 2018 5,231+ 5,231+
2018-10 2018 5,231+ 5,231+
2018-11 2018 5,231+ 5,231+
2018-12 2018 5,227+ 5,227+
--> In 2017-12, the depreciation amount should be 10243, instead of -477
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |