What the Business Central sync sends
Which records Magic CRM and Business Central exchange, in which direction, and what waits for a person to decide.
The sync agent you install next to Business Central (online or on-premises) carries every exchange. One agent syncs one Business Central company. Nothing is ever deleted in Business Central by the sync.
In which direction
| Magic CRM | Business Central | From Business Central | To Business Central |
|---|---|---|---|
| Companies | Customers | name, phone, website, street, locality, county, postal code, country | the same, except the name; a new company becomes a customer only when you turn that on |
| People | Contacts | name, job title, email, phone, for a customer linked to a company | the same, for a person whose company is linked |
| Items | Items | read only | a SKU added to the price list is created as an item, once, when you turn that on |
| Previous orders | Sales orders and their lines | read only, shown on the company’s page | nothing |
| Sales figures | Item ledger entries, sales only | every sales line, when you turn the sales ledger on | nothing |
| Sales zones | One customer dimension | each customer’s value, when you choose a dimension | nothing |
| Salespeople | Salespeople | read only | nothing |
- A company’s name is Business Central’s. It is the legal name on an invoice, so a rename made in Magic CRM is not sent. The one exception is when someone answers a conflict about the name with Keep ours.
- Only these fields travel. Notes, industry, the owner, deals and everything else in Magic CRM stay in Magic CRM. A customer’s tax registration number and email in Business Central are not copied into Magic CRM.
- A record removed in Business Central is archived in Magic CRM, never deleted.
What you choose
Under Admin → ERP → Connection, an owner or admin decides:
- New companies become customers in the ERP. Off to begin with. Only companies made after the sync went live are offered.
- Customers the ERP has and we do not become companies here. On by default. A customer whose name matches a company of yours is never added: it waits for you instead.
- Sales ledger. Off to begin with. When on, Business Central’s sales lines feed the sales figures in Magic CRM, and importing a sales file is refused. It cannot be turned on over sales that came from somewhere else, such as an imported file.
- New price-list items. Off to begin with, and it needs the item defaults (type, posting groups, units) agreed with us first. Only SKUs added while it is on are sent, each once; later price or name changes are not.
- Sales zones. A customer dimension in Business Central whose values become the sales zones, or zones set up by hand.
- Salespeople. Each salesperson in Business Central is matched to the member with the same email address; you can choose someone else, or nobody.
- Pause and Resume: while paused, nothing is exchanged, and what changes meanwhile goes when you resume.
When it runs
- Changes made in Magic CRM are sent the next time the agent asks for work, within about a minute.
- Changes made in Business Central are read at a regular interval, every 15 minutes unless changed, shown on the Connection screen as Read what changed.
- Removed records are looked for once a day, under Check what is gone.
- Under Admin → ERP → Activity, Sync now reads changes at once, Check for removed records looks for removed ones, and Sync everything again reads every record from the start.
- If Business Central asks the sync to slow down, it waits as long as Business Central asks.
What waits for a person
The sync never decides alone where a mistake would be costly. These wait under Admin → ERP → Waiting for you, and also on the company’s or person’s own page:
- A customer that looks like one of your companies, because the names match. Answer Same company or Not the same. For the same company, choose whose details to use where both have one: Use ours or Use theirs. The name is Business Central’s either way.
- A record changed on both sides, to different values. Nothing of that record moves until someone chooses Keep ours or Keep theirs.
Nothing changes until you choose Apply.
Where to look
- Admin → ERP → Activity lists every run and every task. A task Business Central refused is Failed, with Business Central’s own message; one that could not get through after five attempts is Parked. Retry puts either back.
- On a company’s page: its number in Business Central, and its Previous orders.
- In a record’s history, a change the sync made is shown under the agent’s name.
The agent works with an account of its own in Magic CRM, which can change only what the sync needs: never a deal, a note or a quote, and it deletes nothing. See Security.