BeyondERP.Newsletter
Menu

Report page · Fixed assets

Fixed asset balances

A report that shows fixed asset balance amounts such as depreciation, revaluations, write-ups, write-downs and net book values.

Business process
Analyze fixed assets
Menu item
output:AssetBalances
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that shows fixed asset balance amounts such as depreciation, revaluations, write-ups, write-downs and net book values.
What you do hereUse this report to print the balance amounts of fixed assets, such as depreciation, revaluations, write-ups, write-downs, profit and loss and net book values.
ExampleFor example, at month end the accountant runs the balances with subtotals per fixed asset group and compares the net book value of group COMP with the computer asset accounts.
Fixed asset balances 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

Business processAnalyze assets › Analyze fixed assets
Menu pathFixed assets › Inquiries and reports › Transaction reports › Fixed asset balances
Set up firstCreate depreciation proposal Microsoft Learn
Used next byTrial balance Microsoft Learn
Related pagesFixed asset roll forward Microsoft Learn Fixed asset management workspace (Related information) Microsoft Learn
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 itWhen you reconcile fixed asset balances with the general ledger at period end.
How oftenMonthly or at each period close.
What the output showsBalance amounts per asset with subtotals per group and asset as chosen. A difference with the ledger usually comes from a book that doesn't post to the general ledger being included.

Source: Microsoft Learn

Setup steps on this page

Run Fixed asset balances

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 balances.
  2. Check the Currency; it shows Accounting currency by default.
  3. Under Group totals, set Fixed asset group and Fixed asset number to Yes for the levels you want subtotals at.
  4. Read depreciation, revaluations, write-ups, write-downs, profit and loss and net book value, and compare the group totals with the ledger.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
CurrencyThe currency of the amounts.Checked in Dynamics 365Accounting currency
Fixed asset group / Fixed asset number (Group totals)Prints subtotals at that level.Checked in Dynamics 365Yes

Common errors and fixes

MessageWhat to do
The report is emptyCheck the filters under Records to include and that the assets have posted transactions in the books you selected. Checked in Dynamics 365
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 balancesTurn on the Fixed asset group subtotal and keep Accounting currency.The report prints balance amounts such as depreciation, revaluations, write-ups, write-downs and net book values; group subtotals match the ledger accounts per group.Reconcile per group or per asset?Including books that don't post to the ledger when reconciling to the ledger.Test: Fixed asset balances matches the books

Feature management and licence

Licence or add-inFixed assets is part of Dynamics 365 Finance. Fixed asset accountants run the report. 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 undoneNothing to undo: The balances report only reads data; it changes nothing. Microsoft Learn
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:AssetBalances 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, 9 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:AssetBalances
Data migrationLoad order: Fixed asset balances 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

KEEP EXPLORING

More in Fixed assets.

Open the other pages and setup steps in this module, or go back to the Atlas Hub to search every page.