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

Hi,

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?

Regards,

Sameer