With the release of Microsoft Dynamics GP 2013, Microsoft introduced many new enhancements to the Fixed Asset module.  One of the new features was the ability to print date sensitive, historical Depreciation Ledger reports.  All of the Depreciation Ledger reports include date options such as a specific date, end of previous month or period, and end of previous calendar or fiscal year.  There is also an option to print the report using the current amounts.

If you’ve ever tried printing the reports using an historical date, you may find the amounts do not tie out to your General Ledger for the specified time period.

Microsoft has identified this as a Quality Report Issue:  Accumulated Depreciation and Net Book values are incorrect on FA Depreciation Ledger by Class report with an ‘As of Date’ when asset is entered into Dynamics GP with LTD depreciation and reset life performed.  Tentative Date set for a fix: GP 18.0

We’ve noticed that the historical Depreciation Ledger reports do not work regardless of the how the assets were entered into GP and/or if a reset life was performed.

One workaround suggested by Microsoft is to print the reports using the option “Current Amounts” which really is not an option if you want to print a historical report.

The other option is to install the FA Depreciation Ledger modified reports package created by Microsoft that includes the changes needed to run the reports with an “As of Date”.  Download the package here.

If you are experiencing inconsistencies with your Fixed Assets Depreciation Ledger reports, the RSM help desk can provide assistance with obtaining and installing the modified reports.  RSM offers access to Certified Microsoft Professionals, help desk and phone support, knowledge and experience with third party products and dedicated account management.  Please contact our professionals for more information at erp@rsmus.com or by phone at 855.437.7202.

by Nancy Hogan for RSM