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

YTD Depreciation is not showing correct value in Fixed Assets

edited Dec 31, 2025 9:55PM in Assets

Hi

I am using below tables in my query and i am pulling YTD Depreciation from Fa_Deprn_detail table. it is not pulling the record which has deprn_source_code='B' from the table and i see the discrepencies in YTD Deprn value.

In Fixed Assets, the depreciation data displayed in the application is different from the data stored in the Oracle database tables ( Fa_deprn_summary and fs_deprn_detail)

below are the tables and joins:

fa_additions_vl FAB,
gl_code_combinations GCC,
--fa_locations l,
FA_METHODS FAM,
FA_DEPRN_DETAIL FDD,
FA_DEPRN_PERIODS FDP,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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