RO
Last updated

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.