Journal Entry reserve Ledger report
Hi
My customer is not able to see depreciation reserve amount for few assets which are fully reserved before upgrade. So support suggested us to apply the below data fix script
update FA_DEPRN_DETAIL
set bonus_deprn_amount = decode(bonus_deprn_amount,
NULL, 0, bonus_deprn_amount),
bonus_ytd_deprn = decode(bonus_ytd_deprn,
NULL, 0, bonus_ytd_deprn),
bonus_deprn_reserve = decode(bonus_deprn_reserve,
NULL, 0, bonus_deprn_reserve),
bonus_deprn_adjustment_amount = decode(bonus_deprn_adjustment_amount,
NULL, 0, bonus_deprn_adjustment_amount)
where book_type_code = '&BOOK'
/
update FA_DEPRN_SUMMARY
set bonus_deprn_amount = decode(bonus_deprn_amount,
My customer is not able to see depreciation reserve amount for few assets which are fully reserved before upgrade. So support suggested us to apply the below data fix script
update FA_DEPRN_DETAIL
set bonus_deprn_amount = decode(bonus_deprn_amount,
NULL, 0, bonus_deprn_amount),
bonus_ytd_deprn = decode(bonus_ytd_deprn,
NULL, 0, bonus_ytd_deprn),
bonus_deprn_reserve = decode(bonus_deprn_reserve,
NULL, 0, bonus_deprn_reserve),
bonus_deprn_adjustment_amount = decode(bonus_deprn_adjustment_amount,
NULL, 0, bonus_deprn_adjustment_amount)
where book_type_code = '&BOOK'
/
update FA_DEPRN_SUMMARY
set bonus_deprn_amount = decode(bonus_deprn_amount,
0