Keep each record tied to its source ID. Use the references below to choose field owners and preserve relationships between records.
Download the mapping worksheet · CSV, no email required
Customer identity
Accounts / Customer
Before linking Microsoft Dynamics 365 Accounts to NetSuite Customer, check whether the customer is an individual or a company. Match the correct record type in each system.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Microsoft Dynamics 365
- Object support to establish
- NetSuite
- Documented record · Read: ✅ Supported. Write: ✅ Supported.
- Record identity
- Determine whether each customer represents an individual, a company, or a business-unit relationship before matching it to a contact or organization. Retain the source customer ID and destination ID; names and email alone are insufficient.
- Field ownership
- Separate the customer relationship from contact details, billing authority, and consent. Choose an owner for each field after identifying whether the customer is a person or company.
Fields to include
- Source customer ID
- Person/company classification
- Legal entity or business unit
- Destination identity reference
- Record dependencies
- Resolve person or company type, legal entity, business role, and any billing account before transactions.
- Validation
- Test an individual buyer, a company buyer, and one company with multiple billing relationships. Do not merge these into a single generic contact.
- Recovery
- Hold ambiguous customer matches for review and resolve customer type before retrying dependent records.
References: Microsoft Dynamics 365: Accounts documentationNetSuite: Customer documentation
Customer identity
Contacts / Customer
Before linking Microsoft Dynamics 365 Contacts to NetSuite Customer, check whether the customer is an individual or a company. Match the correct record type in each system.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Microsoft Dynamics 365
- Object support to establish
- NetSuite
- Documented record · Read: ✅ Supported. Write: ✅ Supported.
- Record identity
- Determine whether each customer represents an individual, a company, or a business-unit relationship before matching it to a contact or organization. Retain the source customer ID and destination ID; names and email alone are insufficient.
- Field ownership
- Separate the customer relationship from contact details, billing authority, and consent. Choose an owner for each field after identifying whether the customer is a person or company.
Fields to include
- Source customer ID
- Person/company classification
- Legal entity or business unit
- Destination identity reference
- Record dependencies
- Resolve person or company type, legal entity, business role, and any billing account before transactions.
- Validation
- Test an individual buyer, a company buyer, and one company with multiple billing relationships. Do not merge these into a single generic contact.
- Recovery
- Hold ambiguous customer matches for review and resolve customer type before retrying dependent records.
References: Microsoft Dynamics 365: Contacts documentationNetSuite: Customer documentation
Record matching
Contacts / Contact
Compare whether Microsoft Dynamics 365 Contacts and NetSuite Contact describe the same contact in your business.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Microsoft Dynamics 365
- Object support to establish
- NetSuite
- Documented record · Read: ✅ Supported. Write: ✅ Supported.
- 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 documentationNetSuite: Contact documentation
Record matching
Quotes, Orders & Invoices / Invoice
Compare whether Microsoft Dynamics 365 Quotes, Orders & Invoices and NetSuite Invoice describe the same customer invoice in your business.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Microsoft Dynamics 365
- Object support to establish
- NetSuite
- Documented record · ✅ Supported
- Record identity
- Retain the invoice ID, issuer/legal entity, and original order reference; invoice numbers alone may overlap.
- Field ownership
- The financial system owns posting and accounting treatment. A posted invoice may need a credit or adjustment process instead of an overwrite.
Fields to include
- Source invoice ID
- Customer or supplier reference
- Line totals
- Currency
- Posting/payment status
- Record dependencies
- Resolve the customer or supplier, account codes, tax, currency, and accounting period before posting.
- Validation
- Test a posted invoice, a partial payment, tax rounding, and a closed accounting period. Compare financial totals within the same entity and currency.
- Recovery
- Determine whether a transaction posted before retrying. Follow the approved adjustment process for posted records.
References: Microsoft Dynamics 365: Quotes, Orders & Invoices documentationNetSuite: Invoice documentation
Business process
Opportunities / Sales Order
Approved sales handoff: Microsoft Dynamics 365 Opportunities provides context for NetSuite Sales Order. These are related records, not equivalent entities.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Microsoft Dynamics 365
- Object support to establish
- NetSuite
- Documented record · ✅ Supported
- 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 documentationNetSuite: Sales Order documentation
Business process
Quotes, Orders & Invoices / Sales Order
Order-to-invoice handoff: NetSuite Sales Order provides context for Microsoft Dynamics 365 Quotes, Orders & Invoices. These are related records, not equivalent entities.
Object-specific availability and field permissions determine this mapping. Use the restrictions shown for each record type.
- Microsoft Dynamics 365
- Object support to establish
- NetSuite
- Documented record · ✅ Supported
- 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 documentationNetSuite: Sales Order documentation