Fixed assetsInquiries and reportsTransaction reports
output:AssetRollForward
Business process
Generate fixed asset statements in Dynamics 365 Finance
Menu item
output:AssetRollForward
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone
1What it is and why
What it is
A report in Excel format that shows opening and closing balances, valuation movements, acquisitions and disposals for fixed assets over a period.
What you do here
Use this report to get the fixed asset figures needed for period closing, financial statements and tax reporting, by asset, by group and for the legal entity.
Example
For example, at year end the accountant runs the roll forward from 1 January to 31 December in accounting currency and checks that the closing balance of group VEH, 412,000.00, equals the vehicle accounts in the trial balance.
The page in Dynamics 365. page title tab to open what to set or check
About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.
When to run it
When to run it
At period and year end, when you prepare financial statements and tax reporting.
How often
Monthly, quarterly or yearly, in line with your closing cycle.
What the output shows
An Excel workbook per asset, summarized by fixed asset group and legal entity, with Balances: Opening and Closing, Period acquisitions, Period depreciations, Period special depreciations, Period revaluations, and disposal net book value and Profit/Loss. A closing balance that doesn't match the ledger usually points to transactions posted outside the period or on a book that doesn't post to the ledger.
Choose the parameters that make the report answer the question it is run for.
Steps from Microsoft
Go to Fixed assets > Inquiries and reports > Transaction reports > Fixed asset roll forward.
Enter the From date and To date of the period, for example the fiscal year you are closing.
In Currency, choose the currency to report in, such as Accounting currency.
In Format mapping, select Fixed asset roll forward. The Fixed assets model and Fixed asset roll-forward configurations must be imported before the first run.
Open the Excel output and match the closing balances of each group with the ledger.
The book's net book value when it was disposed of.Microsoft Learn
Disposals: Profit/Loss
The profit or loss calculated when the book was disposed of.Microsoft Learn
Common errors and fixes
Message
What to do
The Format mapping list is empty
Import the Electronic reporting configurations the report needs from Lifecycle Services or the Global repository, then select the format in the dialog. Microsoft Learn
Report totals don't match the general ledger
Filter on one book or posting layer: a book that doesn't post to the general ledger (layer None) is in the fixed asset data but not in the ledger. Microsoft Learn
Run it for the whole closing period in accounting currency and match each group's closing balance with its ledger accounts.The report gives opening and closing balances with the period's movements per asset, summarized by group and legal entity, in Excel.
Fixed assets is part of Dynamics 365 Finance. Fixed asset accountants run it at period end. On this system the roles that open the page include Accounting supervisor, Accountant, Accounting manager, Auditor. No Feature management feature needs to be turned on for this page.
Checked in Dynamics 365
Solution architect
5Design impact
Shared or per company
Per company: the report reads the fixed assets and books of the current legal entity. Microsoft Learn
Can it be undone
Reversible: Running the report changes no data.
If you change it later
The report only reads posted fixed asset data; it changes nothing. Its figures change when transactions are posted, reversed or deleted on the books it covers. Microsoft Learn
Technical architect
6Technical
Menu item
output:AssetRollForwardChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To use itAccounting supervisor LedgerAccountingSupervisorAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 16 roles can run this page.Checked in Dynamics 365
Load order: Fixed asset roll forward has no data entity in Data management, so it can't be loaded from a file or a configuration template. The report stores nothing of its own: it reads the posted fixed asset data, so migrate the assets, books and transactions and run it again in the new environment.Microsoft Learn