Fixed Assets - Report to Find if Assets have "Amortize Adjustment" flag checked
We are creating a +$0.01 adjustment followed by a -$0.01 adjustment in the fixed assets module for every asset in order to have the “amortize adjustment” flag checked within each asset. To validate that we have updated all the fixed assets amortization adjustment flag checked we are trying to create a report that will pull every asset and whether or not the flag is checked. Is there an easy way to create such a report? We do not want to accidentally leave some assets expensing while the others are amortizing adjustments.
We were looking into something where within the FA_BOOKS table, if the column “RATE_ADJUSTMENT_FACTOR” contains anything other than 1 in it, that it would mean the asset has been previously amortized, however we have found that to be inconsistent. There were instances where we would have anticipated it to be showing up as amortized but it was not. Is this an appropriate way of doing it? Is there some other way?