Integration

Aptean Made2Manage and MDC

Aptean Made2Manage to MDC. 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
  • No Phase 2 for this pair
How Aptean Made2Manage and MDC are connectedCommercient Sync Agent reads Aptean Made2Manage into the Data Lake and CRMPro pushes from the Data Lake into MDC. No write-back from MDC to Aptean Made2Manage ships for this pair.ApteanMade2ManageData LakeCommercientMDCyour CRMSync AgentCRMProPhase 1 · forward syncPhase 2 · no write-back shipped for this pair

In plain wordsRecords from Aptean Made2Manage are pushed into MDC. There is no shipped write-back in the other direction for this pair.

Phase 1 — Aptean Made2Manage to MDC

What you getRecords from Aptean Made2Manage become unit of measure schedule, uom, price level, products, sales order, sales order detail, invoice, invoice detail, Commercient Aptean salesperson object, accounts, Commercient Aptean customer object, contacts, Commercient Aptean contact object, Commercient Aptean address object, Commercient Aptean sales order header object, Commercient Aptean sales order detail object, Commercient Aptean invoice header object, Commercient Aptean invoice detail object in MDC. New records are created and existing ones updated.

GroupBusiness outcomeObjectsSource tables and views
CRM Unit of measure scheduleThe templates push unit of measure schedule to MDC.unit of measure schedule—
CRM unit of measureThe templates push uom to MDC.uom—
CRM Price levelThe templates push price level to MDC.price levelinventory master items
CRM ProductThe templates push product to MDC.productinventory master extensions
CRM sales orderThe templates push sales order to MDC.sales ordersales order items, e, inventory master items, sales order headers, customer extensions
CRM sales order detailThe templates push sales order detail to MDC.sales order detailsales order items, sales order headers, customer extensions, inventory master items
CRM invoiceThe templates push invoice to MDC.invoiceAR invoice lines, e, inventory master items, AR invoice headers, customer extensions
CRM invoice detailThe templates push invoice detail to MDC.invoice detailAR invoice lines, AR invoice headers, customer extensions, inventory master items
Aptean Sales PersonThe templates push Commercient Aptean salesperson object to MDC.Commercient Aptean salesperson objectsalespeople
CRM accountThe templates push account to MDC.accountcustomer extensions, salespeople
Aptean customerThe templates push Commercient Aptean customer object to MDC.Commercient Aptean customer objectcustomer extensions
CRM ContactThe templates push contact to MDC.contactcustomer extensions, phone numbers
Aptean ContactThe templates push Commercient Aptean contact object to MDC.Commercient Aptean contact objectcustomer extensions, phone numbers
Aptean AddressThe templates push Commercient Aptean address object to MDC.Commercient Aptean address objectaddresses, customer extensions
Aptean Sales order HeaderThe templates push Commercient Aptean sales order header object to MDC.Commercient Aptean sales order header objectsales order headers, phone numbers, customer extensions
Aptean Sales order DetailThe templates push Commercient Aptean sales order detail object to MDC.Commercient Aptean sales order detail objectsales order items, sales order headers, inventory master items
Aptean Invoice HeaderThe templates push Commercient Aptean invoice header object to MDC.Commercient Aptean invoice header objectAR invoice headers, customer extensions
Aptean Invoice DetailThe templates push Commercient Aptean invoice detail object to MDC.Commercient Aptean invoice detail objectAR invoice lines, AR invoice headers, inventory master items

Destination objects

  • unit of measure schedule
  • uom
  • price level
  • product
  • sales order
  • sales order detail
  • invoice
  • invoice detail
  • Commercient Aptean salesperson object
  • account
  • Commercient Aptean customer object
  • contact
  • Commercient Aptean contact object
  • Commercient Aptean address object
  • Commercient Aptean sales order header object
  • Commercient Aptean sales order detail object
  • Commercient Aptean invoice header object
  • Commercient Aptean invoice detail object

Phase 2 — MDC back to Aptean Made2Manage

Setting up Aptean Made2Manage and MDC 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 Aptean Made2Manage'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 MDC and declare Aptean Made2Manage

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

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.

Aptean Made2Manage and MDC: common questions

Which way does data move between Aptean Made2Manage and MDC?

One way. Phase 1 (CRMPro) pushes Aptean Made2Manage records into MDC. The repository ships no TxDownloaderPro write-back for this pair, so there is no supported Phase 2 from MDC back to Aptean Made2Manage.

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 MDC actually create?

The shipped catalogue carries 18 template groups for this pair: CRM Unit of measure schedule, CRM unit of measure, CRM Price level, CRM Product, CRM sales order, CRM sales order detail, CRM invoice, CRM invoice detail and 10 more. Each group sets up its own sync process, and the integration page says what each one delivers.

Which MDC objects does the forward sync write?

unit of measure schedule, uom, price level, product, sales order, sales order detail, invoice, invoice detail and 10 more. Those are the kinds of MDC record the shipped templates write for a Aptean Made2Manage 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.

Is there a write-back from MDC to Aptean Made2Manage?

No. The repository ships no TxDownloaderPro page for MDC into Aptean Made2Manage, so changes made in MDC are not carried back to Aptean Made2Manage by a supported process. Only the Phase 1 forward sync exists for this pair.

View moreShow less
Can an AI agent set this up?

Yes, over the admin control plane or the CLI — the same tools either way. The crmpro_* 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