What's New: Financial Analytics (2024 release wave 2)

Overview

The video, published 2024-10-08, walks through the financial analytics changes in the 2024 release wave 2. It demos the Power BI finance app, the financial reporting templates with their row and column definitions, the Excel reports for fixed assets, and the ad hoc analysis view for fixed assets.

It also points to new documentation on financial reporting and analytics. The speaker says three new demo data sets, for financial reporting, fixed assets and projects, will come in the second minor release to better show these reporting capabilities.

Key points

• The Power BI finance app has 14 reports, with overview pages and KPI pages that drill through to ledger entries for validation and investigation. It is one of six new Power BI apps.
• The financial reporting module gets 17 templates: five row definitions (such as balance sheet and income statement, plus a trial balance) and 12 column definitions (such as year to date, prior year, same period last year). Rows and columns can be mixed and matched.
• Setting up the financial reporting module requires some mapping, and the docs explain how.
• Three new Excel reports cover fixed assets: analysis (which also covers book value), projected value, and details. One new Excel report for consolidation is also added.
• Ad hoc analysis for fixed assets is a query-based view that combines fixed asset table data with multiple dimensions and dates. It supports custom reports and Copilot-assisted report generation.
• New documentation covers the financial reporting overview, performing analytics in Business Central, module setup, and step-by-step creation of row and column definitions.
• Three demo data sets (financial reporting, fixed assets, projects) are expected in the second minor release of this wave.

Features

AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

• query “analyze fixed assets” at 9:10
• table “fixed assets Ledger entries” at 6:58
• table “Ledger entries” at 1:28
• table “customer Ledger entries” at 4:41
• table “general ledger entries” at 4:41

Not found in BC28-30: query “analyze fixed assets”, table “fixed assets Ledger entries”, table “Ledger entries”, table “customer Ledger entries”, table “general ledger entries”.

Quotes

• 0:16 “there are 14 new powerbi reports for the finance area through powerbi eded reports”
• 0:31 “there are 17 new templates five rows 12 columns in the financial reporting module”
• 0:51 “hopefully soon in the second minor uh in this release we will have new data to better demonstrate some of these new reporting capabilities”
• 1:49 “have templates for financial reporting uh five row definition which is basically the reports like balance sheet and income statement and we have”
• 5:41 “compare year to dat or prior Year year-to date or same period last year there’s there’s these different uh 12 different um column definition”
• 6:58 “you have three new reports for fixed assets and one new report for consolidation”
• 12:10 “for the second minor in this release we’re going to provide three new demo datas sets one for financial reporting it will have three”

Disclaimers in the video

• 0:51 coming-later: hopefully soon in the second minor uh in this release we will have new data to better demonstrate some of these new reporting capabilities
• 12:10 coming-later: for the second minor in this release we’re going to provide three new demo datas sets

Presenters (as heard): Brian nson.