Business Central + Go Fig
Connect Microsoft Dynamics 365 Business Central to Go Fig for unified ERP analytics and financial reporting.
Microsoft Dynamics 365 Business Central is the system of record for a large share of mid-market companies running Microsoft stacks, but its native reporting is a split of account schedules, Power BI apps, and saved views that rarely answers a strategic question end to end. Go Fig connects to Business Central's v2.0 REST API and OData feeds, lands every GL entry, dimension value, sales invoice, purchase invoice, and item ledger entry in your Financial Intelligence Graph, and makes the data available to Celeste and your finance team. The result is a governed financial dataset with all eight dimensions intact, multiple companies consolidated, and history preserved so you can run segmentation, scenario modeling, and capital-allocation analysis without hand-building another Power BI workspace.
Key facts
- Deployment support
- SaaS, on-premise, hybrid
- Auth
- Entra ID OAuth or Web Service Access Key
- Dimensions
- All 8 global and shortcut dimensions synced
- Multi-entity
- All companies in the environment, consolidated
- Refresh cadence
- Hourly incremental, on-demand for close
What you can do with Business Central data in Go Fig
Multi-entity consolidation
Consolidate GL entries across BC companies with intercompany eliminations, using the native dimension codes as the segmentation backbone. One number for the board, entity drilldowns for the controller.
Dimension-driven P&L segmentation
Slice revenue, COGS, and OpEx by any combination of the eight BC dimensions (department, project, customer group, etc.) without rebuilding account schedules or creating new GL accounts.
Working-capital and inventory analytics
Join item ledger entries to sales and purchase history to track inventory aging, turn, and excess-and-obsolete exposure. Surfaces the working-capital levers that BC's standard reports leave inside separate item, customer, and vendor lists.
Data available from Business Central
Go Fig extracts and normalizes the following data from your Business Central account:
How to connect Business Central
Register the Go Fig app in Entra ID
In your Microsoft tenant, register an application for Go Fig and grant it the Financials.ReadWrite.All application permission (or narrower if your security team prefers). Record the tenant ID, client ID, and client secret, these are the only credentials Go Fig needs. On-premise customers generate a Web Service Access Key on a dedicated BC user instead.
Expose the environments and companies
Paste tenant ID, environment name (production, sandbox), and client credentials into Go Fig. The connector enumerates every company in the environment and asks which to sync. Most multi-entity customers sync all companies so consolidation stays consistent as the org adds entities.
Map dimensions and account schedules
Business Central's dimensions are the real segmentation story. Go Fig pulls all active dimensions and their values, and Celeste pre-suggests a mapping into standard finance cuts (department, cost center, product line, customer segment). Existing account schedules are imported so your management P&L layout is preserved.
Join to subledgers and external systems
Sales and purchase invoices are automatically joined to customer and vendor masters, and to item ledger entries where they exist. If you run HubSpot, Salesforce, or a separate payroll system, Go Fig links them to the BC customer, vendor, and employee records so pipeline-to-revenue and headcount-to-GL analyses land cleanly.
Authentication: OAuth 2.0 via Microsoft Entra ID (formerly Azure AD) with application permissions scoped to Business Central's Financials.ReadWrite.All or narrower delegated scopes. Go Fig registers an app in your tenant, you grant admin consent once, and the connector uses client-credentials flow against the tenant-specific BC endpoint. On-premise BC deployments authenticate via Web Service Access Key against the SOAP or OData endpoints.
Common Questions About Business Central Integration
Does Go Fig support both BC SaaS and on-premise?
Yes. Business Central Online uses Entra ID OAuth against the v2.0 API, which is the default path. On-premise and hybrid deployments use a Web Service Access Key against the OData or SOAP endpoints exposed on your BC service tier. The downstream data model is identical so flows and dashboards are portable across deployment types.
How does Go Fig handle BC dimensions?
All eight global and shortcut dimensions are synced as first-class columns on every ledger entry, sales line, and purchase line. Go Fig preserves dimension set IDs so combinations are intact for drilldowns, and Celeste can reason over them directly (e.g., 'Q3 gross margin by department and project for the manufacturing company'). You do not need to rebuild an account schedule every time finance wants a new cut.
Can Business Central data be combined with a separate accounting system during a migration?
Yes, and this is a common pattern for companies cutting over from QuickBooks, Sage Intacct, or NetSuite. Go Fig maintains a consistent chart-of-accounts mapping across both systems, tags each period with the system of record, and produces a continuous P&L and balance sheet through the migration. Finance keeps reporting stability even while BC cut-over happens one entity at a time.
What about BC extensions and custom tables?
Custom tables and extension fields exposed through published API pages are fully supported. Go Fig introspects the metadata endpoint, surfaces the available custom entities, and you pick which to sync. Extensions that only expose data through SOAP are also accessible through the OData bridge.
How current is BC data inside Go Fig?
Hourly incremental sync by default, anchored on the systemModifiedAt field that BC exposes on most entities. For close-week, an on-demand sync refreshes GL entries, sales invoices, and item ledger entries before the controller's close pack runs. Full reindex runs nightly to catch backdated postings.
Industries running Business Central with Go Fig
Strategic CFOs in these industries typically stitch Business Central into their Financial Intelligence Graph alongside their ERP and operational systems.
Ready to connect Business Central?
See how your Business Central data looks in Go Fig with a personalized demo.
Book a Demo