CRMJettyBack to crmjetty.com
Menu

Business Central

Introduction

Hosting and deployment

Account and billing

Connect your CRM

Payments

Widgets

Admin and dashboards

Portal users

Email and notifications

Forms

Lists

Pages

Roles and permissions

Branding and navigation

Workflows

Support and knowledge base

Languages

Login and security

CRM connection and sync

More

Docs / Business Central

Business Central Portal

Guides / CRM connection and sync

How to Configure Business Central Table Sync

4 min readUpdated
Short answerAfter you connect Business Central, run a sync from Settings → Portal Settings → Portal Sync, then go to Settings → User Settings → Table Configurations, drag the tables you need from BC Tables into Portal Tables and select Save. When you change tables or fields in Business Central, sync again.

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

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).

  1. Sign in to the admin portal.
  2. Go to Settings → User Settings → Table Configurations.
  3. In BC Tables, find the table. Search by name or scroll the list.
  4. Drag the table into the Portal Tables section.
  5. Repeat for each table the portal needs.
  6. 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:

  1. Give portal user roles access to the table under Table Permissions. See How to Set Up Customers in Business Central Portal.
  2. Create forms and lists for the table.
  3. 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.

  1. Go to Settings → Portal Settings → Portal Sync.
  2. 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.
  3. 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

  1. Go to Settings → User Settings → Table Configurations.
  2. Drag the table from Portal Tables back to BC Tables.
  3. 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.

Did this solve it?No, contact support