Why Fixed Asset Management Matters: In today’s financial landscape, effective fixed asset management is crucial for regulatory compliance and accurate financial reporting. Dynamics GP users consistently rely on comprehensive reporting, and the Fixed Asset Management module offers an impressive array of 90 out-of-the-box reports. These fixed asset reports allow you to carefully review asset activity, identify transaction errors, and gather essential information for financial, tax, and regulatory compliance reporting.
Recent Updates to Fixed Assets in Dynamics GP (2023-2025)
Before diving into the available reports, let’s highlight the latest updates to the Fixed Asset Management module:
- 2024 Updates: The 2024 year-end update for Dynamics GP includes updated maximum depreciation deduction amounts for luxury vehicles, aligned with IRS guidelines, specifically for assets placed in service during calendar year 2024.
- Year-End Closing Report: Although introduced in earlier versions (Microsoft Dynamics GP 2015 and later), it’s worth noting that a Fixed Asset Year-End Closing report is available. This optional report prints per Book and displays comprehensive asset information affected by the year-end close process, including Asset ID, Description, Cost Basis, YTD depreciation, Accumulated Depreciation, NBV, Placed in Service Date, Depreciated to Date, Quantity, YTD Maintenance, and Status.
- End of Life Notice: Microsoft has announced that Dynamics GP support, including product enhancements, regulatory and tax updates, and technical support, will end December, 2029. Security updates and patches will continue until April 30, 2031. If you’re currently using Dynamics GP, it’s advisable to maintain the most current version to ensure compliance and optimal functionality.
The Complete List of Fixed Asset Reports
The standard reports available in Fixed Asset Management for Microsoft Dynamics GP include:
Setup Reports
- Fixed Assets Account Group Setup
- Fixed Assets Book Setup
- Fixed Assets Book Class Setup
- Fixed Assets Insurance Setup
- Fixed Assets Class Setup
- Fixed Assets Company Setup
- Fixed Assets Lease Company Setup
- Fixed Assets Physical Location Setup
- Fixed Assets Purchasing Posting Accounts Setup
- Fixed Assets Quarter Setup
- Fixed Assets Retirement Setup
- Fixed Assets Structure Setup
- User Fields List Setup
Financial and Activity Reports
- Annual Activity
- Annual Activity Cost
- Basis Report
- Detail Activity
- Mid-Quarter Applicability
Reconciliation Reports
- Fixed Assets to General Ledger Reconciliation – Detail
- Fixed Assets to General Ledger Reconciliation – Summary
- Book to Book Reconciliation
- Book to Book YTD Depreciation Comparison
Depreciation Reports
- Depreciation Detail
- Depreciation Expense to General Ledger
- Depreciation Ledger
- Depreciation Ledger by Class
- Depreciation Ledger by Class – Summary
- Depreciation Ledger by Location
- Depreciation Ledger by Location – Summary
- Depreciation Ledger by Structure
- Depreciation Ledger by Structure – Summary
Inventory Reports
- Fixed Assets Inventory List
- Fixed Assets Inventory List by Class
- Fixed Assets Inventory List by Class – Summary
- Fixed Assets Inventory List by Location
- Fixed Assets Inventory List by Location – Summary
- Fixed Assets Inventory List by Structure
- Fixed Assets Inventory List by Structure – Summary
- Locator List
- Property Ledger
- Asset List by Master Asset ID
Projection Reports
- Annual Depreciation Projection – Detail
- Annual Depreciation Projection – Summary
- Period Depreciation Projection – Detail
- Period Depreciation Projection – Summary
Additions Reports
- Additions
- Additions (Multicurrency)
- Additions by Class
- Additions by Class – Summary
- Additions by Class (Multicurrency)
- Additions by Location
- Additions by Location – Summary
- Additions by Location (Multicurrency)
- Additions by Structure
- Additions by Structure – Summary
- Additions by Structure (Multicurrency)
Retirement Reports
- Retirements
- Retirements (Multicurrency)
- Retirements by Class
- Retirements by Class (Multicurrency)
- Retirements by Class – Summary
- Retirements by Location
- Retirements by Location – Summary
- Retirements by Location (Multicurrency)
- Retirements by Structure
- Retirements by Structure – Summary
- Retirements by Structure (Multicurrency)
Utility Reports
- Transfers
- Financial Detail Summarize
- Fixed Assets Purge
- FA Posting to General Ledger
- FA Posting to General Ledger Reprint
- Physical Inventory Import
- Physical Inventory Update
- Misplaced Physical Inventory
- Missing Physical Inventory
Miscellaneous Reports
- ACRS Tables
- Asset Account Reconciliation
- Asset Label Reconciliation
- Asset Delete Report
- Book ITC Reconciliation
- Fixed Assets Custodian Reconciliation
- Create Batch Headers
- Fixed Assets Migration Results
- Physical Inventory Info Import
- Asset Group Import
- Fixed Assets Note Update
- Error Log Listing
- Fixed Assets Installation Report
- Asset Inquiry
- Asset Book Inquiry Report
- Financial Detail Inquiry Report
- Fixed Assets Batch Inquiry Report
Best Practices for Year-End Closing in Fixed Assets
When performing year-end closing for Fixed Assets, Microsoft recommends specific procedures:
- Timing: Close all books in Fixed Assets after closing Payables Management (especially if you’re interfacing assets from Payables to Fixed Assets), but before closing the General Ledger year.
- Complete Depreciation: All assets must be ‘depreciated through’ the last day of the current Fixed Assets year before closing. This is EXTREMELY important for accurate financial reporting.
- Book Closing Order: Close the year for each ‘Book’ you have set up. All ‘Books’ should be closed before running depreciation for the new year.
- Important Warning: DO NOT manually edit the year in the Book Setup window to run depreciation for the next year and then change it back before closing the current year. This can cause assets to over-depreciate in the next year.
- No Undo Process: If you accidentally close the Fixed Asset year twice, be aware that there is no Fixed Asset year-end UNDO process. You may need to restore from backup if this occurs.
Customization Options for Fixed Asset Reports
Beyond the standard reports, you can always create custom reports tailored to your specific business needs. The Fixed Asset Management Guide for Microsoft Dynamics GP provides details on:
- Report destinations and formats
- Processing reports on a process server
- Creating report options
- Printing a report with options
- Customizing reports
- Fixed Asset Management Microsoft SQL Server Reporting Services reports
Planning for the Future
With Microsoft’s announced timeline for Dynamics GP support, organizations should consider their long-term ERP strategy:
- Ongoing Support: CAL will continue to support your GP system as long as you need.
- Current Updates: Stay current with the latest releases, such as the October 2024 release (version 18.7), which includes various enhancements across different areas of the product.
- Migration Planning: If you plan to eventually transition to another ERP solution like Dynamics 365 Business Central or Acumatica, ensure your Dynamics GP is updated to the most recent version for the smoothest migration path.
- Compliance Considerations: Maintain regular updates to ensure regulatory compliance, especially for tax reporting and financial statement requirements.
Need Help Setting Up Fixed Assets?
The Fixed Asset Management module in Microsoft Dynamics GP allows you to perform numerous tasks efficiently, including:
- Easily calculating depreciation
- Importing information from other sources
- Creating and utilizing asset groups to simplify maintenance
- Moving assets to new general ledger accounts or property tax locations
- Retiring assets (partially or completely) or entire asset groups
If you need assistance with setting up or optimizing your Fixed Asset Management module, our team of experienced consultants is ready to help.
Contact us today at 860-485-0910 x4 or email sales@calszone.com to discuss your Fixed Asset Management needs.
Additional Resources:
- Fixed Assets – A Forgotten Dynamics GP Module You Already Own
- Eliminate Manual Entry in Dynamics GP Tip #4 – Stop Tracking Fixed Assets In Spreadsheets
- Microsoft Dynamics GP Year-End 2024: Fixed Assets
Updated May 2025 by CAL Business Solutions, www.calszone.com
By CAL Business Solutions Inc., Connecticut Acumatica & Microsoft Dynamics GP / 365 BC Partner, www.calszone.com
