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

fully retired and reinstated asset details showing zeor value for net book value etc in the query.

Accepted answer
edited Dec 19, 2023 6:05AM in Assets 1 comment


We have a query that fetches details of the asset like ytd_deprn, deprn_reserve, PTD_DEPRN, net book value and a few other columns. This query fetches all the details that are on the Fusion Asset Inquiry page.

But when we fully retire and do the Reinstatement of any asset, the query fetches zero value for ytd_deprn, deprn_reserve, PTD_DEPRN, net book value except cost. But on the front end/application values are visible for the same.

Could you please provide input on the query?



Howdy, Stranger!

Log In

To view full details, sign in.


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