Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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