how do i get fa_deprn_override adjustment to work
How do I get the fa_deprn_override to work when using the used_by=adjustment option? Here is an explanation of what we did. First of all, we changed the LIM on one account for an international account from 3 to 5 years to spread out the depreciation. This worked fine, however our tax book is now calculating a different deprecation schedule.
SELECT book_type_code, ASSET_ID, LIFE_IN_MONTHS, RATE_ADJUSTMENT_FACTOR, ADJUSTED_COST, COST,
ROUND(((ADJUSTED_COST/(LIFE_IN_MONTHS/12)/12/RATE_ADJUSTMENT_FACTOR)),2) "DEP EXP"
FROM FA.FA_BOOKS
WHERE TRANSACTION_HEADER_ID_OUT IS NULL
AND DATE_INEFFECTIVE IS NULL