Use these data-model references to describe the records your connection needs. They are planning examples; connector availability and supported operations must be established before implementation.
Download the mapping worksheet · CSV, no email required
Record matching
Accounts / Accounts
Compare whether Microsoft Dynamics 365 Accounts and Microsoft Dynamics 365 Sales Accounts describe the same company in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Microsoft Dynamics 365
- Object support to establish
- Microsoft Dynamics 365 Sales
- Object support to establish
- Record identity
- Retain the source company ID and the destination customer/company ID. Separate legal entities, subsidiaries, and business units; a shared name or web domain is insufficient.
- Field ownership
- Assign ownership separately for relationship details and finance-controlled billing details.
Fields to include
- Source record ID
- Legal or display name
- Business-unit reference
- Lifecycle status
- Record dependencies
- Resolve parent organizations, business units, and currency references before dependent transactions.
- Validation
- Use two organizations with similar names and one with multiple business units. Verify that an update reaches the intended entity only.
- Recovery
- Repair the cross-system ID relationship before retrying dependent records; do not merge companies solely to remove a sync error.
References: Microsoft Dynamics 365: Accounts documentation
Record matching
Contacts / Contacts
Compare whether Microsoft Dynamics 365 Contacts and Microsoft Dynamics 365 Sales Contacts describe the same contact in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Microsoft Dynamics 365
- Object support to establish
- Microsoft Dynamics 365 Sales
- Object support to establish
- Record identity
- Use a stable person/contact ID and an explicit cross-system lookup. Email can change and can be shared, so treat it as a matching clue rather than a universal key.
- Field ownership
- Keep consent and communication preferences under an agreed authority; a general contact update must not silently resubscribe someone.
Fields to include
- Source person ID
- Display name
- Email address
- Organization reference
- Consent state
- Record dependencies
- Resolve the organization relationship and any owner or consent references required by the destination.
- Validation
- Test an email change, two records sharing an email, and a person associated with multiple organizations.
- Recovery
- Hold ambiguous matches for review and reconcile the person ID before retrying; preserve the consent decision already recorded by its owner.
References: Microsoft Dynamics 365: Contacts documentation
Business process
Opportunities / Orders
Approved sales handoff: Microsoft Dynamics 365 Opportunities provides context for Microsoft Dynamics 365 Sales Orders. These are related records, not equivalent entities.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Microsoft Dynamics 365
- Object support to establish
- Microsoft Dynamics 365 Sales
- Object support to establish
- Record identity
- Link the originating deal ID to a newly assigned order ID; do not reuse the deal ID as an order number.
- Field ownership
- Define the approval event and the customer/product data required to create an order. A sales stage alone must not authorize every order.
Fields to include
- Source record reference
- Destination record reference
- Approved handoff state
- Duplicate-detection key
- Record dependencies
- Map the customer and sales pipeline before the opportunity; map stage values deliberately.
- Validation
- Repeat the approved handoff and verify that it locates the existing order; test a reopened deal without silently cancelling fulfillment.
- Recovery
- Suspend downstream creation for a rejected deal and review whether an order already exists before retrying.
References: Microsoft Dynamics 365: Opportunities documentation
Record matching
Opportunities / Opportunities
Compare whether Microsoft Dynamics 365 Opportunities and Microsoft Dynamics 365 Sales Opportunities describe the same deal or opportunity in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Microsoft Dynamics 365
- Object support to establish
- Microsoft Dynamics 365 Sales
- Object support to establish
- Record identity
- Keep the opportunity/deal ID separate from any later order or invoice ID.
- Field ownership
- The sales process owns qualification and stage changes; downstream financial records have their own state and approval rules.
Fields to include
- Source deal ID
- Stage
- Amount and currency
- Expected close date
- Company reference
- Record dependencies
- Map the customer and sales pipeline before the opportunity; map stage values deliberately.
- Validation
- Test a reopened won deal, a stage with no destination equivalent, and an amount using a different currency.
- Recovery
- Suspend downstream creation for a rejected deal and review whether an order already exists before retrying.
References: Microsoft Dynamics 365: Opportunities documentation
Record matching
Leads / Leads
Compare whether Microsoft Dynamics 365 Leads and Microsoft Dynamics 365 Sales Leads describe the same prospect or lead in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Microsoft Dynamics 365
- Object support to establish
- Microsoft Dynamics 365 Sales
- Object support to establish
- Record identity
- Retain the lead ID and record its relationship to any converted contact or company.
- Field ownership
- Choose which system may qualify or convert the lead; do not infer identical lifecycle stages.
Fields to include
- Source lead ID
- Qualification status
- Owner reference
- Conversion reference
- Record dependencies
- Resolve owner and campaign references and decide how conversion changes the identity relationship.
- Validation
- Convert a test lead after the first load and verify that it does not create a duplicate person or orphan its activity.
- Recovery
- Repair the lead-to-contact conversion link before replaying later updates.
References: Microsoft Dynamics 365: Leads documentation
Business process
Quotes, Orders & Invoices / Orders
Order-to-invoice handoff: Microsoft Dynamics 365 Sales Orders provides context for Microsoft Dynamics 365 Quotes, Orders & Invoices. These are related records, not equivalent entities.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Microsoft Dynamics 365
- Object support to establish
- Microsoft Dynamics 365 Sales
- Object support to establish
- Record identity
- Link order and line IDs to invoice and line IDs; allow partial invoicing and multiple invoices per order.
- Field ownership
- Finance owns invoice posting; the order system supplies the approved commercial context.
Fields to include
- Source record reference
- Destination record reference
- Approved handoff state
- Duplicate-detection key
- Record dependencies
- Create or locate the customer and products first; resolve taxes, currency, and fulfillment references.
- Validation
- Test a partially invoiced order, tax rounding, and a repeated handoff without generating another invoice.
- Recovery
- Check for an existing destination order before retrying a timed-out create; reconcile line IDs to avoid duplicate fulfillment.
References: Microsoft Dynamics 365: Quotes, Orders & Invoices documentation