What we do
Tools
Industries
Department
How we workLet's talk →
Home/Dynamics 365/Dynamics Report Options for BC and F&O
Dynamics 365 reporting

Getting a Dynamics Report Out of Business Central or Finance and Operations

The controller wants this month by department, sales wants last quarter's top customers, and the owner wants one page with both plus the warehouse figures. Business Central and Finance and Operations can produce the first two from their own tools. Which Dynamics report tool to use depends on the question, and the third request, with data from outside Dynamics, is the one that usually ends up in a spreadsheet late at night.

Pick the Dynamics reporting tool by the question

The question Where it gets answered Watch for
"Are we on budget this month, by department?" Business Central: Financial Reports (the feature once called account schedules), with G/L rows, actual and budget columns, and dimensions. F&O: Financial reporting, built in Report Designer. Both read the general ledger. Anything that never posts to the ledger, like pipeline or headcount plans, isn't in them.
"Who owes us, and how late are they?" Built-in reports such as Aged Accounts Receivable, which Business Central offers as an interactive Excel report and a print layout. Business Central ships more than 300 reports. The report explorer on each role center lists the ones for your role before you build anything new.
"What's selling, and what's sitting on the shelf?" Business Central's Power BI apps for Sales, Inventory, Inventory Valuation, Purchasing, Manufacturing, Projects and Finance. They're built on Business Central data only. Stock held by a 3PL or a store on another system won't be in them.
"Does this number look right?" Data analysis mode on a list page such as General Ledger Entries, to group, filter and pivot, or Open in Excel for the same list. Great for a one-off check. If someone repeats the same pivot every week, it should be a report.
"How are deals and cases trending?" Dashboards and charts inside the Sales and Customer Service apps, or Power BI on the Dataverse data underneath. Revenue sits in Business Central or F&O, so pipeline next to invoiced sales means joining two systems.
"One board pack with Dynamics and everything else" Power BI over a data store that holds Dynamics and the other systems together. Business Central can extract to a data lake or mirror to Microsoft Fabric. The Dynamics side is documented. The POS, WMS, payroll or second entity on another ledger is the part someone has to build.

Dynamics reports that still need someone every week

The Monday export and paste

How you'll know: A standard report is run, exported to Excel, merged with another file and emailed around.

Fix: If the report is pure Dynamics data, schedule it: Business Central runs reports as job queue entries and drops the output in the Report Inbox, and F&O schedules financial reports daily, weekly, monthly or yearly. If it's merged with outside data, that merge is what needs automating.

Outside numbers typed in by hand

How you'll know: Store sales, warehouse counts or a sister company's figures are keyed into a tab next to the Dynamics export.

Fix: Pull those systems into the same data store on a schedule, matched on the same customer, item and period keys, so the report reads both without anyone typing.

Department reports that don't add up

How you'll know: Total revenue is right, but the department split leaves a large unassigned line.

Fix: The dimensions never made it onto the entries. Fix it where the transactions come in, often an integration that posts without department or location, rather than in the report.

A big report canceled partway through

How you'll know: Business Central stops the run and says the report hit a limit.

Fix: By default a report handles 500,000 rows and runs for up to six hours. Both can be raised for a single report, up to 10 million rows and 12 hours. Past that, the data belongs in Power BI or a warehouse, not a report run.

Navision and Axapta reports, under their new names

If you learned reporting on Microsoft Dynamics NAV (Navision), you're now on Business Central. The account schedules you built are still there, renamed Financial Reports, and the report concepts and layouts carried over with the product. Axapta became Dynamics AX and then Finance and Operations; its financial statements moved from Management Reporter to the Financial reporting tool built into F&O.

So a search for Navision reporting or Axapta reports leads to features that still exist under the new names. What has changed is the reach: Power BI apps, data analysis mode and data lake extracts sit next to the classic reports. For connecting Dynamics to the systems that feed those reports, see Dynamics 365 integrations, and for the API that reporting pipelines read from, the Business Central API.

Dynamics report questions

Does Dynamics 365 have built-in reporting?

Yes, a lot of it. Business Central has Financial Reports, KPIs, Power BI apps by functional area, data analysis mode and over 300 standard reports. Finance and Operations has Financial reporting with Report Designer and Power BI. The Sales and Customer Service apps have their own dashboards and charts.

Is Navision reporting the same as Business Central reporting?

Mostly. Navision became Dynamics NAV and then Business Central, and its reporting came with it. Account schedules are now called Financial Reports, and Business Central adds Power BI apps and data analysis mode on top of the classic reports.

What happened to Axapta reports in Dynamics 365?

Axapta was renamed Dynamics AX and later became Dynamics 365 Finance and Operations. Its reporting moved forward too, with financial statements now built in F&O's Financial reporting tool, the successor to Management Reporter.

Can Dynamics 365 reports run automatically on a schedule?

Yes, within each tool. Business Central schedules a report from its request page as a job queue entry, and F&O schedules financial reports at daily to yearly intervals. A report that combines Dynamics with other systems needs the data pulled together first, and that part has to be built.

Can I build a custom report in Dynamics 365?

Yes. In Business Central you can change report layouts in Word or Excel, build Financial Reports, or write new reports in AL. In F&O you design financial statements in Report Designer. For analysis across many sources, Power BI is the usual answer.

Can a Dynamics report include data from systems outside Dynamics?

Not on its own. The built-in tools read Dynamics data. n-frames builds the pipeline that pulls your other systems, such as a POS, a warehouse system or an entity on another ledger, into one store next to the Dynamics data, so a Power BI report can show them side by side.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.