Integration
SYSPRO 6 and Dynamics CRM
Dynamics CRM back to SYSPRO 6. Both directions are separate sync products, configured independently, and this page shows what the shipped catalogue sets up for this pair.
- No Phase 1 for this pair
- Phase 2 · write-back
In plain wordsChanges made in Dynamics CRM are carried back to SYSPRO 6. There is no shipped forward sync into Dynamics CRM for this pair.
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 SYSPRO 6 to Dynamics CRM integration on commercient.com .
Phase 1 — SYSPRO 6 to Dynamics CRM
Phase 2 — Dynamics CRM back to SYSPRO 6
What you getChanges made in Dynamics CRM to Order, Opportunity, Quote, accounts, Customer, Sales Invoice, Supplier, order, Purchase Order, products, Sales Order, contacts are carried back to SYSPRO 6.
| Process | What it delivers | Source → destination | Templates | Operations |
|---|---|---|---|---|
| Create New Sales Order | Dynamic Order to Syspro Sales Order | Order, Opportunity, Quote → Order | 3 | create |
| Create New Customer | Dynamic CRM Account to Syspro Customer | Account → Customer | 1 | create |
| Create New Quote | Dynamic Quote to Syspro Quote | Quote → Quote | 1 | create |
| Create New Sales Invoice | Dynamic Order to Syspro Sales Invoice | Order → Sales Invoice | 1 | create |
| Create New Supplier | Dynamic CRM Account to Syspro Supplier | account → Supplier | 1 | create |
| Create or Update Purchase Order | Dynamic CRM Order to Syspro Purchase Order | order → Purchase Order | 1 | create |
| Delete Customer | Dynamic Account to Syspro Delete Customer | Account → Customer | 1 | delete |
| Delete Product | Dynamic CRM Product to Syspro Delete Product | product → Product | 1 | delete |
| Delete Purchase Order | Dynamic CRM Order to Syspro Delete Purchase Order | order → Purchase Order | 1 | delete |
| Delete Quote | Dynamic Quote to Syspro Delete Quote | Quote → Quote | 1 | delete |
| Delete Sales Order | Dynamic Order to Syspro Delete Sales Order | Order → Sales Order | 1 | delete |
| Delete Supplier | Dynamic CRM Account to Syspro Delete Supplier | account → Supplier | 1 | delete |
| (unnamed) | Dynamic Contact to Syspro Contact | Contact → Contact | 1 | create |
| (unnamed) | Dynamic Update Account to Syspro Update Customer | Account → Customer | 1 | update |
| (unnamed) | — | Order → Sales Order | 1 | update |
| Update Product | Dynamic CRM Product to Syspro Update Product | product → Product | 1 | update |
| Update Supplier | Dynamic CRM Update Account to Syspro Update Supplier | account → Supplier | 1 | update |
Objects moved
- Order
- Opportunity
- Quote
- Account
- Customer
- Sales Invoice
- account
- Supplier
- order
- Purchase Order
- product
- Product
- Sales Order
- Contact
Setting up SYSPRO 6 and Dynamics 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 SYSPRO 6'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 Dynamics CRM and declare SYSPRO 6
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 Dynamics CRM
# a credentials CRM takes the fields the catalog lists for it
$ dlake admin registration_crm_connect --crmName Dynamics CRM --fields @fields.json
$ 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 <SYSPRO 6 code> --fields @fields.json
$ dlake admin registration_connector_provision
$ dlake admin registration_provisioning_status
The wizard in full, including resuming a setup days later: Setting up an integration with dlake · Registering a new Data Lake.
0Source 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.
SYSPRO 6 and Dynamics CRM: common questions
Which way does data move between SYSPRO 6 and Dynamics CRM?
One way. Phase 2 (TxDownloaderPro) carries changes made in Dynamics CRM back to SYSPRO 6. The repository ships no CRMPro forward sync for this pair, so there is no supported Phase 1 from SYSPRO 6 into Dynamics CRM.
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.
Can I push SYSPRO 6 records into Dynamics CRM?
Not with a shipped forward sync. The repository carries no CRMPro page for SYSPRO 6 into Dynamics CRM, only the TxDownloaderPro write-back in the other direction. Treat any forward sync for this pair as unsupported unless the catalogue gains one.
What does the write-back from Dynamics CRM create in SYSPRO 6?
The default set ships 17 processes for this pair: Create New Sales Order, Create New Customer, Create New Quote, Create New Sales Invoice, Create New Supplier, Create or Update Purchase Order, Delete Customer, Delete Product and 9 more. Each one takes a saved query against Dynamics CRM, an inbound mapping document, and writes the result into SYSPRO 6.
Which objects does the write-back move?
Order, Opportunity, Quote, Account, Customer, Sales Invoice, account, Supplier and 6 more. Those are the kinds of Dynamics CRM record the shipped processes carry back to SYSPRO 6.
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.
Can an AI agent set this up?
Yes, over the admin control plane or the CLI — the same tools either way. The 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 write-back 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 · Dynamics CRM integrations on commercient.com
