Fixed Asset Depreciation

(0) Share

Report

Posted on by Allan Fernandes

230

Hello. I am using GP 10. I was wondering if it is possible to get the depreciation rate per month for all my fixed assets in a book? Perhaps if GP does not provide this report, how do i go about writing a customized SQL query ? Kindly let me know.

Allan Fernandes

*This post is locked for comments

All responses (3)

Answers (0)

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

Re: Re: Re: Fixed Asset Depreciation

I'm not sure why you're not seeing all the columns - they all appear in my install out of the box. You should not have to use SL Builder to do this.
Allan Fernandes 230 on at

Like (0)

Report

Re: Re: Fixed Asset Depreciation

HI Frank,

Thanks for your input. For some reason, i am not able to see the Periodic depreciation rate column that you are talking about.

can i add this periodic depreciation rate field somewhere in smartlist builder? kindly let me know.

Please find my FA column screenshot at the following link http://www.firstbahrain.com/GP/FAscreenshot.jpg

Thanks again for all your input. I appreciate it all

Allan Fernandes
Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

Re: Fixed Asset Depreciation

Yes, use the 'Fixed Assets Books' SmartList, filter it by the book and add the 'periodic depreciation rate' column to it.