Fixed Asset Roll Forward Report in Dynamics 365 Finance & Operations

The Fixed asset roll forward report in Dynamics 365 Finance & Operations provides a detailed, Excel-formatted summary of fixed asset activity over a specified period. It’s a key resource for period-end close, financial reporting, and tax compliance.

Accountants and other users of D365 Finance & Operations often manage large volumes of assets, SKUs, and transactions. While the system offers a wide range of reports and tools to support these tasks, navigating that variety can be challenging.

This article walks you through how to access, import, and use the Fixed asset roll forward report.

Table of Contents

• How to Get the Fixed Asset Roll Forward Report into D365 F&O
• Using the Fixed Assets Roll Forward Report
• Understanding the Fixed Asset Roll Forward Report
• Fixed Asset Roll Forward Report Limitations

Note: Even though most customers, commentators, and consultants still call it Dynamics 365 Finance & Operations or D365FO, Microsoft now technically licenses it as Dynamics 365 Finance and Supply Chain Management.

How to Get the Fixed Asset Roll Forward Report into D365 Finance & Operations

Note: The Fixed asset roll forward report may not be immediately visible in your D365 F&O environment. The Fixed asset roll forward report uses the Electronic reporting (ER) framework and must be imported.

Complete the steps below to import the Fixed asset roll forward report using the Electronic reporting framework:

Step 1

Sign in to D365 F&O using an account with one of the following security roles. These roles will ensure you have the appropriate permission to complete the import process.

• System administrator.
• Electronic reporting developer.
• Electronic reporting functional consultant.

Step 2

Select Workspaces > Electronic reporting.

Step 3

On the Localization configurations form, select Repositories on the Microsoft tile in the Configuration providers:

Step 4

On the Configuration repositories form, select the existing repository with the Dataverse type, then select Open:

Note: If the Dataverse repository type does not appear on the Configuration repositories form, complete the steps below or contact your system administrator for assistance.

1. Click Add to add a new repository.
2. Select Dataverse as the repository type.
3. Click Create repository.
4. Follow the authorization instructions if prompted.
5. Enter a name and description for the repository.
6. Click OK to confirm the new repository entry.
7. Select the new repository of the Dataverse type.

Step 5

On the Dataverse configuration repositories form, import both the Fixed assets model and Fixed asset roll forward.

1. Select the Fixed assets model in the left pane.
2. In the Configurations FastTab, select Fixed assets model and Fixed asset roll forward.
3. On the Versions FastTab, select the desired version.
4. Select Import.
5. If prompted, select Yes to import the latest version of the marked selected configurations.

Note: If the Import button is grayed out (unavailable) in the Versions FastTab, that version has already been imported into the environment.

For additional details, you can refer to the Microsoft official documentation.

Using the Fixed Assets Roll Forward Report

Select Fixed assets > Inquiries and reports > Transaction reports > Fixed asset roll forward.

In the Fixed asset roll forward report form, select the desired report options.

Once generated, the Excel report will be downloaded.

Download an example Fixed asset roll forward report.

Understanding the Fixed Asset Roll Forward Report

The Fixed asset roll forward report is a useful tool for tracking asset balances, acquisitions, disposals, and depreciation over a specified period.

Key information contained in the report includes:

• Balances represent net book values: Opening and closing balances reflect the fixed asset net book value at the start and end dates specified in the report.
• Acquisitions and Depreciations tracked by transaction types: Acquisitions include acquisition and acquisition adjustment transactions, while depreciations cover depreciation, adjustment, special allowance, and extraordinary types, with sums calculated for opening values, period activity, disposals, and closing values.
• Write-ups/write-downs and disposals detail adjustments and outcomes: Write-ups, write-downs, and revaluations are recorded similarly with opening, period, disposal, and closing values; disposals include details on disposal date, net book value at disposal, sale and scrap values, and profit or loss from the transaction.

For additional details, you can refer to the Microsoft official documentation.

Fixed Asset Roll Forward Report Limitations

The Fixed asset roll forward report does have limitations, in that it does not include some key contextual fields such as Location and Financial Dimensions, which are often critical for reporting and analysis.

One workaround to this limitation would be to add these key fields onto your Fixed asset roll forward report Excel file using Excel’s VLOOKUP (or XLOOKUP) by creating an Excel table using the fields from the Fixed asset book V2 Data entity. If you’re looking for training, support, and guidance tailored to your specific situation, learn more about our Finance & Operations support services.

If you are looking for implementations or integrations of Dynamics 365 and the rest of the Microsoft stack, learn more about our work as a Dynamics 365 Finance & Operations Partner.