A Dynamics 365 Sales–ERP integration specialist should define how commercial information moves between sales and back-office teams, not merely connect two applications. Start with record ownership, business events and the expected response when something fails. For Business Central, assess the documented standard integration before proposing custom development. For other ERP systems, establish the relevant supported approach separately. Include reconciliation, monitoring and operational ownership in the scope so the integration remains useful after its first successful transaction.
What to take from this guide
- Decide which system owns each business fact before mapping fields.
- Assess standard capabilities against real order and customer scenarios.
- Make retries, reconciliation and support ownership part of acceptance.

Define the handoff the business wants to improve
CRM and ERP integration requests often begin with duplicate entry. That is a useful symptom, but it does not fully describe the desired process. Ask what happens between an agreed sale and the order that operations can fulfil. Identify who checks the customer, product, price, terms and delivery expectations, and where those decisions currently become disconnected.
Use a recent hypothetical order to map the handoff. A seller may need inventory context before making a promise, while finance may need to review a new customer before processing the order. The integration should preserve those responsibilities. Ask a candidate to describe the business event that initiates each transfer and the evidence that it completed. This creates a stronger scope than a list saying synchronise customers, products and orders, because it explains when those records become meaningful and which team is accountable for them.
Assess standard Business Central integration first
Microsoft documents integration between the online versions of Business Central and Dynamics 365 Sales through Dataverse. The documented setup includes capabilities for connecting customer and product information and supporting sales-order processes. That is a starting point for assessment, not a promise that every custom sales process will work without further design.
Ask the specialist to compare your scenarios with the standard configuration and record any gaps. Existing customisations, data models and other connected applications can affect the assessment. Microsoft’s Business Central integration overview also positions the Sales connection within a wider integration landscape. Require the candidate to distinguish supported standard setup from proposed extensions. Dynamics 365 Sales integration specialists should explain the implications in business terms: what the seller sees, what the order processor receives and what remains a deliberate manual decision. Avoid custom code until the actual gap is understood.
Choose a source of truth for each important value
Two systems can store a customer name without both being authorised to change every customer fact. Decide which team owns addresses, commercial segmentation, payment terms, product details and prices. Record where a change starts, where it is visible and whether another person must approve it. Conflicting edits need a business rule before they need a technical resolution.
A hypothetical distributor might allow sellers to maintain prospect information while finance approves the record used for transactions. That distinction should appear in the mapping and the user guidance. Ask the specialist how existing duplicate records will be matched and what happens when a match is uncertain. Do not silently merge records merely because names look similar. A source-of-truth matrix helps functional owners approve the design and gives developers a clear basis for transformation, conflict handling and support investigations.
| Information | Ownership decision |
|---|---|
| Customer details | Who approves transaction-ready records? |
| Product and price | Which application governs changes? |
| Order status | Which event authorises progression? |
| Corrections | Who resolves conflicting updates? |
Map the commercial meaning, not just the field names
An order status in CRM may not mean the same thing as a status in ERP. Product units, discount treatment, currencies and customer references can also differ. The integration specialist should document how those meanings translate and which exceptions require business review. A field-to-field mapping alone can hide important differences.
Take one normal order and several difficult cases: a changed quantity, an unavailable product, a cancelled request and a customer with incomplete information. Walk through the expected outcome in both systems. Include what the seller should be told if back-office processing cannot continue. Business Central integration developers may be needed alongside Sales expertise when extensions are justified. Keep a shared design owner so each side does not implement a locally correct interpretation that produces an inconsistent commercial result when the systems exchange information.
Need this expertise in your team?
Start with the workstream, expected outcome and working hours.
Design failure handling before the first live transaction
An integration will eventually encounter unavailable systems, invalid data or an interrupted operation. The important question is how the business recognises and resolves that event. Ask the specialist to identify failures that can be retried safely, failures that require corrected data and failures that need a decision about a partially completed process.
Use a hypothetical order that reaches ERP but whose acknowledgement does not return to CRM. What prevents an uncontrolled retry from creating a duplicate? What does the support person see, and how do they establish the true state? The design should preserve enough information to investigate without requiring someone to inspect raw technical logs for every incident. Agree a clear exception owner and escalation route. Failure handling is part of the integration’s ordinary operation, not a secondary enhancement to add after the happy-path demonstration succeeds.
Make reconciliation visible to the business
A successful message transfer does not prove that the complete business process is correct. Reconciliation compares the expected business records and outcomes across the systems. Define what should agree, when it should agree and which differences are normal. Some information may update periodically rather than immediately, so users need an agreed expectation.
Ask for a small set of operational checks: records awaiting transfer, rejected changes, unresolved matches and orders with inconsistent status. Assign someone to review them and explain how an issue is closed. Test with a controlled sample whose expected results are known in advance. Include initial synchronisation separately from ongoing changes, because the scale and matching decisions can be different. The specialist’s handover should allow an authorised support person to determine whether the integration is healthy and when functional or technical assistance is needed.
Assess the specialist’s cross-application experience
During interviews, ask candidates to explain an integration they personally delivered, including a difficult failure and how it was resolved. Request an anonymised mapping, exception design or acceptance scenario. General API experience is valuable, but the person also needs to understand the relevant Sales and ERP business processes and the boundaries of their expertise.
Present a fictitious customer update that differs in both systems and ask what questions they would ask before choosing the winning value. Look for business ownership, traceability and a recovery plan. If the integration spans several applications or multiple companies, consider Customer Engagement solution architect support for design review. Verify any certification individually when it is part of the selection criteria. A badge does not demonstrate experience with your particular order lifecycle, customisations or existing integration landscape; evidence from comparable work is more useful.
Select an engagement model that reflects uncertainty
The Hourly Model suits an integration assessment, a mapping review or diagnosis of a specific synchronisation issue. Define the investigation question and an evidence-based output before the work starts. Project Based hiring is appropriate when systems, mappings, dependencies and acceptance scenarios are sufficiently clear to bound the delivery.
A Dedicated Resource can support a programme with several interfaces, continuing changes or a partner’s integration backlog. Provide a technical owner and business approvers so the specialist is not forced to guess priorities. For teams in the United States, Canada, Mexico and Europe working with India-based resources, agree overlap for joint troubleshooting and production decisions. Distinguish planned development from operational support coverage. The chosen model should state who monitors failures, who approves corrections and how responsibilities transfer after go-live, since those duties continue beyond the initial connection work.
Custom logic on the sales side may call for a Dynamics 365 Sales developer. Where the work spans wider customer engagement processes, compare the responsibilities of a Customer Engagement integration developer. Agree which person owns each interface and how errors are handed over between the CRM and ERP teams.
Prepare a brief that makes estimates comparable
State the Sales application, ERP product and versions, relevant deployment details, connected systems and business processes in scope. List the records to exchange, the proposed owners and the expected update timing. Explain existing customisations, approximate transaction patterns and the internal people available for testing. If those facts are unknown, request assessment before a delivery commitment.
Use a completion checklist covering approved mappings, representative tests, failure scenarios, reconciliation, access arrangements, deployment instructions and operational support ownership. Ask each supplier to identify exclusions and assumptions in the same format. This makes proposals easier to compare than judging only development hours. The integration should leave sellers and back-office teams able to explain where an order is and what needs to happen next. That visible business continuity is the strongest acceptance criterion for a connection intended to support the lead-to-cash process.
- Approved source-of-truth matrix
- Tested duplicate prevention
- Visible exception queue
- Named reconciliation owner
Before your next hiring conversation.
Can standard integration replace all custom development?+
It may cover much of the requirement, especially when your processes align with the documented Sales and Business Central capabilities. Assess actual scenarios before deciding. Custom fields, unusual approval rules or other connected systems can introduce gaps. Ask the specialist to document the standard fit and each justified extension rather than assuming either a fully standard or fully custom solution.
Who should own customer data after CRM and ERP are connected?+
Assign ownership by business fact and responsibility, not by choosing one application for everything. Sales may own prospect context while finance owns approved transaction details. Document who can change each value, how approval works and how conflicts are resolved. Both technical teams should implement the same agreed rules so synchronisation does not become a competition between systems.
What should an integration support handover include?+
Include the approved mappings, monitoring instructions, common failure types, retry rules, reconciliation checks and named escalation owners. Provide deployment and configuration records as well as access to relevant source code. The support team should be able to identify the true business state of a transaction before attempting a correction, especially when processing completed only partly across the systems.
Your next step
For a Sales–ERP integration enquiry, share the systems involved and describe one transaction from the seller’s decision to back-office completion. Include known exceptions, data owners and the support expectations after go-live. Sirius Dynamics can then discuss relevant integration profiles and the right engagement model. A useful connection is one the business can trust during ordinary processing and understand when an exception occurs, with clear ownership on both sides of the handoff.
Check the product detail.
Official references for the product and delivery considerations discussed here. The hiring recommendations and illustrative scenarios are Sirius Dynamics editorial guidance.
- Integrating with Dynamics 365 Sales ↗Supports the narrow description of online Sales–Business Central integration through Dataverse and standard setup assessment.
- Integration overview for Business Central ↗Supports the placement of the Sales connection within Business Central integration options.