Depreciation Ledger reports in Fixed Assets

(0) Share

Report

Posted on by Community Member

Can someone explain how these reports are supposed to work? And by that I mean having them agree to a month's depreciation.

As an example my client ran depreciation for Nov. 2014 and the DL report showed the correct GL entry for calculated depreciation. After posting that depreciation entry the reports then show a lower amount, as was noted on another forum post I just responded to, because any fully depreciated assets showed $0 amount for current depreciation.

Running these reports with a specific date gets way more depreciation than was actually calculated. An entire class of fully depreciated assets that have no depreciation amounts this year showed current depreciation when I used the Nov. 2014 date.

I have instructed my client not to use these reports as they cannot accurately reflect current depreciation for a period. Has anyone else found a solution?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Cheryl Waswick on at

Like (0)

Report

Hi Mike,

Unfortunately, there are issues with the new 'as of' date in the Depreciation reports. The only option that produces correct results are the 'Current Amounts'. Do not use any of the 'as of 'date options. Only use "Current Amounts' option. I apologize for the inconvenience. Thanks.

Cheryl

Microsoft Community

Was this reply helpful? Yes No
GMA 1,074 on at

Like (0)

Report

I just ran across this too. Spent all day trying to figure out why Depreciation Ledger with "current amounts" ran as expected, but when set to "End of Previous Year" was calculating negative book values on any assets that were fully depreciated.

I am running GP 2013 SP2. Is this slated for resolution in any upcoming releases/service packs (GP2015 maybe)? I am glad I found this because I was close to deleting the 400+ assets and trying again from the start.

Was this reply helpful? Yes No
Cheryl Waswick on at

Like (0)

Report

Hi GMA,

Wow, I just posted right in time for you.... I'm glad you found this too when you did.

At this time, there is no target fix date for this unfortunately. You can only use "Current Amounts" as the work-around. Since it is a report and there is a work-around, the only way we can get more attention to it is to have more customers log their complaints on it. Therefore, Can I ask you to log a product suggestion on this and state your business impact. Having your voice heard on this suggestion database will help to get our Development team to consider it for a future enhancement, and help to push it up in priority. Resources will be dedicated to the issues that are wanted the most.

MS CONNECT:

connect.microsoft.com/dynamicssuggestions

Thank you in advance,

Cheryl

Microsoft Community

Was this reply helpful? Yes No
GMA 1,074 on at

Like (0)

Report

While I understand, I have to say that this is extremely disappointing because go to any Dynamics GP 2013 "New Features" blog post and all you will see is how we can now run historical depreciation reports.

I am beginning the process to upgrade us to GP 2015; hopefully this is resolved in that version; in the meantime, it looks like Mahmoud AlSaadi has provided a script that may work as a real workaround:

https://community.dynamics.com/gp/b/dynamicsgpessentials/archive/2015/03/18/fixed-assets-historical-depreciation-ledger-report

Was this reply helpful? Yes No
Lisa Hunter 1,616 on at

Like (0)

Report

Hi Cheryl,

Curious, has this been resolved in GP 2015 or GP2016?

Thank you,

Lisa

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Lisa,

I have just encountered the same issue on GP2015. Looks like the bug in the report has not been rectified. For assets that have become fully depreciated as of 31/12/2016, when I print the Depreciation Ledger by Class report as of 31/12/2016, it shows a high value for Net Book Value. Only when I run as of 'Current Amounts', the report is accurate. This is a major issue as my client has been using the Depreciation Ledger by Class report to calculate Audit Adjustments. Looks like GP2015 cannot run Historical Depreciation Ledger reports.

Thanks.

Regards,

Saras

Was this reply helpful? Yes No
Gina Chettle 215 on at

Like (0)

Report

Hi,

Can anyone confirm if this issue is fixed in GP2016? This is one of the major reasons why clients will upgrade - having a historical depreciation report that they can show to the auditors. It is a big issue if it does not work.

Thanks so much!

Was this reply helpful? Yes No