Reports — EV Insight¶
Pre-built Power BI reports that give you immediate insight into your Business Central data. Each report is deployed alongside the semantic model to your Power BI / Fabric workspace.
EV Insight — Finance¶
The Finance report covers your core financial data with interactive pages for drilling into details.
Report Pages¶
| Page | Description |
|---|---|
| Financial Insight | Landing page with key financial KPIs and navigation |
| Income Statement | Profit and loss by account, period, and dimension |
| Income Statement — Hierarchy | P&L with account hierarchy drill-down |
| Balance Sheet | Assets, liabilities, and equity overview |
| Receivables | Accounts receivable aging and open entries |
| Receivables — Detail | Customer-level receivables drill-through |
| Payables | Accounts payable aging and open entries |
| Payables — Detail | Vendor-level payables drill-through |
| Actuals — Detail | General ledger entry detail drill-through |
EV Insight — Sales¶
The Sales report covers revenue, profitability, and open orders, with pages for analysing sales by customer, item, salesperson, and geography.
Report Pages¶
| Page | Description |
|---|---|
| Open Orders | Landing page with sales order backlog and shipped-but-not-invoiced value by period, customer, and item category |
| Sales, Profit & Quantity by Customer | Revenue, cost, profit, margin, and quantity per customer and item |
| Sales Overview | Revenue against last year with variance, broken down by customer, item, salesperson, country, and currency |
| Sales Overview 2 | Monthly revenue, cost, profit, and margin trend against last year |
| Sales Map | Revenue and profit plotted on a map by customer country and city |
| Salesperson Commission | Revenue, cost, profit, margin, and invoiced/credited quantity per salesperson |
| Documents | Drill-through to the underlying sales invoices and credit memos by customer and account |
| Sales Amount — Detail | Drill-through detail behind a selected sales amount |
EV Insight — Purchasing¶
The Purchasing report covers vendor spend and open purchase orders, with pages for analysing purchases by vendor, item, buyer, and geography.
Report Pages¶
| Page | Description |
|---|---|
| Open Orders | Landing page with purchase order backlog and received-but-not-invoiced value by period, vendor, and item |
| Purchase Overview | Purchase amount against last year with variance, broken down by vendor, item, buyer, country, and currency |
| Purchase Overview 2 | Year-to-date purchase amount against the same period last year, by month and vendor |
| Purchase Map | Purchase amount, quantity, cost, and line discount plotted on a map by vendor country and city |
| Vendor Purchase Analysis | Purchase amount and quantity by vendor, comparing vendor volume against spend |
| Documents | Drill-through to the underlying purchase invoices and credit memos by vendor and account |
EV Insight — Inventory¶
The Inventory report covers inventory performance, valuation, and aging with interactive pages for drilling into item-level detail.
Report Pages¶
| Page | Description |
|---|---|
| Inventory Performance | Landing page with the headline KPIs — Inventory Turnover, Inventory Days on Hand, Inventory Days of Cover, and Cost of Goods Sold |
| Inventory Value Trend | Opening Inventory Value, Inventory Value Moved, and Closing Inventory Value over time |
| Inventory On Hand | Closing Inventory Quantity and Closing Inventory Value by item and storage location, with average unit cost |
| Inventory Turnover | Inventory Turnover, Inventory Days on Hand, and Inventory Days of Cover against Cost of Goods Sold |
| Inventory Age | Closing Inventory Quantity and Value broken down by inventory age band and age group |
| Inventory Age Analysis | Average, Oldest, and Youngest Inventory Age plus GMROI, for drilling into what drives aging |
| Item Details | Item-level drill-through with opening and closing quantity and value, turnover, and days on hand |
| Report Guide | Navigation and usage guide for the report |
Semantic Model¶
The EV Insight semantic model is fully operational and deployable to your Power BI / Fabric workspace. It provides:
- 70 tables — dimensions, facts, and measure tables covering all 6 capabilities
- 151 DAX measures — pre-built calculations for sales, purchasing, finance, projects, receivables, and payables
- Pre-defined relationships between all dimension and fact tables
- Dynamic number formatting via calculation group
- Time intelligence support for YTD, QTD, MTD, and period comparisons
Customers can build their own reports immediately using this semantic model in Power BI Desktop or the Power BI web editor.
Report Roadmap¶
Report pages covering the following areas are planned:
- Projects — Project overview, budget vs. actual, and project profitability