Skip to main content
Resources

Integration, data & APIs

CRM and ERP integration: agree the business handoff before synchronising records

Plan customer, order and operational data exchanges with clear ownership, matching rules, approval boundaries and reconciliation.

5 minute read · Veda Software ·

Contents

Connecting customer and operational systems requires agreement about what each record means and when it should move. Start with one business handoff, such as an approved order entering fulfilment, and define the accepted result. Avoid making every field synchronise in both directions simply because the systems can exchange it.

Choose the first workflow and its approval boundary

Describe the action that should trigger the exchange and who authorises it. A draft commercial record may not be ready for operational processing. Specify which checks must be complete and what the receiving team needs before it can act. Use the organisation's actual workflow rather than assuming familiar status names mean the same thing in both systems.

Define the visible result in each application. If the receiving system rejects a record, decide whether the originating record stays pending, returns for correction or requires another action. Make the responsible person and the next step clear so users do not resolve uncertainty by entering the same transaction again.

Assign ownership at field level

List the fields involved and identify where each can be changed. Customer contact information, billing details and delivery instructions may have different owners. Record how an authorised correction reaches the other application and what happens when an update conflicts with a more recent value.

Treat financial or operational state changes as explicit business actions. Ask the responsible teams which approvals and controls must remain in place. The integration specification should preserve those decisions rather than inferring permission from the fact that a technical account can write a field.

Resolve identity and duplicates before expanding the flow

Decide how records are matched and retain a stable reference between systems. Inspect representative existing data for duplicates, missing identifiers and different representations of the same organisation. Agree who can merge or correct records and how those changes affect linked transactions.

Start with a controlled sample and reconcile the results with the people who use them. Include an existing record, a new record and an ambiguous match. Keep ambiguous cases visible for review rather than silently selecting the closest-looking name or creating another duplicate.

Specify corrections, cancellation and repeated delivery

Describe the lifecycle after creation. An order may be corrected or cancelled, and customer details may change while work is in progress. Identify which changes should propagate automatically and which need a separate approval or operational decision. Include the treatment of historical records.

Plan for delayed responses and repeated messages. Verify how the receiving system can recognise an action already performed before retrying it. Test the recovery process with controlled records and check both applications afterwards; a successful HTTP response alone does not establish that the business state is correct.

Make reconciliation a normal operating responsibility

Define how the team detects records that are missing, pending too long or inconsistent across systems. Provide enough context for an authorised operator to investigate without exposing unnecessary personal or commercially sensitive data. Agree who owns each exception and when it should be escalated.

Document what happens during an outage or planned maintenance. Decide whether work queues safely, pauses or follows an agreed manual process. If a manual workaround is used, explain how those records are reconciled when the connection returns so recovery does not create duplicate work.

Roll out a bounded flow with evidence

Confirm current provider access, interface behaviour and the permissions available to the actual accounts. Test in a suitable environment, then agree a controlled live verification boundary. Distinguish simulated checks from provider evidence and record the actual records affected by the final verification.

Expand only after the first workflow has clear acceptance evidence and an operating owner. Keep a record of mappings, approvals, exceptions and provider dependencies. A useful integration makes the handoff understandable and recoverable as the business process evolves.

Worked CRM-to-ERP exchange: one approved order

In a fictional exchange, CRM order C-104 becomes eligible only after commercial approval. The CRM owns the customer-facing contact and approved order contents; the ERP owns the fulfilment reference and operational state. A stable customer mapping and C-104 external reference travel with the request. Do not synchronise invoice or fulfilment states back into editable CRM fields unless the responsible owners explicitly approve that behaviour.

The ERP accepts C-104 as E-880, but the connection drops before the response arrives. The connector looks up C-104 through the documented provider mechanism and reconciles E-880. If lookup is unavailable, mark the result unresolved for an operator instead of assuming failure and creating another order. A duplicate event uses the same logical reference and must not create E-881.

Now correct the delivery instruction after fulfilment has begun. The ERP owner decides whether the correction is allowed; the CRM presents pending or rejected change status, rather than overwriting operational reality. Test a new customer, an ambiguous existing match, a cancellation and delayed updates alongside the normal path. The provider-specific interface and business controls still require inspection; a generic standard cannot establish compatibility.

GOV.UK: API technical and data standards

How this relates to Veda Software’s work

Powerleague’s supplier-facing fulfilment flow demonstrates the importance of an accepted operational handoff. It is adjacent evidence, not a published CRM/ERP synchronisation or these invented order references.

Veda Software: Powerleague print portal

Key takeaways

  • Start with one approved business handoff.
  • Define field ownership, matching and correction rules explicitly.
  • Test duplicate prevention and lifecycle changes alongside creation.
  • Assign reconciliation and outage recovery to named operational owners.

Related service

Turn the next decision into a clear plan.

Discuss the software you need, the constraints you face and the outcome you want to achieve.

Veda Software · Self-serve ordering portal build

One portal, every venue: decentralising print ordering across a national estate

Print ordering across a national estate ran through an awkward external experience and one central team. Veda Software designed and built a self-serve ordering portal: every venue orders directly, and the central team no longer has to push each order through by hand.