Fixed assets reports

Path: Business functionality > Fixed assets > Fixed assets analytics > Fixed assets reports · tier official · system fixed-assets · narrative reviewed (checked by Opus)

Overview

This section lists the reports available for fixed assets. They fall into three groups: core fixed asset reports, insurance reports, and maintenance reports. Each report has its own page describing what it shows and which options or filters it offers. An overview page, “Fixed assets reports”, introduces the groups and their uses for financial statements and management.

The core reports cover book value (Book Value 01 and 02), asset lists and acquisition lists, G/L analysis, posting group net change, document numbers, the register, and the journal test report. Three Excel reports (Fixed Asset Analysis, Fixed Asset Details, Fixed Asset Projected Value) support ad-hoc analysis with filters such as class, subclass and location. Analysis and Details also filter by department and project.

Insurance reports show policies, coverage, over- or under-insured status and uninsured assets, along with an insurance journal test and register. Maintenance reports show maintenance expenses, ledger entries and next service dates. Start with the overview page, then open the page for the report that fits your question.

Key points

• Fixed Asset Book Value 01 shows acquisition cost, depreciation and book value, with optional budget depreciation and group totals; Book Value 02 breaks book value down by changes in acquisition, depreciation and appreciation in a period.
• Fixed Asset Analysis and Fixed Asset Details are Excel reports filterable by class, subclass, location, department and project; Fixed Asset Projected Value filters by class, subclass and location and forecasts depreciation and book value for a date range.
• Fixed Asset G/L Analysis and Fixed Asset Register help reconcile fixed asset ledger entries with general ledger entries; the register prints by register number and can print when posting.
• FA Posting Group - Net Change Report shows net change in ledger entries per posting group, with totals across all groups.
• Fixed Asset Document Nos. sorts ledger entries by document type and number and warns about gaps in number series.
• Fixed Asset Journal - Test shows fixed asset journal lines to check before posting; Insurance Journal - Test shows insurance journal lines filtered by journal template and batch.
• Insurance reports include Analysis (premiums, coverage, over/under insured), Coverage Details, List, Tot. Value Insured, Uninsured FAs, and Register.
• Maintenance reports include Analysis (expenses by category and type), Details (ledger entries, optional reversed entries) and Next Service (dates from the Fixed Asset Card).

Learn pages

• FA Posting Group - Net Change Report (report): Review the net change posted in the fixed asset ledger entries for the fixed asset (FA) posting group.
• Fixed Asset - Acquisition List (report): Get a list of all assets acquired within a given date range. You can also include fixed assets that are created but not yet acquired.
• Fixed Asset Analysis (Excel report): Get an overview of your fixed asset, including book value, depreciation, and acquisitions for a given time period.
• Fixed Asset Book Value 01 (report): Get detailed or summarized information for different groups of assets about acquisition cost, depreciation value, and book value.
• Fixed Asset Book Value 02 (report): View the movement in valuation of assets over a period time with a breakdown of values under additions and disposals during the period.
• Fixed Asset Details (Excel report): Get details about fixed assets transactions and reference data that can help you manage your fixed assets.
• Fixed Asset Document Nos. (report): Get a list of fixed asset ledger entries, sorted by document type and number. Use it to audit your fixed assets transactions.
• Fixed Asset G/L Analysis (report): Help reconciling fixed assets transactions to the general ledger and specifically for validating the disposal entries.
• Fixed Asset Journal - Test (report): Review the journal lines in a fixed assets journal. You can use the report to check the lines before you post the journal.
• Fixed Asset List (report): Get a comprehensive list of all fixed assets that an organization owned at a specific point in time.
• Fixed Asset Projected Value (Excel report): TODO
• Fixed Asset Register (report): Get a detailed and organized overview of all your fixed asset transactions.
• Fixed assets reports: Explore the standard reports in Business Central that can help you track and manage your fixed assets.
• Insurance - Analysis (report): Get an overview of your insurance policies, including annual premiums, policy coverage, and information about over or underinsured assets.
• Insurance - Coverage Details (report): Get an overview of how individual fixed assets link to insurance policies.
• Insurance - List (report): Help monitor and manage your insurance coverage for fixed assets, ensuring that the assets are adequately insured.
• Insurance - Tot. Value Insured (report): Ensure that your fixed assets are adequately insured by reviewing the total coverage amount for all insured assets.
• Insurance - Uninsured FAs (report): Check whether you forgot to assign a fixed asset to an insurance policy.
• Insurance Journal - Test (report): Review the journal lines in a fixed asset insurance journal. You can use the report to check the lines before you post the journal.
• Insurance Register (report): Review posted fixed assets insurance ledger entries sorted by register number. Use the report to document posted entries or for auditing.
• Maintenance - Analysis (report): Review your maintenance expenses for fixed assets for different time periods broken down by maintenance types or other categories, such as fixed asset class.
• Maintenance - Details (report): Get detailed information about the maintenance ledger entries for your fixed assets.
• Maintenance - Next Service (report): Get an overview of when service and repairs are planned for your fixed assets.

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

• Report 4411 “EXR Fixed Asset Details Excel” · captioned “Fixed Asset Details (Excel)”
• Report 4412 “EXR Fixed Asset Analysis Excel” · captioned “Fixed Asset Analysis (Excel)”
• Report 4413 “EXR Fixed Asset Projected” · captioned “Fixed Asset Projected Value (Excel)”
• Report 5600 “Fixed Asset - Analysis” · captioned “Fixed Asset Analysis (Obsolete)”
• Report 5601 “Fixed Asset - List” · captioned “Fixed Asset List”
• Report 5602 “Fixed Asset Journal - Test”
• Report 5603 “Fixed Asset Register”
• Report 5604 “Fixed Asset - Details” · captioned “Fixed Asset Details (Obsolete)”
• Report 5605 “Fixed Asset - Book Value 01” · captioned “Fixed Asset Book Value 01”
• Report 5606 “Fixed Asset - Book Value 02” · captioned “Fixed Asset Book Value 02”
• Report 5607 “Fixed Asset - Projected Value” · captioned “Fixed Asset Projected Value (Obsolete)”
• Report 5608 “Fixed Asset - Acquisition List” · captioned “Fixed Asset Acquisition List”
• Report 5610 “Fixed Asset - G/L Analysis” · captioned “Fixed Asset G/L Analysis”
• Report 5611 “FA Posting Group - Net Change”
• Report 5620 “Insurance - Analysis” · captioned “Fixed Asset Insurance Analysis”
• Report 5621 “Insurance - List” · captioned “Fixed Asset Insurance List”
• Report 5622 “Insurance Journal - Test”
• Report 5623 “Insurance Register”
• Report 5624 “Insurance - Coverage Details” · captioned “Fixed Asset Insurance Coverage Details”
• Report 5625 “Insurance - Tot. Value Insured” · captioned “Fixed Asset Total Value Insured”
• Report 5626 “Insurance - Uninsured FAs” · captioned “Uninsured Fixed Assets”
• Report 5630 “Maintenance - Analysis” · captioned “Fixed Asset Maintenance Analysis”
• Report 5634 “Maintenance - Details” · captioned “Fixed Asset Maintenance Details”
• Report 5635 “Maintenance - Next Service” · captioned “Fixed Asset Maintenance Next Service”
• Report 5636 “Fixed Asset Document Nos.”

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.