BeyondERP.Newsletter
Menu

Setup step on the Fixed asset roll forward page · Fixed assets

Run Fixed asset roll forward

Choose the parameters that make the report answer the question it is run for.

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 isA report in Excel format that shows opening and closing balances, valuation movements, acquisitions and disposals for fixed assets over a period.
What you do hereUse 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.
ExampleFor 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.
Fixed asset roll forward page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

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 itAt period and year end, when you prepare financial statements and tax reporting.
How oftenMonthly, quarterly or yearly, in line with your closing cycle.
What the output showsAn 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.

Source: Microsoft Learn

Setup steps on this page

Run Fixed asset roll forward

Choose the parameters that make the report answer the question it is run for.

Steps from Microsoft

  1. Go to Fixed assets > Inquiries and reports > Transaction reports > Fixed asset roll forward.
  2. Enter the From date and To date of the period, for example the fiscal year you are closing.
  3. In Currency, choose the currency to report in, such as Accounting currency.
  4. 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.
  5. Open the Excel output and match the closing balances of each group with the ledger.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Balances: OpeningThe net book value on the from date.Microsoft Learn
Balances: ClosingThe net book value on the to date.Microsoft Learn
Acquisitions: Period acquisitionsAcquisitions and acquisition adjustments posted in the period.Microsoft Learn
Depreciations: Period depreciationsDepreciation, depreciation adjustments and extraordinary depreciation posted in the period.Microsoft Learn
Depreciations: Period special depreciationsSpecial depreciation allowance posted in the period.Microsoft Learn
Write-ups/Write downs: Period revaluationsRevaluations posted in the period.Microsoft Learn
Disposals: Net book value at disposalThe book's net book value when it was disposed of.Microsoft Learn
Disposals: Profit/LossThe profit or loss calculated when the book was disposed of.Microsoft Learn

Common errors and fixes

MessageWhat to do
The Format mapping list is emptyImport 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 ledgerFilter 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
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run Fixed asset roll forwardRun 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.Use the roll forward as the period-close asset schedule?Comparing it with the ledger without excluding books that don't post to the ledger.Test: Fixed asset roll forward matches the books

Feature management and licence

Licence or add-inFixed 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 companyPer company: the report reads the fixed assets and books of the current legal entity. Microsoft Learn
Can it be undoneReversible: Running the report changes no data.
If you change it laterThe 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 itemoutput:AssetRollForward Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo 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
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:AssetRollForward
Data migrationLoad 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
Everyone

8Sources