Integration

Microsoft Dynamics AX and Zoho CRM

Microsoft Dynamics AX to Zoho CRM, and changes in Zoho CRM back to Microsoft Dynamics AX. Both directions are separate sync products, configured independently, and this page shows what the shipped catalogue sets up for this pair.

  • Phase 1 · forward sync
  • Phase 2 · write-back
How Microsoft Dynamics AX and Zoho CRM are connectedCommercient Sync Agent reads Microsoft Dynamics AX into the Data Lake. CRMPro pushes from the Data Lake into Zoho CRM. TxDownloaderPro carries changes made in Zoho CRM back through the Data Lake to Microsoft Dynamics AX.MicrosoftDynamics AXData LakeCommercientZoho CRMyour CRMSync AgentCRMProPhase 1 · forward syncPhase 2 · TxDownloaderPro write-back

In plain wordsRecords from Microsoft Dynamics AX are pushed into Zoho CRM, and changes made in Zoho CRM are carried back to Microsoft Dynamics AX. Each direction is its own sync with its own configuration.

This page documents what the shipped catalogue sets up. For the commercial overview of the same pair — editions, licensing and how to buy it — Commercient publishes Microsoft Dynamics AX to Zoho CRM integration on commercient.com .

Phase 1 — Microsoft Dynamics AX to Zoho CRM

What you getRecords from Microsoft Dynamics AX become Commercient Dynamics AX Payment Terms object, Accounts, Commercient Dynamics AX Customer object, products, Commercient Dynamics AX Item object, Commercient Dynamics AX Shipping Address object, contacts, Commercient Dynamics AX Warehouse object, Commercient Dynamics AX Sales Quotation Header object, Commercient Dynamics AX Sales Quotation Line object, Commercient Dynamics AX Sales Order Header object, Commercient Dynamics AX Sales Order Detail object, Commercient Dynamics AX Invoice Header object, Commercient Dynamics AX Invoice Detail object, Dynamics AX Customer Purchase History (custom object), Zoho product price book relation, Dynamics AX Outbound Shipping (custom object), Commercient Dynamics AX Salesperson object in Zoho CRM. New records are created and existing ones updated.

GroupBusiness outcomeObjectsSource tables and views
Microsoft Dynamics AX Payment termThe templates push Commercient Dynamics AX Payment Terms object to Zoho CRM.Commercient Dynamics AX Payment Terms objectpayment terms
AccountsThe templates push Accounts to Zoho CRM.Accountscustomers, extended customer details, address book parties, shipping address feed, sales advisor targets (custom table), customer aging
Microsoft Dynamics AX CustomerThe templates push Commercient Dynamics AX Customer object to Zoho CRM.Commercient Dynamics AX Customer objectcustomers, address book parties
ProductsThe templates push Products to Zoho CRM.Productsitems, ordered status (custom table), product translations, item tracking dimension groups, tracking dimension groups, item module settings
Microsoft Dynamics AX ItemThe templates push Commercient Dynamics AX Item object to Zoho CRM.Commercient Dynamics AX Item objectitems, ordered status (custom table)
Microsoft Dynamics AX Shipping AddressThe templates push Commercient Dynamics AX Shipping Address object to Zoho CRM.Commercient Dynamics AX Shipping Address objectcustomers, address book parties, party locations, postal addresses, countries and regions, states
ContactsThe templates push Contacts to Zoho CRM.Contactscontact persons, customers, address book parties, person names, party locations, postal addresses
Microsoft Dynamics AX WarehouseThe templates push Commercient Dynamics AX Warehouse object to Zoho CRM.Commercient Dynamics AX Warehouse objectwarehouses
Microsoft Dynamics AX Sales Quotation HeaderThe templates push Commercient Dynamics AX Sales Quotation Header object to Zoho CRM.Commercient Dynamics AX Sales Quotation Header objectsales quotations
Microsoft Dynamics AX Sales Quotation LineThe templates push Commercient Dynamics AX Sales Quotation Line object to Zoho CRM.Commercient Dynamics AX Sales Quotation Line objectsales quotation lines
Microsoft Dynamics AX Sales Order HeaderThe templates push Commercient Dynamics AX Sales Order Header object to Zoho CRM.Commercient Dynamics AX Sales Order Header objectsales orders
Microsoft Dynamics AX Sales Order DetailThe templates push Commercient Dynamics AX Sales Order Detail object to Zoho CRM.Commercient Dynamics AX Sales Order Detail objectsales order lines
Microsoft Dynamics AX Invoice HeaderThe templates push Commercient Dynamics AX Invoice Header object to Zoho CRM.Commercient Dynamics AX Invoice Header objectcustomer invoice headers
Microsoft Dynamics AX Invoice DetailThe templates push Commercient Dynamics AX Invoice Detail object to Zoho CRM.Commercient Dynamics AX Invoice Detail objectcustomer invoice lines
Dynamics AX Customer Purchase HistoryThe templates push Dynamics AX Customer Purchase History (custom object) to Zoho CRM.Dynamics AX Customer Purchase History (custom object)customer purchase history (custom table), customers
Product Price booksThe templates push Zoho product price book relation to Zoho CRM.Zoho product price book relationitems, ordered status (custom table), price and discount agreements
Dynamics AX Dispatch ShippingThe templates push Dynamics AX Outbound Shipping (custom object) to Zoho CRM.Dynamics AX Outbound Shipping (custom object)packing slip lines, associated shipping guide lines (custom table), shipping guides (custom table), sales orders, postal addresses, states
Dynamics AX Contact personThe templates push Commercient Dynamics AX Salesperson object to Zoho CRM.Commercient Dynamics AX Salesperson objectcontact persons, customers, address book parties, party locations, postal addresses, countries and regions

Destination objects

  • Commercient Dynamics AX Payment Terms object
  • Accounts
  • Commercient Dynamics AX Customer object
  • Products
  • Commercient Dynamics AX Item object
  • Commercient Dynamics AX Shipping Address object
  • Contacts
  • Commercient Dynamics AX Warehouse object
  • Commercient Dynamics AX Sales Quotation Header object
  • Commercient Dynamics AX Sales Quotation Line object
  • Commercient Dynamics AX Sales Order Header object
  • Commercient Dynamics AX Sales Order Detail object
  • Commercient Dynamics AX Invoice Header object
  • Commercient Dynamics AX Invoice Detail object
  • Dynamics AX Customer Purchase History (custom object)
  • Zoho product price book relation
  • Dynamics AX Outbound Shipping (custom object)
  • Commercient Dynamics AX Salesperson object

Phase 2 — Zoho CRM back to Microsoft Dynamics AX

Setting up Microsoft Dynamics AX and Zoho CRM from the CLI

One wizard stands the tenant up, and it is the same five steps for every pair: register, capture the server IP, connect the CRM, declare the ERP connector, then import and enable the sync processes. What changes between pairs is the CRM’s connection mode and the ERP’s connector type.

1. Register the tenant

Registration creates the account, emails a verification link, and — once the Data Lake is seeded — prints a once-only bootstrap API key valid for seven days. The three consent flags are the registrant’s own decision, and the server refuses start without all three.

# which instance types sign-up accepts - run this first and use Microsoft Dynamics AX's code below
$ dlake register erps

# the three consent flags are the registrant’s decision - ask before passing them
$ dlake register start --generate-password \
$   --email <email> --company "<Company Name>" --phone <tel> \
$   --instance-type <code from dlake register erps> \
$   --consent-crm-backup --consent-erp-backup --consent-phone

# after the human clicks the verification link: watch for the seed and catch the key
$ dlake register status --watch

# the bootstrap key expires in 7 days - mint a durable one while it is still valid
$ dlake admin create_api_key --keyName "<tenant>-setup" --expirationDays 90

2. Connect Zoho CRM and declare Microsoft Dynamics AX

Steps 3 to 5 of the wizard are admin-plane tools, they are safe to re-run, and the server enforces their order — attempt the CRM step before the server IP is captured and it answers 409 naming the step you skipped.

# the authoritative answer to where a registration got to - first call when resuming
$ dlake admin registration_state

# step 3: record the server IP (a prerequisite for the CRM step)
$ dlake admin registration_capture_server_ip --ipAddress <ip>

# step 4: the catalog lists every CRM with its authMode and the fields it needs
$ dlake admin registration_crm_catalog
$ dlake admin registration_crm_select --crmName <Crm>
# an OAuth CRM: the catalog’s callbackMode says which leg this one takes
$ dlake registration oauth --crm <Crm>
$ dlake admin registration_crm_finalize

# step 5: the catalog lists the connector types and the fields each one needs
$ dlake admin registration_connector_catalog
$ dlake admin registration_connector_submit \
$   --connectorType <type from the catalog> --erpName <Microsoft Dynamics AX code> --fields @fields.json
$ dlake admin registration_connector_provision
$ dlake admin registration_provisioning_status

3. Review and enable the Phase 1 processes

The shipped templates listed above are what crmpro_apply_template imports. Every one of them imports its process inactive, so an imported process does nothing until an operator activates it — read the process and its field mapping first, because an object with no mapped fields pushes nothing and records no error.

# the default-template catalog, and the mapping each template carries
$ dlake admin crmpro_templates --profile <tenant>

# what exists on the tenant now, and the master sync flag
$ dlake admin crmpro_list_processes --profile <tenant>
$ dlake admin crmpro_sync_status --profile <tenant>

# read a process and its field mapping BEFORE activating it
$ dlake admin crmpro_get_process --profile <tenant> --recordId <id>
$ dlake admin crmpro_field_mapping --profile <tenant> --recordId <id>

# turn the forward sync on
$ dlake admin crmpro_set_sync_enabled --profile <tenant> --enabled true

Processes run in a fixed order, and that order is a dependency order: a process that depends on another’s records sees them only once that process has run, so a parent flows on one run and its children on the next. The full order for this pair is on the Phase 1 page.

The wizard in full, including resuming a setup days later: Setting up an integration with dlake · Registering a new Data Lake · CRMPro (forward sync).

0

Source on GitHub

This page is generated from the skill pages in the dlake CLI repository. Those pages are the authority; if they disagree with anything here, they are right.

Microsoft Dynamics AX and Zoho CRM: common questions

Which way does data move between Microsoft Dynamics AX and Zoho CRM?

Both ways, as two separate syncs. Phase 1 is CRMPro, the forward sync that pushes Microsoft Dynamics AX records into Zoho CRM. Phase 2 is TxDownloaderPro, the write-back that carries changes made in Zoho CRM back to Microsoft Dynamics AX. They are configured independently, and a tenant can run either on its own.

What do Phase 1 and Phase 2 mean?

They are the two sync products the on-premises agent can run. Phase 1 is CommercientCRMPro, product 11, the forward sync from the source system into the CRM. Phase 2 is CommercientTxDownloaderPro, product 22, the write-back in the other direction. Registering a product says what to run; the Phase 1 and Phase 2 configuration says what it runs on.

What does the forward sync into Zoho CRM actually create?

The shipped catalogue carries 18 template groups for this pair: Microsoft Dynamics AX Payment term, Accounts, Microsoft Dynamics AX Customer, Products, Microsoft Dynamics AX Item, Microsoft Dynamics AX Shipping Address, Contacts, Microsoft Dynamics AX Warehouse and 10 more. Each group sets up its own sync process, and the integration page says what each one delivers.

Which Zoho CRM objects does the forward sync write?

Commercient Dynamics AX Payment Terms object, Accounts, Commercient Dynamics AX Customer object, Products, Commercient Dynamics AX Item object, Commercient Dynamics AX Shipping Address object, Contacts, Commercient Dynamics AX Warehouse object and 10 more. Those are the kinds of Zoho CRM record the shipped templates write for a Microsoft Dynamics AX source; nothing else is written unless you add templates of your own.

Does the forward sync delete anything in the CRM?

Each template group carries its own insert, update and delete flags, and the integration page lists what each group does. Read a process with dlake admin crmpro_get_process before activating it.

What does "Phase 2 ready" mean?

It means the tenant has at least one TxDownloaderPro process. Creating a process with txdownloaderpro_create_process is what flips a customer to Phase 2 ready; registering the product alone does not, because registering says what to run and the configuration says what it runs on.

View moreShow less
How do I see the write-back processes and whether they are failing?

dlake admin txdownloaderpro_list_processes returns every Phase 2 process with its 30-day unresolved-error count, which is the same grid the portal shows. txdownloaderpro_get_process returns one process in its edit shape, including the query and both mapping documents.

How do I stop the two directions looping?

dlake admin txdownloaderpro_circular_sync_check takes a process id and names the CRM objects that also have an active Phase 1 configuration. Those are the objects where a write-back can be picked up again by the forward sync, so check it before activating a process on this pair.

Can an AI agent set this up?

Yes, over the admin control plane or the CLI — the same tools either way. The crmpro_* and txdownloaderpro_* tools cover listing, reading, creating and updating processes. They need a full-scope key that belongs to a user holding the Admin role, and every write is audited.

Where is the authoritative source for this pair?

The skill pages in the dlake CLI repository, which is where this page is generated from. The forward sync page is linked at the foot of the integration page, and the same text is readable in the terminal with dlake skills show.

Related

Every ERP and CRM integration · CRMPro (forward sync) · TxDownloaderPro (writeback sync) · AI agents & MCP · Zoho CRM integrations on commercient.com