You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Calculating NBV for partially retired Asset

Accepted answer
25
Views
1
Comments
edited Jan 26, 2024 7:00PM in Assets 1 comment

Summary:

 Calculating NBV for partially retired Asset


Content (please ensure you mask any confidential information):


How to consult the current Net Book Value in the asset tables, when this asset was partially retired? For example, I generated this Partially Depreciated status today, but the January depreciation has not yet occurred.

Is it possible to check this value in a table, even without running the January depreciation?

Currently, for the reports, we were calculating the ADJUSTED_COST - DEPRN_RESERVE, from the FA_DEPRN_SUMMARY table.

However, as this calculation depends on depreciation, we are unable to see the updated NVB values ​​of the asset in the query, in cases where they are fully or partially retired.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!