Select Query for Assets that are not amortised
Hi
Could anybody suggest a SQL select that would give me a list of which assets in a FA Book that has does NOT amortise it adjustments. I found it easy enough to do a query for assets that are marked to amortise, but now our user wants a list of assets where adjustments do not amortise, and I have found this not a straignt forward thing to provide.
Thanks B