Others

How to Fix Dynamics 365 Reducing-Balance Depreciation Year-End Value Issue

Khadija Khan Sep 30, 2026 871 views

Question details

The user needs to configure the accounting software to calculate reducing-balance depreciation based on month-end net book values rather than year-end values.

Fixing Dynamics 365 Reducing-Balance Depreciation Using Year-End Values

Product: Dynamics 365 Finance and Operations
Device & OS: not provided
Scenario: Configuring monthly asset depreciation and asset books in corporate accounting software.
Observed behavior: The system calculates reducing-balance depreciation using the net book value at year-end instead of recalculating it from the net book value at each month-end, causing a mismatch with industry monthly depreciation practices.

Before you start

Gather your Dynamics 365 Finance and Operations version, update number, and specific asset book configuration details before adjusting your financial settings.

Solution 1Recommended

Review Asset Book Configuration and Calculation Frequency

Adjusting the depreciation profile settings in Dynamics 365 can help align system calculations with your monthly accounting practices.

Dynamics 365 Finance and Operations allows administrators to customize how and when depreciation is calculated. If the system is using a year-end value, the calculation frequency in the depreciation profile is likely set to yearly rather than monthly.

Access the Fixed Assets Module

Log into Dynamics 365 Finance and Operations and navigate to the Fixed Assets module from the main dashboard.

Open Depreciation Profiles

Go to Setup > Depreciation profiles and select the specific profile associated with the reducing balance method you are using.

Modify Calculation Frequency

Check the 'Calculation frequency' setting and ensure it is set to 'Monthly' instead of 'Yearly' to force the system to use month-end net book values.

Verify Asset Books Mapping

Navigate to Fixed assets > Setup > Books to verify that the newly adjusted depreciation profile is correctly assigned to your active asset books.

Review Asset Book Configuration and Calculation Frequency

Accounting Compliance: Changing depreciation profiles on assets that already have posted transactions may require reversing previous depreciation proposals or using adjustment journals. Always consult your financial controller before saving changes.

Solution 2

Consult Microsoft Support and the Dynamics 365 Community

Since this involves complex, product-specific accounting logic, Microsoft's official channels and community experts are the best resources for advanced configuration.

Free Microsoft Office alternative

Analyze Your Dynamics 365 Financial Exports with WPS Office

While Dynamics 365 manages your ERP and accounting operations, you still need a reliable productivity suite to analyze financial data, format exported reports, and draft documentation. WPS Office provides a lightweight, free alternative to Microsoft Office that is fully compatible with your exported Excel reports.

1. Download and Install: Visit the official WPS website to download the free office suite and install it on your computer.
2. Export Dynamics Data: Export your financial reports, depreciation tables, or asset books from Dynamics 365 into an Excel (.xlsx) format.
3. Analyze with WPS Spreadsheet: Open the exported file in WPS Spreadsheet to seamlessly analyze data, create custom monthly depreciation formulas, and generate charts.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats for seamless financial reporting.Free and lightweight suite, minimizing system resource usage while handling large data exports from Dynamics 365.Familiar user interface ensures zero learning curve when migrating from Microsoft Office.Built-in PDF toolkit for easily converting, combining, and sharing your accounting reports securely.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Dynamics 365 use year-end net book value for reducing-balance depreciation by default?

By default, some reducing-balance depreciation profiles in Dynamics 365 are configured with a yearly calculation frequency. This applies the depreciation percentage to the net book value at the end of the fiscal year rather than recalculating the net book value at the end of each month.

Can I change the depreciation calculation frequency after posting transactions?

Changing depreciation calculation frequencies on an asset book after transactions have been posted is restricted to prevent accounting errors. You will typically need to reverse previous depreciation proposals or post manual adjustment journals. Consult with your system administrator or Microsoft Support before attempting this.

Where can I find my Dynamics 365 Finance and Operations version number?

You can find your version and update number by clicking the Help (?) icon in the top right corner of the Dynamics 365 interface and selecting 'About'. This information is crucial when submitting a ticket to Microsoft support or asking questions in the community forums.

Office Quick Solutions