BC Observatoryunofficial, made by waldo
topic hubofficial - Microsoftreviewed - checked by Opus

Integrate with other applications

Integration of Business Central with other applications: Microsoft Office and 365, Power Platform, Dataverse, Dynamics 365 Sales, Field Service and Shopify. It answers questions about which integration to use, how data is synchronized, and where to find setup details.

Open in Claudeintegrate-with-other-applications.md

Path: Integrate with other applications · tier official · system none · narrative reviewed (checked by Opus)

Overview

This section covers how Business Central connects to other products. An integration overview page lists the main options: Office apps, Power Platform, Dataverse synchronization, virtual tables, webhooks, Dynamics 365 Sales, Field Service and Shopify. Start there to pick the right path.

Three pages sit directly in the section: the integration overview, Integrating with Dynamics 365 Sales (through Dataverse), and the Shopify Connector Overview. Subtopics go deeper on Microsoft Office apps and Microsoft 365, Microsoft Power Platform, Microsoft Dataverse, and Dynamics 365 Field Service.

The Sales integration runs through Dataverse. The Dataverse subtopic covers connecting, user accounts, ownership models, table and field mappings, synchronization and sync error troubleshooting for syncing with other Dynamics 365 apps, so it is useful context alongside the Sales page. For Field Service, use its own subtopic, which covers the Project-only and Project and Service integration types.

Key points

  • The integration overview names Office, Power Platform, Dataverse, Dynamics 365 Sales, Field Service and Shopify as integration targets, plus virtual tables and webhooks.
  • Dynamics 365 Sales integration runs through Dataverse: connection settings, security roles, unit group mapping, table synchronization and record coupling are configured. It supports sales order processing and item availability.
  • Shopify Connector synchronizes items, inventory, customers, orders and transactions in both directions, supports multiple shops, and fits B2B and DTC models.
  • Shopify order import from sales channels and fulfillment tracking are covered.
  • Office and Microsoft 365 subtopic (24 pages) covers Excel, OneDrive, Outlook, Teams and Word.
  • Power Platform subtopic (15 pages) covers the Business Central connector, Power Apps, Power Automate, Power BI and Power Pages on Dataverse virtual tables.
  • Dataverse subtopic (11 pages) covers user accounts, ownership models, table and field mappings, manual and scheduled sync, flows and sync error troubleshooting.
  • Field Service subtopic (2 pages) covers work orders, consumption posting, inventory availability, resource bookings and invoices, with Project-only and Project and Service integration types.

Subtopics

More Learn pages

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.

What Learn documents here 8 of 55 Learn pages

Show 32 more