How to Configure Business Central Table Sync
The Customer Portal for Microsoft Dynamics 365 Business Central works with your Business Central data through the Business Central APIs. You choose which Business Central tables the portal can use. Only enabled tables can be used in the portal’s forms, lists and pages.
Before you start
- Connect Business Central first. See How to Connect Business Central to CRMJetty Portal.
- You need access to Settings in the admin portal.
- If you just added or changed a table or its fields in Business Central, finish those changes first.
How table sync works
Two kinds of data move between Business Central and the portal:
| What | Direction | How it syncs |
|---|---|---|
| Records, such as customers, orders and invoices | Business Central ↔ portal | As portal users and admins work; timing depends on Business Central’s API limits |
| Table structure: new tables and fields | Business Central → portal | Manual: run a sync on the Portal Sync page |
The portal reads and writes records through the Business Central APIs. Business Central stays the system of record. Sync is asynchronous; timing depends on its API limits. See CRM API Limits and Portal API Usage Explained.
Enable tables for the portal
Sync the portal with Business Central before you configure tables (see Sync table and field changes).
- Sign in to the admin portal.
- Go to Settings → User Settings → Table Configurations.
- In BC Tables, find the table. Search by name or scroll the list.
- Drag the table into the Portal Tables section.
- Repeat for each table the portal needs.
- Select Save.
Choose the tables that match what portal users do. A customer portal typically uses tables for customers, sales quotes, sales orders and invoices. A vendor portal typically uses tables for vendors, purchase orders and purchase invoices.
After you enable a table
An enabled table is not visible to portal users until you build on it:
- Give portal user roles access to the table under Table Permissions. See How to Set Up Customers in Business Central Portal.
- Create forms and lists for the table.
- Add them to a page and publish it. See How to Create Pages in CRMJetty Portal.
Sync table and field changes
When you add a table or add, change or delete fields in Business Central, sync the portal so it picks up the new structure.
- Go to Settings → Portal Settings → Portal Sync.
- Choose a sync option:
- Table Level Sync: syncs structure changes at table level. Select Business Central Sync.
- Portal-level Table Sync, Sync All Tables: syncs every portal table. Select it, then select Business Central Sync.
- Portal-level Table Sync, Sync Specific Tables: choose the table in Select Table to Sync, then select Business Central Sync.
- Wait for the success message on the right side of the page.
Note: The sync can take a few minutes. Don’t sign out of the admin portal or make changes in Business Central until it finishes.
Business Central has no Language Level Sync. For how the sync options work in CRM portals, see How to Sync CRM Layout Changes to Your Portal.
Remove a table from the portal
- Go to Settings → User Settings → Table Configurations.
- Drag the table from Portal Tables back to BC Tables.
- Select Save.
Important: When you remove a table, portal users can no longer see its data, and you can’t use it in forms, lists or pages. Primary tables the portal needs, such as currency and customer, can’t be removed.
Troubleshooting
A table is missing from the list: Run Table Level Sync on the Portal Sync page, then reopen Table Configurations. Check that the Entra ID app has the Business Central API permissions described in How to Connect Business Central to CRMJetty Portal.
A new field doesn’t appear in the form or list builder: Sync that table with Sync Specific Tables, then add the field to your form or list.
Related articles
- How to Connect Business Central to CRMJetty Portal
- Getting Started with Business Central Customer Portal
- How to Set Up Customers in Business Central Portal
- How to Set Up a Business Central Vendor Portal
- How to Sync CRM Layout Changes to Your Portal