New: Odoo and Dynamics 365 cost calculators.Estimate your costs

ERP dashboard guide for sales, finance, and operations on Business Central or Odoo

An ERP dashboard is a role-based screen of live KPIs. Power BI Pro adds $14 USD or $19 CAD per viewer per month on Business Central, as of October 2026.

Both platformsERP Fundamentals11 min readUpdated 36 sources

Key takeaways

  • Choose Business Central when the Role Center plus the Finance, Sales, and Inventory Power BI apps cover the decisions, and you can name who will hold a Power BI Pro license.
  • Reading Sales Overview as recognized revenue. It includes posted and unposted documents. Label it, or finance will reject the whole screen.
  • An ERP dashboard is a role-based screen of KPIs drawn from the ERP database.
  • A dashboard shows a short set of KPIs.

What is an ERP dashboard?

An ERP dashboard is a role-based screen of KPIs drawn from the ERP database. ERP dashboards are the set of those screens, one for each role, so the owner, the finance lead, and the operations manager each see the numbers they act on. Dashboard ERP software, for a 20 to 100 person firm, is that screen inside Dynamics 365 Business Central or Odoo. Slide-template galleries and a separate data warehouse are different products.

In Business Central the role sets the home page, called the Role Center. The Business Manager role is the default. The Activities area shows current data, and KPIs can display a chart such as cash flow or income and expenses. In Odoo 19, Dashboards lets people consult, interact with, customize, and build dashboards that show data from the Odoo database. Spreadsheets are the foundation, and data sources pull the latest data each time a dashboard is opened or refreshed.

Who opens it depends on the decision. Microsoft maps the Business Central Power BI Sales app, generally available in 2024 release wave 2, like this: leadership uses Sales Overview, Period-Over-Period Growth, and Month-To-Date; managers use Sales by Salesperson and Actual vs. Budget; daily sellers use Sales by Item and Sales by Customer. Finance uses the Finance app. Inventory, purchasing, manufacturing, projects, subscription billing, and sustainability each have their own Power BI app, with a semantic model, KPI measures, and links on Role Centers.

The same database can still show two totals. Sales Overview in the Business Central Sales app includes both posted and unposted documents. A finance screen built from posted G/L entries will sit lower whenever orders are still open. That gap is a timing difference you should label on the tile. It is the usual reason finance, sales, and operations walk into the same meeting with three spreadsheets.

ERP reporting: the four types of ERP reports and how they differ from a dashboard

A dashboard shows a short set of KPIs. ERP reporting is the wider job of pulling data out of the ERP into structured outputs, and it falls into four types: financial, operational, compliance and ad-hoc. The type decides the tool, which is why a dashboard is the wrong place for a statutory income statement and a fixed-layout report is the wrong place to explore a question.

Financial reports are the statements finance closes the books on: income statement, balance sheet, cash flow and trial balance, usually split by dimension and compared with budget. They tie back to the general ledger. Operational reports cover day-to-day activity such as inventory valuation, order status, production schedules, purchase order cycle times and aged receivables, and they answer what needs action now. Compliance reports produce the documents regulators, auditors and tax authorities require, which depends on centralized data, an audit trail and separation of duties. Ad-hoc reports answer a one-off question on demand without waiting for a scheduled run, and they are what keeps finance from exporting the whole ledger to Excel.

On Business Central, financial reports are built on row and column definitions over the chart of accounts and G/L account categories, and they export to PDF and Excel. Odoo ships accounting reports such as Balance Sheet, Profit and Loss, General Ledger, Aged Receivable, Aged Payable and Cash Flow Statement, and its pivot and graph views handle ad-hoc questions. A dashboard sits on top of these: it takes the few figures an owner acts on and keeps them current.

The four types of ERP reports and the tool layer that fits each, as of October 2026.
TypeTypical outputsMain readersTool layer that fits
FinancialIncome statement, balance sheet, cash flow, trial balance, actual vs budgetController, finance lead, auditorsBusiness Central Financial Reports or the Odoo accounting reports
OperationalInventory valuation, order status, aged receivables and payables, exception listsOperations, warehouse, AR and AP clerksModule lists, pivots and the role dashboard
ComplianceStatutory packs, tax formats, audit trailsFinance, compliance, external auditorsFixed-layout reports with permissions and an immutable export
Ad-hocOne-off questions, cross-module trendsManagers and analystsOdoo Spreadsheet and pivots, Business Central analysis mode, Power BI

ERP dashboard sales data: what the sales screen should show

An ERP dashboard for sales is the back-office view of quotations, orders, revenue, margin, and who sold what. It is built for a sales manager and a finance lead who need the same definitions. Odoo 18 documents a standard Sales dashboard with quotation and order counts, revenue, average order value, a monthly sales chart, and tables for top quotations, sales orders, products, salespeople, and countries. The default period filter is the last 90 days.

Which standard Odoo dashboards appear depends on which apps are installed. Seeing the Sales dashboard is separate from seeing its data, because record rules still apply. Odoo’s own example: giving Sales / User: Own Documents Only access to the Sales dashboard is misleading, because those users only see their own sales. A company sales screen needs a group that can read company sales. Keep the own-documents group for a personal view.

On Business Central, pick the report from the decision. Sales by Customer includes sales amount, sales quantity, cost amount, gross profit, gross profit margin, and sales amount as a percent of total sales. Sales by Item and Sales by Salesperson cover the daily and manager cuts. Actual vs. Budget is the manager check against the number finance already filed. Sales Overview is the leadership rollup, and it includes posted and unposted documents, so do not read it as recognized revenue.

Worked example, with the assumptions stated. Last 90 days: posted invoices of $480,000, open orders of $60,000 that are not yet posted, and cost on the posted invoices of $312,000. Recognized revenue for finance is $480,000. Gross profit on that posted slice is $168,000, which is 35 percent of $480,000. Sales Overview can show $540,000 because it includes the unposted $60,000.

Average order value depends on which documents the tile counts. If 80 posted orders make up the $480,000, average order value is $6,000. Put the document rule in the tile title so sales and finance use the same total in the weekly meeting.

Sales data on the Odoo standard Sales dashboard and on the Business Central Power BI Sales app, as documented as of October 2026.
DecisionOdoo standard Sales dashboard (documented on Odoo 18)Business Central Power BI Sales app
How much did we sell?Revenue, with a default filter of the last 90 daysSales Overview, which includes posted and unposted documents; Month-To-Date for leadership
Are we ahead of last period or budget?The documented Odoo Sales dashboard does not show budget or prior-period variancePeriod-Over-Period Growth for leadership; Actual vs. Budget for managers
How are sales moving through the period?Monthly sales chart over the selected periodMonth-To-Date for leadership
Which orders are still open?Quotation count, order count, top quotations, and top sales orders. The documentation does not say these lists are limited to open orders.Sales Overview includes unposted document amounts in the total and does not list open orders.
What is a typical order worth?Average order valueThe documented Sales app reports do not publish average order value. Sales quantity is units, not orders.
Who and what drove it?Tables for top products, salespeople, and countriesSales by Salesperson for managers; Sales by Item and Sales by Customer for daily sellers
Did we make money on it?Use the accounting figures you insert; the standard sales tiles above do not list a margin formulaSales by Customer includes cost amount, gross profit, and gross profit margin

What is an ERP KPI, and which ones belong on the dashboard?

Start with three to five KPIs tied to decisions someone already owns, not a wall of twenty charts. A defensible starter set covers three areas. Finance contributes liquidity, such as days sales outstanding and aged receivables. Inventory contributes working capital, such as inventory turnover and days of supply. One operational area that matters most this quarter contributes a single leading indicator, for example supplier on-time delivery in an operations-heavy firm or pipeline coverage in a sales-led one.

Every extra KPI adds data-quality work, security rules and refresh monitoring, and it dilutes attention. Pin the starter set to the screen the decision-maker already opens, review it weekly, and add a metric only when someone asks for it and can name the decision it changes.

An ERP KPI is a measure calculated from ERP transactions, with an owner and a decision attached. An ERP KPI dashboard is the screen that puts a short set of those measures in front of that owner. The Business Central Finance Power BI app publishes the formulas, and the measures read G/L entries through account categories.

If account categories are not mapped, the tiles stay blank. Mapping the categories is the first check when a new finance dashboard looks empty.

Days sales outstanding is (Accounts receivable / Revenue) x number of days. Days sales of inventory is (Inventory / Cost of goods sold) x number of days. Cash conversion cycle is DSI + DSO - DPO. These measures are generally available in 2024 release wave 2. The number of days has to match the window on the tile, because a 30-day DSO and a 365-day DSO answer different questions.

Worked example, assumptions stated. Accounts receivable $90,000, revenue over 30 days $180,000, inventory $120,000, cost of goods sold over those 30 days $90,000, and days payable outstanding of 25 days for the same window. DSO is (90,000 / 180,000) x 30, which is 15 days. DSI is (120,000 / 90,000) x 30, which is 40 days. Cash conversion cycle is 40 + 15 - 25, which is 30 days.

On those assumptions, cash is tied up for about a month after you pay suppliers and before customers pay you. If the tile disagrees with that arithmetic, fix account categories before you redesign the chart.

Sales KPIs on the same ERP should use the fields the Sales app already calculates: sales amount, sales quantity, cost amount, gross profit, gross profit margin, and sales amount as a percent of total sales. Sales by Customer publishes cost, gross profit, and gross profit margin. Sales Overview includes posted and unposted documents. Inventory apps ship with default ABC bands of 50 percent, 30 percent, and 20 percent of sales value, and those bands must sum to 100. Reports default to a fiscal calendar. If the company does not report on the fiscal calendar the reports default to, period KPIs will not match the close until the calendar is set.

Odoo’s warehouse dashboards add the operations set: Warehouse Daily Operations, Operation Analysis (average delay, average lead time, fill rate, on-time operations), and Warehouse Metrics (reserved stock as a percent). Overall equipment effectiveness, calculated as availability x performance x quality, belongs on a manufacturing screen. Business Central’s manufacturing and service management UI is the Premium experience, and an Essentials user cannot sign in to a company set to that experience.

Finance ERP KPIs from the Business Central Finance Power BI app, with the published formula.
ERP KPIFormulaCheck before you trust the tile
Days sales outstanding (DSO)(Accounts receivable / Revenue) x number of daysG/L account categories mapped; day count matches the tile window
Days sales of inventory (DSI)(Inventory / Cost of goods sold) x number of daysInventory and COGS sit in the account categories the measure reads
Cash conversion cycleDSI + DSO - DPODSO, DSI, and DPO use the same window
Gross profit and gross profit marginPublished as measures on Sales by Customer, alongside sales amount, quantity, and cost amountSales by Customer publishes cost, gross profit, and gross profit margin. Sales Overview includes posted and unposted documents.
Inventory ABC classDefault bands are 50% / 30% / 20% of sales valueThe three bands must sum to 100

How an ERP dashboard differs from a CRM dashboard

An ERP dashboard reads posted finance, inventory, purchasing, production, and fulfillment from the ERP. A CRM dashboard reads leads, opportunities, campaigns, and cases. IBM’s comparison puts ERP on internal operations and CRM on customer interactions. The audience follows: controller, buyer, and plant or warehouse lead on the ERP screen; sales, marketing, and service on the CRM screen.

Revenue shows up on both, with a different slice. The ERP figure should be the one finance can tie to the general ledger. The CRM figure is pipeline and forecast. On Business Central, Sales Overview mixes posted and unposted sales documents, so it is closer to a commercial total than to recognized revenue. At quarter-end the posted ERP total and the CRM closed-won total should be reconcilable. The unexplained gap is worth its own line on the finance screen.

A 20 to 100 person company rarely needs two BI products to see this. Put recognized revenue, margin, DSO, inventory, and on-time fulfillment on the ERP dashboard. Put pipeline and activity on the CRM dashboard. Where Odoo or Business Central already holds both the order and the opportunity, use one product and two role screens, with the document rule written on each tile.

What typically sits on an ERP dashboard versus a CRM dashboard.
DimensionERP dashboardCRM dashboard
Primary dataPosted finance, inventory, purchasing, production, fulfillmentLeads, opportunities, campaigns, cases, customer activity
Typical usersOwner, finance lead, operations managerSales, marketing, customer service
Time orientationActuals, the close, and current operational queuesForecast and pipeline
Example KPIDSO, DSI, cash conversion cycle, fill rate, gross profit marginWin rate, pipeline, forecast

Design rules for a dashboard people use

Stephen Few’s dashboard pitfalls still hold: weak context, needless precision, the wrong chart, random color, poor layout, and decoration that hides the number. For an SME ERP dashboard, apply four product-specific rules on top of that.

Each tile should answer one decision a named person makes this week. A 2026 design article suggests 5 to 7 KPIs per role. Treat that as one writer’s cap, useful when a Role Center has turned into a wall of charts. The stricter test is the decision: if nobody acts when the number moves, take the tile off.

  1. Write the document rule on the tile

    State whether the figure includes unposted documents, which companies it covers, and the date window. Sales Overview includes posted and unposted documents. The Odoo Sales dashboard defaults to the last 90 days. A tile without those words will be reread in a spreadsheet before anyone trusts it.

  2. Match the chart to the question

    Use a line for a trend such as the monthly sales chart, a bar when people compare salespeople or products, and a table when they need a customer list with margin. A single KPI such as DSO is a number with the prior window beside it. Gauges and heavy decoration make the exception harder to see.

  3. Separate personal layout from the company standard

    In Business Central a user can move, hide, or add fields, tiles, and parts on their own Role Center. That personalization does not change anyone else’s workspace. A layout for a whole role is an administrator change to the profile. In Odoo, only Dashboards / Admin can customize a dashboard or change its configuration.

  4. Duplicate an Odoo standard dashboard before you edit it

    Odoo warns that editing a standard dashboard is risky. Those dashboards are reinstalled on each version upgrade, and customizations on the original are lost. The documented fix is to duplicate first, then change the copy. Schedule a quarterly pass to drop tiles nobody opens.

How to build an ERP dashboard

The sequence is the same on both products. Agree the questions and the metric definitions, then connect the ERP’s own data, then give each role a small screen. Keep the first screen to one role and a handful of agreed numbers. Odoo publishes Success Pack hours for configuration and training. Business Central dashboard work is quoted per project.

  1. List the weekly questions per role

    Finance asks whether cash is coming in faster than it is going out. Sales management asks which people and products beat budget, using cost, gross profit, and gross profit margin from Sales by Customer. Sales Overview, the leadership rollup, includes both posted and unposted documents. Operations asks about average delay, lead time, fill rate, on-time operations, and reserved stock as a percent. Three to five questions per role are enough for a first screen. Write the owner’s name next to each question.

  2. Lock the definitions

    For each KPI, write the formula, the day count, whether unposted documents count, and the company scope. Use the Finance app formulas for DSO, DSI, and cash conversion cycle once G/L account categories are mapped. Use the same window for every term in the cash conversion cycle.

  3. Pull from the ERP, on open or on refresh

    Odoo data sources pull the latest database data each time the dashboard is opened or refreshed. Charts on Odoo’s spreadsheet dashboards read the database. Business Central Power BI reports for the online product read a secondary read-only replica, in place since February 2022, so reporting load stays off the transactional database. Microsoft recommends API pages over OData web services as the Power BI data source for Business Central online.

  4. Set refresh to the decision

    Role Center Activities show current data for the work queue. Power BI apps refresh on a schedule in the Power BI service. A fulfillment queue that changes through the day belongs on the Role Center or on an Odoo operations dashboard that refreshes when opened. A margin KPI that depends on the close can refresh daily. One Power BI template app is installed per company, so a second company needs its own install.

  5. Give each role a screen, then watch what they open

    Ship the finance formulas, one sales screen with the posted-versus-unposted label, and one operations queue. After a month, remove tiles with no owner. On Odoo, build from a duplicate of the standard dashboard so the next upgrade does not wipe the work. Flectic stays after go-live to adjust the views as the close and the product mix change.

Build it in Dynamics 365 Business Central

Start with the Role Center you already pay for. Pick the role, confirm the Activities area, and add the KPI chart the role needs, such as cash flow or income and expenses. Users personalize only their own page. When the whole finance team should see the same layout, an administrator changes the profile.

Add a Power BI app only when the Role Center chart is too thin. Business Central ships Power BI apps for Finance, Inventory, Inventory Valuation, Manufacturing, Projects, Purchasing, Sales, Subscription Billing, and Sustainability. Each app has a semantic model and KPI measures, plus pages that embed the reports and links on Role Centers. The Sales and Finance apps are generally available in 2024 release wave 2.

License split, as of October 2026. Business Central online includes a free Power BI license for common in-product use. The Business Central Power BI apps need Power BI Pro, or Power BI or Fabric Premium capacity, for the installer, the user who refreshes data, and each user who opens the reports. A free Power BI license does not cover those apps.

Installing a template app requires Power BI Pro. People who open the reports also need a paid Business Central license: Essentials, Premium, or Team Member. Connector AL apps are already in Business Central.

Setup that changes the numbers: map G/L account categories before you trust Finance KPIs. Reports default to a fiscal calendar. If the company does not report on that calendar, set it so period KPIs match the close. Keep ABC bands summing to 100 if you change the 50/30/20 defaults. Install the template app once per company. Power BI reports can be embedded on Role Centers.

Essentials shows the common finance, sales, purchasing, and inventory interface. Premium adds manufacturing and service management. An Essentials user cannot sign in to a company set to the Premium experience, and Microsoft’s documentation assumes Premium. A plant that wants the manufacturing Role Center on that experience is looking at Premium licenses, $110 USD or $149.20 CAD per user per month, paid yearly. The Canadian price is plus applicable tax.

Build it in Odoo

Odoo’s documented build path has three stages. Decide the business question and the list, pivot, or chart that answers it. Insert that view into a spreadsheet and calculate the metrics. Put the visual front end on the first sheet, add global filters, and convert the spreadsheet into a dashboard.

Rights are easy to get wrong. Building a dashboard from scratch requires both Dashboards / Admin and at least Documents / User. Only Dashboards / Admin can customize dashboards or change dashboard configuration. Which standard dashboards you see depends on the apps installed. Duplicate a standard dashboard before you edit it, because upgrades reinstall the original and drop those edits.

My Dashboard is a personal page of live views (list, kanban, pivot, graph, and others). It is separate from the spreadsheet dashboards. You cannot change the filter or group of a view after it is added. You change the source view and re-insert it. It needs both the Dashboards (board) module and the Spreadsheet dashboard module.

Use My Dashboard for one person’s queue. Use a spreadsheet dashboard when finance or sales needs a company screen with global filters.

For sales, start from the standard Sales dashboard documented on Odoo 18: quotation and order counts, revenue, average order value, monthly sales chart, and the top quotations, orders, products, salespeople, and countries, defaulting to the last 90 days. Then check record rules. A user on Sales / User: Own Documents Only will see a dashboard of their own documents only, which is the wrong screen for a company meeting. Warehouse teams can add Warehouse Daily Operations, Operation Analysis, and Warehouse Metrics.

Odoo’s spreadsheet and dashboards page says the first app is free forever with unlimited users, including hosting and support, and that charts pull live database data. If Dashboards is the one app you choose, that is the entry point. A full ERP uses more apps, so budget the Standard or Custom plan in the license section. Odoo figures in this guide stay in USD, the currency on Odoo’s pricing page.

What an ERP dashboard costs in USD and CAD

Prices below are as of October 2026. Role Center charts are included in the Business Central user license. The packaged Power BI apps add Power BI Pro for every person who installs, refreshes, or opens them. Odoo dashboards sit inside the Odoo subscription.

The Odoo pricing page shows two USD amounts for each paid plan, with a note that the discount is valid for 12 months for initial users ordered. Both amounts are listed below. Odoo’s closest published figures for implementation time are Success Pack hours, which cover configuration and training.

Worked Business Central example, assumptions stated. A distributor has 6 Essentials users who post orders and invoices, 4 Team Members who look up records, and 3 managers who open the Sales and Finance Power BI apps. In the US, paid yearly, that is 6 x $80 = $480, plus 4 x $8 = $32, plus 3 x $14 = $42, which is $554 per month. In Canada, paid yearly and plus applicable tax, it is 6 x $108.50 = $651, plus 4 x $10.90 = $43.60, plus 3 x $19 = $57, which is $751.60 per month.

The Role Center cash-flow chart is covered by the user license. If those 3 managers only need the Role Center, the Power BI Pro line ($42 in the US, $57 in Canada) comes off the monthly total.

If the same 6 full users need the Premium experience for manufacturing, US list math is 6 x $110 = $660, plus the same $32 Team Members and $42 Power BI Pro, which is $734 per month, paid yearly. Canada is 6 x $149.20 = $895.20, plus $43.60, plus $57, which is $995.80 per month plus applicable tax. Power BI Premium Per User is $24 USD or $32.60 CAD per user per month, paid yearly, when you need the larger models and more frequent refreshes. A user who already has Pro, Microsoft 365 E5, or Office 365 E5 can step up to Premium Per User for $14 USD per user per month, paid yearly.

Odoo example, same 10 people who need the full app set, assumptions stated. Standard shows both US$31.10 and US$38.90 per user per month, so 10 users show both $311 and $389 per month. Custom, which adds Odoo.sh or on-premise, Studio, multi-company, and the external API, shows both US$61.00 and US$76.20, so 10 users show both $610 and $762. Odoo.sh hosting is extra on Custom.

A Light User is US$8.90, quoted by an advisor, and is limited to tasks such as time off, expenses, attendance, barcode inventory, and shop floor. Someone who builds or administers the company dashboard needs a full user on the plan that includes Dashboards.

Odoo Success Packs, new-customer prices as of October 2026, are the closest published implementation figures. They cover consultant time for configuration and training. Starter is 4 hours at $493 (returning price $580). Basic is 25 hours at $3,060 (returning $3,600). Standard is 50 hours at $5,950 and includes data import assistance (returning $7,000).

Custom is 100 hours at $10,625 and includes customizations and developments (returning $12,500). Pro is 200 hours at $21,250 (returning $25,000). Odoo says 80 percent of projects in the estimator’s scope go live in 200 hours or less. Above 50 users, Odoo asks buyers to contact them. A Business Central dashboard phase is quoted per project.

Business Central and Power BI list prices as of October 2026, per user per month, paid yearly. Canadian prices are plus applicable tax.
LicenseUSDCAD
Business Central Essentials80.00108.50
Business Central Premium110.00149.20
Business Central Team Members8.0010.90
Power BI Pro (required for the Business Central Power BI apps)14.0019.00
Power BI Premium Per User24.0032.60

Business Central or Odoo for the dashboard

Flectic implements both Dynamics 365 Business Central and Odoo. Pick the dashboard that ships with the ERP the company will run day to day. On Business Central that is the Role Center plus the Power BI apps you choose to license. On Odoo that is the Dashboards app.

Business Central fits when finance and operations already live in Microsoft 365, you want the Finance formulas for DSO, DSI, and cash conversion cycle, and you will pay Power BI Pro for each person who opens those apps. As of October 2026 that Pro seat is $14 USD or $19 CAD per user per month, paid yearly, on top of Essentials at $80 USD or $108.50 CAD, or Premium at $110 USD or $149.20 CAD. Team Members at $8 USD or $10.90 CAD can open the reports if they also have Pro and a paid Business Central license.

Odoo fits when the people who own the numbers will edit a spreadsheet that stays on live database data, and you want dashboards inside the app subscription. The one-app-free plan is a real starting point if Dashboards is the app you choose, with unlimited users on Odoo Online. The moment you need sales, inventory, and accounting together, use Standard or Custom and budget both prices the page shows.

  • Choose Business Central when the Role Center plus the Finance, Sales, and Inventory Power BI apps cover the decisions, and you can name who will hold a Power BI Pro license.
  • Choose Odoo when a duplicated standard Sales dashboard, plus a spreadsheet you build for finance, is enough, and record rules are set so company totals are only shown to people who can see company documents.
  • On either product, label posted versus unposted sales, map the accounts behind every finance KPI, and keep personal layouts off the company standard. Review the layout again after the first month-end close.
Where the dashboard lives, and what you pay for it, as of October 2026.
QuestionDynamics 365 Business CentralOdoo
Home screenRole Center for the role. Business Manager is the default. Activities show current data.Dashboards app. Standard dashboards depend on the apps installed. My Dashboard is a separate personal page.
How you add a KPIRole Center chart, or a Power BI app (Finance, Sales, Inventory, Inventory Valuation, Manufacturing, Projects, Purchasing, Subscription Billing, Sustainability).Insert a list, pivot, or chart into a spreadsheet, calculate, then convert the spreadsheet into a dashboard.
Sales screenSales Overview (posted and unposted), Period-Over-Period Growth, Month-To-Date, Sales by Salesperson, Actual vs. Budget, Sales by Item, Sales by Customer.Standard Sales dashboard: quotes, orders, revenue, average order value, monthly chart, top products and salespeople, last 90 days.
Extra analytics licensePower BI Pro at $14 USD or $19 CAD per user per month, paid yearly, for installer, refresher, and every viewer. Plus a paid Business Central license.Included in the app plan. One app free can be Dashboards. Standard shows both US$31.10 and US$38.90 per user per month.
Company scopeOne Power BI template app per company.Record rules still filter the rows. Own-documents users see only their own sales on the Sales dashboard.

ERP software with built-in business intelligence: Odoo vs Business Central

Buyers searching for ERP software for business intelligence usually want to know how much analytics comes with the system before anyone buys a separate BI product. Adding business intelligence and analytics to an ERP has three levels. The first is the native layer inside the product. The second is a BI tool such as Power BI connected to the ERP. The third is a data warehouse that also holds history and other systems. A 20 to 100 person company usually needs only the first level, and sometimes the second.

Odoo makes the native layer the main path. Dashboards are built on spreadsheets whose data sources read the Odoo database each time the dashboard is opened or refreshed, pivot and graph views sit in nearly every app, and the first Odoo app is free with unlimited users. Business Central splits it. Role Center charts, financial reports, Open in Excel and analysis mode come with the license, and the packaged Power BI apps for Finance, Sales, Inventory and other areas add Power BI Pro per viewer.

The native layer stops where data lives outside the ERP. An Odoo spreadsheet reads Odoo records, so figures from an online store, an ad platform or a legacy finance system need an integration before they appear. On Business Central, Microsoft recommends API pages over OData web services as the data source for Power BI, and a warehouse or Fabric only earns its cost when you need multi-year history or several source systems in one model.

Native, embedded and warehouse BI options for a 20 to 100 person company, as of October 2026.
OptionOdooDynamics 365 Business CentralChoose it when
Native layerDashboards, Spreadsheet, pivot and graph viewsRole Center charts, Financial Reports, analysis mode, Open in ExcelNearly all the data you report on lives in the ERP
BI tool on the ERPExternal BI tool on an extract of Odoo dataPower BI apps and custom reports on API pages, Power BI Pro per viewerYou need governed reports shared across many viewers, or cross-source views
Warehouse or lakehouseExtract to a warehouse, then a BI toolExtract or Fabric, then Power BIYou need multi-year history, several source systems or heavy queries kept off the live ERP

Built-in reporting or a BI tool: which one fits the question

ERP databases are built to record transactions, not to run analytics, so heavy queries over years of data can slow the system people post in. That is the main reason a BI tool exists, and it only pays off once the questions outgrow the native layer. Default to built-in reporting for anything finance or compliance has to sign, and reach for a BI tool when the question is exploratory, historical or spans systems.

For the Business Central side of that decision, including licensing and refresh governance, read the Business Central Power BI guide. For the wider Dynamics view, see the Power BI guide.

Which layer to use for which job.
JobBuilt-in ERP reportingBI tool
Close pack, invoices, aged receivables, statutory submissionsFits: fixed layout, ties to the ledgerNot needed
Live view of today's orders, stock and cashFits: reads the transactional data directlyOptional
Self-service exploration by many business usersFits in small teams through spreadsheets and pivotsFits when governance and shared metric definitions matter
ERP data combined with CRM, ads or store dataNeeds an integration firstFits
Multi-year trends and heavy history queriesSlows the live systemFits, usually on an extract

Export formats and controls: PDF, XLSX, CSV and permissions

Each export format has a job. PDF suits signed financial packs, invoices and auditor copies, because the layout and pagination stay fixed. XLSX suits variance work and accountant handoffs. XML, JSON and plain-text or CSV files carry regulatory submissions, bank payment files and system-to-system exchanges.

Business Central financial reports export to PDF and Excel. Odoo produces PDF documents through its QWeb reports, and its pivot views export to XLSX. On Dynamics 365 Finance, Electronic Reporting supports TEXT, XML, JSON, PDF, Word, Excel and OPENXML worksheet formats, and Financial reporting keeps generated reports for 90 days by default, so export Excel or PDF when you need an audit copy that does not change.

The control that matters is who can export what. Decide which roles may export which reports, whether an export may leave the company, and which reports are scheduled to a fixed distribution list rather than pulled ad hoc. Where a spreadsheet is rebuilt every month from a dump, an Odoo spreadsheet on live data or a governed Power BI report removes the uncontrolled copies.

Common export formats and the control that goes with each.
FormatBest forControl
PDFSigned statements, invoices, audit packsLock the layout and archive at period close
XLSXAnalysis, variance work, accountant handoffPrefer a live spreadsheet or governed report over monthly dumps
XML or JSONRegulatory filings, system-to-system exchangeVersion the configuration and do not hand-edit production files
CSV or textBank payments, authority uploadsCheck encoding, delimiters and control totals

The mistakes that sink an ERP dashboard

The failures that show up on these two products are specific. They are rights, document scope, account mapping, and licenses. A chart library will not fix them.

Data quality causes most of them, and it comes before any chart. If dimensions, posting groups and document status rules are inconsistent, every dashboard turns into an argument about whose number is right. On Business Central, global and shortcut dimensions are the skeleton every KPI rolls up through. On Odoo, the parallel is analytic accounts, product categories and multi-company access rights. For the controls behind this, see the ERP data governance guide.

Treat the first month as a correction pass. Compare one tile, one role, and one company against the general ledger and the sales document list. When those three match under a written rule, add the next role.

  • Reading Sales Overview as recognized revenue. It includes posted and unposted documents. Label it, or finance will reject the whole screen.
  • Handing the Odoo Sales dashboard to Sales / User: Own Documents Only and expecting company totals. Those users only see their own sales, so the dashboard understates the company.
  • Editing a standard Odoo dashboard in place. Upgrades reinstall it and the edits are lost. Duplicate first.
  • Leaving Business Central account categories unmapped, then blaming the Finance app when DSO, DSI, and cash conversion cycle are blank.
  • Assuming the free Power BI license inside Business Central covers the Power BI apps. Installer, refresher, and every viewer need Power BI Pro, plus a paid Business Central license. As of October 2026, Pro is $14 USD or $19 CAD per user per month, paid yearly.
  • Installing one Power BI template app and expecting it to serve a second company. The install is one app per company.
  • Personalizing a Role Center and expecting the finance team to inherit it. Personalization is per user. A shared layout is an administrator change to the profile.
  • Changing ABC bands so they no longer sum to 100, or leaving the fiscal-calendar default when the company reports on a different year. Both change inventory and period KPIs without an obvious error message.
  • Putting an Essentials user on a company set to the Premium experience. They cannot sign in. Manufacturing and service management are the Premium experience, at $110 USD or $149.20 CAD per user per month, paid yearly.
  • Showing unposted drafts in financial metrics. Filter to posted entries before a figure reaches DSO or margin.
  • Leaving the returns and credit memo policy unwritten, so revenue is counted twice or not at all.
  • Mixing companies on one screen by accident. Set one company filter per dashboard, or make multi-company an explicit choice.
  • Giving no one ownership of customer, item and vendor master data, so gaps stay open week after week.
  • Skipping a written definition of gross margin: which cost layer, which discounts, whether freight counts.

How Flectic can help

Flectic is an independent consultancy that implements both Odoo and Dynamics 365 for companies of 20 to 100 people in the US and Canada, and we earn no vendor quota on either. If you are still choosing, discovery compares reporting, budget, integrations, in-house capacity and growth plans on both platforms, and we recommend one in writing before any configuration starts. Flectic sends a written proposal with a fixed price for each phase before work starts. Read about our ERP selection service, then Book a free discovery call.

Sources

  1. Odoo 19 Dashboards lets users consult, interact with, customize, and build dashboards that show data from the Odoo database. Spreadsheets are the foundation; data sources pull the latest data each time a dashboard is opened or refreshed.

    odoo.comChecked yes, October 2026
  2. Which standard Odoo dashboards appear depends on which apps are installed. Editing a standard dashboard is risky because those dashboards are reinstalled on each version upgrade and customizations on the original are lost. The documented fix is to duplicate first.

    odoo.comChecked yes, October 2026
  3. Seeing an Odoo dashboard is not the same as seeing its data. Record rules still apply. Giving Sales / User: Own Documents Only access to the Sales dashboard is misleading because those users only see their own sales.

    odoo.comChecked yes, October 2026
  4. Building an Odoo dashboard from scratch requires both Dashboards / Admin and at least Documents / User. Only Dashboards / Admin can customize dashboards or change dashboard configuration.

    odoo.comChecked yes, October 2026
  5. Odoo 18 documents a standard Sales dashboard that shows quotation and order counts, revenue, average order value, a monthly sales chart, and tables for top quotations, sales orders, products, salespeople, and countries, with a default period filter of the last 90 days.

    odoo.comChecked yes, October 2026
  6. Odoo’s documented build path is three stages: decide the business question and the list, pivot, or chart that answers it; insert that view into a spreadsheet and calculate metrics; then put the visual front end on the first sheet, add global filters, and convert the spreadsheet into a dashboard.

    odoo.comChecked yes, October 2026
  7. Odoo My Dashboard is a personal page of live views (list, kanban, pivot, graph, and others), not a spreadsheet. You cannot change the filter or group of a view after it is added; you change the source view and re-insert it. It needs both the Dashboards (board) and Spreadsheet dashboard modules.

    odoo.comChecked yes, October 2026
  8. Odoo warehouse dashboards include Warehouse Daily Operations and Operation Analysis with average delay, average lead time, fill rate, on-time operations, and reserved stock percent; reserved stock percent lives in the related Warehouse Metrics dashboard.

    odoo.comChecked yes, existing guide source
  9. Odoo’s spreadsheet and dashboards page says the first app is free forever with unlimited users, including hosting and support, and that charts pull live database data.

    odoo.comChecked yes, October 2026
  10. As of October 2026 the Odoo pricing page shows Standard at both US$31.10 and US$38.90 per user per month, and Custom at both US$61.00 and US$76.20 per user per month, with a note that the discount is valid for 12 months for initial users ordered. One App Free is one app with unlimited users on Odoo Online. Light User is US$8.90, quoted by an advisor, limited to tasks such as time off, expenses, attendance, barcode inventory, and shop floor. Custom includes Odoo Online, Odoo.sh, or on-premise, Studio, multi-company, and external API. Odoo.sh hosting is extra.

    odoo.comChecked yes, October 2026
  11. Odoo Success Pack new-customer prices as of October 2026: Starter 4 hours US$493 (returning US$580); Basic 25 hours US$3,060 (returning US$3,600); Standard 50 hours US$5,950 including data import assistance (returning US$7,000); Custom 100 hours US$10,625 including customizations and developments (returning US$12,500); Pro 200 hours US$21,250 (returning US$25,000). Odoo says 80 percent of projects in the estimator’s scope go live in 200 hours or less. Above 50 users, Odoo asks buyers to contact them.

    odoo.comChecked yes, October 2026
  12. In Business Central, the role sets the home page (Role Center). The Business Manager role is the default. The Activities area shows current data, and KPIs can display a chart such as cash flow or income and expenses.

    learn.microsoft.comChecked yes, October 2026
  13. A Business Central user can personalize only their own Role Center and pages: move, hide, or add fields, tiles, and parts. Personalization does not change other users’ workspaces. Profile (role) layout changes that apply to many users are an administrator task.

    learn.microsoft.comChecked yes, October 2026
  14. Business Central ships Power BI apps for Finance, Inventory, Inventory Valuation, Manufacturing, Projects, Purchasing, Sales, Subscription Billing, and Sustainability. Each app has a semantic model and KPI measures, plus pages that embed the reports and links on Role Centers.

    learn.microsoft.comChecked yes, October 2026
  15. The Power BI Sales app is generally available in Business Central 2024 release wave 2. Leadership uses Sales Overview, Period-Over-Period Growth, and Month-To-Date. Managers use Sales by Salesperson and Actual vs. Budget. Daily sellers use Sales by Item and Sales by Customer. Sales by Customer includes sales amount, sales quantity, cost amount, gross profit, gross profit margin, and sales amount as a percent of total sales. Sales Overview includes both posted and unposted documents.

    learn.microsoft.comChecked yes, October 2026
  16. Finance Power BI KPIs in Business Central include days sales outstanding as (Accounts Receivable / Revenue) x number of days, days sales of inventory as (Inventory / Cost of Goods Sold) x number of days, and cash conversion cycle as DSI + DSO - DPO. Measures read G/L entries through account categories. Generally available in 2024 release wave 2.

    learn.microsoft.comChecked yes, October 2026
  17. Business Central online includes a free Power BI license for common in-product use. The Business Central Power BI apps require Power BI Pro, or Power BI or Fabric Premium capacity, for the installer, the user who refreshes data, and each user who opens the reports. Users of those reports also need a paid Business Central license (Essentials, Premium, or Team Member). A Power BI free license does not cover the Business Central Power BI apps. Microsoft recommends API pages over OData web services as the Power BI data source for Business Central online. Since February 2022, Power BI reports for Business Central online read a secondary read-only database replica. One Power BI template app is installed per company.

    learn.microsoft.comChecked yes, October 2026
  18. Installing a Business Central Power BI template app requires a Power BI Pro license. Connector AL apps are already in Business Central. Reports default to a fiscal calendar. Default inventory ABC bands are 50% / 30% / 20% of sales value and must sum to 100.

    learn.microsoft.comChecked yes, October 2026
  19. Essentials in Business Central shows common finance, sales, purchasing, and inventory UI. Premium adds manufacturing and service management. An Essentials-licensed user cannot sign in to a company set to the Premium experience. Documentation assumes Premium.

    learn.microsoft.comChecked yes, October 2026
  20. As of October 2026, Dynamics 365 Business Central Essentials is US$80 per user per month, Premium is US$110, and Team Members is US$8, paid yearly.

    microsoft.comChecked yes, October 2026
  21. As of October 2026, Dynamics 365 Business Central Essentials is CA$108.50 per user per month, Premium is CA$149.20, and Team Members is CA$10.90, paid yearly, plus applicable tax.

    microsoft.comChecked yes, October 2026
  22. As of October 2026, Power BI Pro is US$14 per user per month and Power BI Premium Per User is US$24 per user per month, paid yearly. The step-up from Pro, Microsoft 365 E5, or Office 365 E5 to Premium Per User is US$14 per user per month, paid yearly.

    microsoft.comChecked yes, October 2026
  23. As of October 2026, Power BI Pro is CA$19 per user per month and Power BI Premium Per User is CA$32.60 per user per month, paid yearly, plus applicable tax.

    microsoft.comChecked yes, October 2026
  24. ERP covers internal operations such as finance, supply chain, inventory, and production. CRM covers customer interactions such as leads, opportunities, campaigns, and service.

    ibm.comChecked yes, existing guide source
  25. OEE is calculated as availability x performance x quality.

    tulip.coChecked yes, existing guide source
  26. One published design article suggests 5 to 7 KPIs per role. This guide treats that count as that article’s opinion.

    gushwork.aiChecked yes, October 2026, opinion on KPI count only
  27. Stephen Few’s common dashboard pitfalls include inadequate context, excessively precise detail, inappropriate display media, meaningless visual variety, poor arrangement, and decoration clutter.

    perceptualedge.comChecked yes, existing guide source
  28. The four primary types of ERP reports are financial, operational, compliance, and ad-hoc reporting.

    netsuite.comChecked
  29. Business Central Financial Reports use row and column definitions over the chart of accounts and G/L account categories, and support PDF and Excel export.

    learn.microsoft.comChecked
  30. Odoo accounting reporting includes Balance Sheet, Profit and Loss, Executive Summary, General Ledger, Aged Receivable, Aged Payable, Cash Flow Statement and Tax Report.

    odoo.comChecked
  31. Odoo Pivot view supports aggregation with measures and multi-level grouping, with XLSX export; Graph view offers bar, line and pie charts.

    odoo.comChecked
  32. The Business Central analytics stack includes Financial Reports, KPIs, Power BI apps by functional area, ad-hoc analysis mode, Open in Excel, built-in reports, external BI and Microsoft Fabric.

    learn.microsoft.comChecked
  33. Electronic Reporting in Dynamics 365 Finance supports TEXT, XML, JSON, PDF, Microsoft Word, Microsoft Excel and OPENXML worksheet formats.

    learn.microsoft.comChecked
  34. Dynamics 365 Finance Financial reporting: newly generated reports default to a 90-day expiration, and users export Excel or PDF for immutable audit copies.

    learn.microsoft.comChecked
  35. ERP is primarily transaction processing (OLTP), while BI is analysis on consolidated data.

    netsuite.comChecked
  36. Odoo QWeb reports are the primary mechanism for generating printable PDF and HTML documents.

    odoo.comChecked

Frequently asked questions

What are ERP dashboards?

ERP dashboards are role-based screens of KPIs read from the ERP. Each role gets the figures that person acts on: finance sees cash and receivables, sales sees orders and margin, operations sees stock and late work. In Business Central the home screen is the Role Center, and in Odoo 19 the Dashboards app builds the screen from spreadsheet data sources that refresh when you open the dashboard. The screen sits in the ERP the company already runs.

What does an ERP dashboard for sales show?

Odoo’s standard Sales dashboard, documented for Odoo 18, shows quotation and order counts, revenue, average order value, a monthly sales chart, and tables for top quotations, orders, products, salespeople, and countries. The default filter is the last 90 days. Business Central’s Power BI Sales app, generally available in 2024 release wave 2, maps Sales Overview, Period-Over-Period Growth, and Month-To-Date to leadership; Sales by Salesperson and Actual vs. Budget to managers; and Sales by Item and Sales by Customer to daily sellers. Sales Overview includes posted and unposted documents, and Sales by Customer adds cost, gross profit, and gross profit margin.

What is an ERP KPI dashboard?

An ERP KPI dashboard is the short list of ERP measures for one role, with the formula and the owner visible. On Business Central the Finance app defines days sales outstanding as (Accounts receivable / Revenue) x number of days, days sales of inventory as (Inventory / Cost of goods sold) x number of days, and cash conversion cycle as DSI + DSO - DPO. Those measures read G/L entries through account categories, so unmapped categories produce blank tiles. The Sales app adds sales amount, quantity, cost, gross profit, and gross profit margin on Sales by Customer.

Can ERP dashboards show current data?

Odoo data sources pull the latest data from the Odoo database each time a dashboard is opened or refreshed. Business Central Role Center Activities show current data. Power BI reports for Business Central online read a secondary read-only replica, which Microsoft has used since February 2022, so the report matches the last refresh and the reporting load stays off the database people post transactions in. Match the cadence to the decision: a picking queue needs the current Activities list, while a margin KPI can refresh with the close.

Can I customize an ERP dashboard for different users?

In Business Central a user can move, hide, or add fields, tiles, and parts only on their own Role Center, and a shared role layout is an administrator change to the profile. In Odoo, only Dashboards / Admin can customize a dashboard or change its configuration, and building one from scratch also needs at least Documents / User. Duplicate a standard Odoo dashboard before editing, because upgrades reinstall the original. Record rules still apply, so a user limited to their own sales documents sees only those sales on the Sales dashboard.

What data does an ERP dashboard use?

It uses the ERP’s own records. Odoo dashboards read the Odoo database through spreadsheet data sources that refresh when the dashboard is opened. Business Central Power BI apps read a read-only replica, in place since February 2022, and Microsoft recommends API pages over OData web services for Business Central online. Finance KPIs read G/L entries through account categories, Sales Overview includes posted and unposted documents, and one Power BI template app is installed per company.

What does the dashboard software cost on Business Central or Odoo?

As of October 2026, Business Central Essentials is $80 USD or $108.50 CAD per user per month, Premium is $110 USD or $149.20 CAD, and Team Members is $8 USD or $10.90 CAD, paid yearly, with Canadian prices plus applicable tax. Role Center charts are included, and the Power BI apps add Power BI Pro at $14 USD or $19 CAD per user per month, paid yearly, for the installer, the refresher, and every viewer. Odoo’s one-app-free plan can be Dashboards, Standard shows both US$31.10 and US$38.90 per user per month, and Custom shows both US$61.00 and US$76.20. Odoo prices here stay in USD, and Success Packs price configuration hours from 4 hours at $493 to 200 hours at $21,250 for new customers.

How do ERP dashboards change a weekly decision?

They put one definition of the number in front of the person who acts. A finance lead who sees DSO move from 15 days to 28 days, on a mapped chart with a 30-day window, can call the overdue accounts that week. A sales manager who sees Sales Overview at $540,000 and posted revenue at $480,000 can treat the $60,000 as still unposted, using the assumptions in the sales section. The screen works when each tile has an owner and a written document rule.

What are the types of ERP reports?

ERP reports fall into four types: financial, operational, compliance and ad-hoc. Financial reports are the statements finance closes the books on, operational reports track daily activity such as stock and orders, compliance reports serve regulators and auditors, and ad-hoc reports answer one-off questions. A dashboard shows a few KPIs from these and does not replace them.

How do you add business intelligence and analytics to an ERP?

Start with the native layer: Odoo Dashboards and Spreadsheet, or Business Central Role Center charts and its Power BI apps. Add a BI tool only when you need governed reports for many viewers or data from outside the ERP, and add a warehouse only for multi-year history or several source systems. Clean dimensions and three to five agreed KPI definitions matter more than the tool.

More on the blog: Implementation and go-live