Fixed assets analytics

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

Overview

Fixed assets analytics brings together the ways to examine fixed asset data in Business Central. The overview page lists the options: KPIs, financial reports, consolidation, data analysis, Excel exports and built-in reports, across acquisitions, depreciation, insurance and maintenance.

The hub’s own pages cover the overview and ad-hoc analysis. Ad-hoc analysis uses the Data Analysis feature on FA ledger entries and GL entries, so you can check asset values or depreciation interactively without running a report. Three subtopics go deeper. Built-in tools cover disposing, insuring, maintaining, budgeting and reclassifying assets. Fixed assets reports covers the standard and Excel reports. Legacy reports describes three older reports marked for removal.

Start with the Fixed assets analytics overview to pick an approach. Use ad-hoc analysis for quick questions, and the reports subtopic when you need a standard, repeatable output. Check the legacy page only if you still rely on those older reports.

Key points

• Ad-hoc analysis uses Data Analysis mode on FA ledger entries and GL entries, with pivot mode and column management, and no report run needed.
• Typical ad-hoc scenarios are asset value tracking (fixed asset valuation) and depreciation analysis.
• The overview names KPIs, financial reports, consolidation, data analysis, Excel exports and built-in reports as analysis options.
• Built-in tools cover posting disposals or retirements, insurance coverage, maintenance costs, budgeting, and transferring, splitting or combining assets.
• The Fixed assets reports subtopic has 23 pages on standard and Excel reports: book value, depreciation, acquisitions, ledger entries, registers, insurance and maintenance.
• Legacy reports marked for removal are Fixed Asset Analysis, Fixed Asset Details and Fixed Asset Projected Value.

Subtopics

• Built-in fixed assets analytics tools (5 pages)
• Fixed assets reports (23 pages)
• Legacy reports (will be removed) (3 pages)

More Learn pages

• Ad-hoc analysis of fixed assets data: Learn how to use the data analysis mode to analyze fixed assets data.
• Fixed assets analytics: Learn how to gather, analyze, and share data about fixed assets for business intelligence.

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.

• Page 20 “General Ledger Entries” · on Table 17 “G/L Entry”
• Page 5600 “Fixed Asset Card” · on Table 5600 “Fixed Asset”
• Page 5601 “Fixed Asset List” · captioned “Fixed Assets” · on Table 5600 “Fixed Asset”
• Page 5604 “FA Ledger Entries” · on Table 5601 “FA Ledger Entry”
• Page 5615 “FA Classes” · on Table 5607 “FA Class”
• Page 5616 “FA Subclasses” · on Table 5608 “FA Subclass”
• Page 5617 “FA Locations” · on Table 5609 “FA Location”
• Query 123 “Fixed Assets Analysis” · captioned “Fixed Assets Ad-hoc Analysis”
• Report 5600 “Fixed Asset - Analysis” · captioned “Fixed Asset Analysis (Obsolete)”
• Report 5601 “Fixed Asset - List” · captioned “Fixed Asset List”
• 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”
• Page 5610 “Depreciation Book Card” · on Table 5611 “Depreciation Book” · via Built-in fixed assets analytics tools
• Page 5611 “Depreciation Book List” · captioned “Depreciation Books” · on Table 5611 “Depreciation Book” · via Built-in fixed assets analytics tools
• Page 5625 “Maintenance Registration” · on Table 5616 “Maintenance Registration” · via Built-in fixed assets analytics tools
• Page 5628 “Fixed Asset G/L Journal” · captioned “Fixed Asset G/L Journals” · on Table 81 “Gen. Journal Line” · via Built-in fixed assets analytics tools
• Page 5629 “Fixed Asset Journal” · captioned “Fixed Asset Journals” · on Table 5621 “FA Journal Line” · via Built-in fixed assets analytics tools
• Page 5633 “FA Journal Batches” · on Table 5620 “FA Journal Batch” · via Built-in fixed assets analytics tools
• Page 5636 “FA Reclass. Journal” · captioned “Fixed Asset Reclassification Journals” · on Table 5624 “FA Reclass. Journal Line” · via Built-in fixed assets analytics tools
• Page 5637 “FA Reclass. Journal Templates” · captioned “Fixed Asset Reclassification Journal Templates” · on Table 5622 “FA Reclass. Journal Template” · via Built-in fixed assets analytics tools
• Page 5638 “FA Reclass. Jnl. Template List” · on Table 5622 “FA Reclass. Journal Template” · via Built-in fixed assets analytics tools
• Page 5640 “FA Reclass. Journal Batches” · on Table 5623 “FA Reclass. Journal Batch” · via Built-in fixed assets analytics tools
• Page 5642 “Maintenance” · on Table 5626 “Maintenance” · via Built-in fixed assets analytics tools
• Page 5644 “Insurance Card” · on Table 5628 “Insurance” · via Built-in fixed assets analytics tools
• Page 5645 “Insurance List” · captioned “Insurance Policies” · on Table 5628 “Insurance” · via Built-in fixed assets analytics tools
• Page 5646 “Insurance Statistics” · on Table 5628 “Insurance” · via Built-in fixed assets analytics tools
• Page 5647 “Ins. Coverage Ledger Entries” · captioned “Insurance Coverage Ledger Entries” · on Table 5629 “Ins. Coverage Ledger Entry” · via Built-in fixed assets analytics tools
• Page 5648 “Insurance Types” · on Table 5630 “Insurance Type” · via Built-in fixed assets analytics tools
• Page 5651 “Insurance Journal” · captioned “Fixed Asset Insurance Journals” · on Table 5635 “Insurance Journal Line” · via Built-in fixed assets analytics tools
• Page 5652 “Insurance Journal Templates” · on Table 5633 “Insurance Journal Template” · via Built-in fixed assets analytics tools
• Page 5653 “Insurance Jnl. Template List” · on Table 5633 “Insurance Journal Template” · via Built-in fixed assets analytics tools
• Page 5655 “Insurance Journal Batches” · on Table 5634 “Insurance Journal Batch” · via Built-in fixed assets analytics tools
• Page 5656 “Insurance Registers” · on Table 5636 “Insurance Register” · via Built-in fixed assets analytics tools
• Page 9275 “T. Value Insured per FA Matrix” · on Table 5600 “Fixed Asset” · via Built-in fixed assets analytics tools
• Report 4411 “EXR Fixed Asset Details Excel” · captioned “Fixed Asset Details (Excel)” · via Fixed assets reports
• Report 4412 “EXR Fixed Asset Analysis Excel” · captioned “Fixed Asset Analysis (Excel)” · via Fixed assets reports
• Report 4413 “EXR Fixed Asset Projected” · captioned “Fixed Asset Projected Value (Excel)” · via Fixed assets reports
• Report 5602 “Fixed Asset Journal - Test” · via Fixed assets reports
• Report 5611 “FA Posting Group - Net Change” · via Fixed assets reports
• Report 5620 “Insurance - Analysis” · captioned “Fixed Asset Insurance Analysis” · via Fixed assets reports
• Report 5621 “Insurance - List” · captioned “Fixed Asset Insurance List” · via Fixed assets reports
• Report 5622 “Insurance Journal - Test” · via Fixed assets reports
• Report 5623 “Insurance Register” · via Fixed assets reports
• Report 5624 “Insurance - Coverage Details” · captioned “Fixed Asset Insurance Coverage Details” · via Fixed assets reports
• Report 5625 “Insurance - Tot. Value Insured” · captioned “Fixed Asset Total Value Insured” · via Fixed assets reports
• Report 5626 “Insurance - Uninsured FAs” · captioned “Uninsured Fixed Assets” · via Fixed assets reports
• Report 5630 “Maintenance - Analysis” · captioned “Fixed Asset Maintenance Analysis” · via Fixed assets reports
• Report 5634 “Maintenance - Details” · captioned “Fixed Asset Maintenance Details” · via Fixed assets reports
• Report 5635 “Maintenance - Next Service” · captioned “Fixed Asset Maintenance Next Service” · via Fixed assets reports
• Report 5636 “Fixed Asset Document Nos.” · via Fixed assets reports

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