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

SQL Query for Fixed Asset YTD Depreciation

in Assets 6 comments

Summary:

Hello,

We have a customized Oracle BI Publisher Report for Fixed Asset's YTD Depreciation.

Our business requirement is that : When an asset is fully depreciated in the middle of the year, YTD Depreciation amount should continue populating till the last month of the fiscal year in the report. (Here, our fiscal year is from 7/1 to 6/30 next year) However, it appears that once an asset is fully depreciated, YTD Depreciation is still populating in fiscal year "FOLLOWING" when the asset was fully depreciated.

Example:

187173 is an asset that stopped depreciating Apr-24. YTD depreciation was correct on the report as of Jun-24. (For the asset that is fully depreciated in the middle of Fiscal Year, we still want YTD Depreciation value to show till the last month of the year)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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