Finance¶

Overview¶

The Finance capability provides comprehensive financial analytics covering general ledger, receivables, payables, posting group analysis, budget management, and BC financial report row definitions.

This is typically the most important capability for any deployment — it covers core financial reporting needs including dynamic financial reports (using BC's row definitions), daily aging snapshots, and budget vs. actual analysis.

Semantic Model Tables¶

Dimensions¶

Table	Description
Account	G/L Account master — account number, name, category, and subcategory from BC Chart of Accounts. Includes a ragged hierarchy (up to 7 levels) for drill-down, so accounts nest correctly regardless of how many indentation levels a chart of accounts uses
Currency	Currency master from BC — ISO code, description, and exchange rate attributes. Shared with Sales and Purchasing
Financial Report Row	Financial report row definitions from BC — row numbers, descriptions, totaling types, and formulas for dynamic financial statement rendering. Includes visibility flag for filtering hidden rows and totaling type classification
Aging	Synthetic dimension — 10,500 rows classifying days outstanding (-500 to 10,000) into 14 aging buckets. Each row has bucket description, short label, group, and sort order
General Business Posting Group	BC general business posting groups — customer/vendor classification for tax and GL account mapping
General Product Posting Group	BC general product posting groups — item/resource classification for GL account mapping
Vat Business Posting Group	BC VAT business posting groups — VAT registration classification
Vat Product Posting Group	BC VAT product posting groups — VAT rate classification per product type

Facts¶

Dim Table	Fact Table	Description
General Ledger	General Ledgers	G/L Entry — posting date, document details, debit/credit amounts. The dim table holds transaction details (entry no, document no/type, description)
General Ledger Budget	General Ledger Budgets	G/L Budget Entry — budget amounts by account, dimension, and period
General Ledger Budget Benchmark		Role-playing dimension — selects which budget to use as benchmark for comparison
General Ledger Budget Perspective		Calculation group — switches between Actual and Benchmark budget perspectives
Accounts Receivable	Accounts Receivables	Daily outstanding balance per Customer Ledger Entry. One row per open entry per day with aging bucket classification. An unpaid entry stays in the fact however old it is — only paid/closed entries age out
Accounts Payable	Accounts Payables	Daily outstanding balance per Vendor Ledger Entry. Mirror of Accounts Receivables for the vendor side, including the same open-entry retention. In EV Tecto Insight, Accounts Payable entries also link to the Project dimension (SBA customers), enabling project-level payables filtering

Key Measures¶

General Ledger (8)¶

Measure	Description
General Ledger Amount	Net GL entry amount (debit positive, credit negative)
General Ledger Debit Amount	Debit-side amounts
General Ledger Credit Amount	Credit-side amounts
General Ledger Vat Amount	VAT component of GL entries
General Ledger Primo Amount	Opening balance — balance-sheet accounts accumulate from inception, income-statement accounts start at zero
General Ledger Ultimo Amount	Closing balance — balance-sheet accounts accumulate from inception, income-statement accounts reflect only the selected period's result
G/L Document URL	Direct link to the source document in Business Central
G/L Account URL	Direct link to the G/L account in Business Central

Budget (10)¶

Measure	Description
General Ledger Budget Amount	Budget amount per account and period
General Ledger Budget Primo Amount	Budget opening balance — balance-sheet accounts accumulate from inception, income-statement accounts start at zero
General Ledger Budget Ultimo Amount	Budget closing balance — balance-sheet accounts accumulate from inception, income-statement accounts reflect only the selected period's budgeted result
General Ledger Budget Diff	Variance between actual and budget amounts
General Ledger Budget Diff %	Variance as percentage of budget
General Ledger Budget Benchmark Amount	Benchmark budget amount for comparison
General Ledger Budget Benchmark Primo Amount	Benchmark budget opening balance
General Ledger Budget Benchmark Ultimo Amount	Benchmark budget closing balance
General Ledger Budget Benchmark Diff	Variance between actual and benchmark budget
General Ledger Budget Benchmark Diff %	Variance as percentage of benchmark budget

Receivables (18)¶

Category	Measures
Accounts Receivables	Accounts Receivables Outstanding Balance, Accounts Receivables Invoice Count, Accounts Receivables Avg Payment Timing, Accounts Receivables Amount, Accounts Receivables Days Sales Outstanding
Overdue	Accounts Receivables Overdue Balance, Accounts Receivables Overdue Invoice Count, Accounts Receivables Overdue Invoice %, Accounts Receivables Avg Days Overdue
Due	Accounts Receivables Due Balance, Accounts Receivables Due Invoice Count, Accounts Receivables Due Invoice %
Overdue — Period (P)	Accounts Receivables Overdue Invoice Count P, Accounts Receivables Overdue Invoice % P
Accounts Receivables — Period (P)	Accounts Receivables Invoice Count P
Due — Period (P)	Accounts Receivables Due Invoice Count P, Accounts Receivables Due Invoice % P
Document Link	Receivables Document URL

Payables (18 · 19 in EV Tecto Insight)¶

Category	Measures
Accounts Payables	Accounts Payables Outstanding Balance, Accounts Payables Invoice Count, Accounts Payables Avg Payment Timing, Accounts Payables Amount, Accounts Payables Days Payable Outstanding, Accounts Payables Withheld Amount (EV Tecto Insight only)
Overdue	Accounts Payables Overdue Balance, Accounts Payables Overdue Invoice Count, Accounts Payables Overdue Invoice %, Accounts Payables Avg Days Overdue
Due	Accounts Payables Due Balance, Accounts Payables Due Invoice Count, Accounts Payables Due Invoice %
Overdue — Period (P)	Accounts Payables Overdue Invoice Count P, Accounts Payables Overdue Invoice % P
Accounts Payables — Period (P)	Accounts Payables Invoice Count P
Due — Period (P)	Accounts Payables Due Invoice Count P, Accounts Payables Due Invoice % P
Document Link	Payables Document URL

Use Cases¶

Monthly financial reporting — Render P&L and Balance Sheet using BC's Financial Report row definitions directly in Power BI
Budget vs. actual — Compare GL actuals against budget entries by account, dimension, and period
Budget benchmarking — Compare primary budget against a benchmark budget to track variance between budget versions
Cash flow management — Track receivables and payables aging with daily snapshots across 14 aging buckets
Customer credit risk — Identify overdue receivables by days outstanding classification
Working capital efficiency — Track Days Sales Outstanding and Days Payable Outstanding to monitor how quickly receivables convert to cash and how payables are timed against purchases
Project-level payables — In EV Tecto Insight (SBA), filter outstanding vendor balances and aging by project for project-level accounts payable reporting
Withheld payables tracking — In EV Tecto Insight (SBA), track hold-back amounts withheld from suppliers as a point-in-time balance, separate from outstanding payables
Posting group analysis — Analyze transactions by business and product posting group combinations
Dimension analysis — Slice any GL transaction by up to 8 global dimension combinations
Document drill-through — Click a document link in Power BI to open the original document directly in Business Central