All integrations

ERP and accounting

Sage & Pastel Field Sales Integration

Guided API recipe — custom setup required

SalesPro Hub can exchange submitted orders, customer records, fulfilment status and SKU stock with Sage or Pastel through its REST API and signed webhooks. A Sage SDK script, scheduled task or middleware must still implement the accounting-side mapping; this is not a one-click native Sage connector.

Test the field workflow first

Support level: Guided API recipe — custom setup required. The workflow below separates shipped SalesPro Hub capabilities from connector work your implementation must provide.

Client-provided ERP licence required: SalesPro Hub Enterprise covers the managed connector service only. It does not include or resell the ERP product, ERP modules, API, SDK, e.net, runtime, user or vendor-partner licences. The client must provide and maintain every third-party licence, supported integration interface, vendor permission and licensed test or production environment required by their ERP.

What this solves

One operational hand-off, with explicit ownership

The practical pattern for South African distributors is a small scheduled connector: SalesPro Hub owns field capture, Sage or Pastel owns the accounting document, and both systems retain the same reference. Polling is usually the simplest option behind office firewalls; signed webhooks can reduce the delay when a public HTTPS endpoint is available.

Available in SalesPro Hub today

  • Poll only submitted orders; mobile drafts stay private
  • Acknowledge each order with its Sage or Pastel reference
  • Return confirmed, processing, delivered or cancelled status
  • Publish absolute stock-on-hand by matching product SKU
  • Upsert customers using a stable external Sage identity
  • Resume incremental polling without timestamp gaps

Custom work and limitations

  • No universal one-click connector is claimed across Sage 50cloud, Sage Business Cloud Accounting and Sage 300.
  • Your Sage SDK, integration partner or middleware must create the accounting document and map tax, warehouse and account codes.
  • The implementation must decide whether Sage or SalesPro Hub owns stock deductions to prevent double-counting delivery.
Do not buy implementation work until the source of truth, idempotency key, failure owner and reconciliation process are written down.
Sage Accounting API reference

Sage & Pastel integration evidence

Connect the operating records—not just the brand names

A useful Sage & Pastel connection needs stable identities, explicit ownership and a visible exception path. These are the SalesPro Hub records the implementation must map and reconcile.

Written and maintained by Paul · Updated 28 July 2026

South African distribution finance and operations staff reconciling mobile field orders with Sage or Pastel accounting records

Reconcile the same order in both systems

A go-live check should match the field order, customer, totals and resulting accounting reference rather than treating a successful request as sufficient evidence.

Architecture diagram showing submitted field orders moving through a Windows connector to an on-premise Sage or Pastel database and returning status

Choose a deployment that fits the accounting edition

On-premise products commonly need a scheduled Windows-side process, while cloud editions may use a different API and authentication path.

Sage and Pastel integration mapping screen validating customer accounts order numbers SKUs VAT warehouse codes and document references

Validate every commercial identity

Customer codes, product codes, warehouses, taxes and document references need explicit mapping and a review path for unknown values.

South African ERP administrator and field sales manager validating customers products stock quantities and prices before integration go-live

Align master data before posting orders

A controlled pilot exposes inactive accounts, unknown SKUs, price differences and stock ownership questions before they become live exceptions.

South African finance IT and sales leaders reviewing Sage or Pastel integration test results and exception ownership before go-live

Approve the operating model, not only the connector

Finance, IT, operations and the implementation partner should agree who rotates credentials, investigates failures and reconciles each reporting period.

South African operations specialist reconciling a SalesPro Hub field order with a Sage or Pastel business system on a laptop and tablet

Preserve one reference from field to finance

The field order number and returned ERP document reference give both teams a common trail through retries and status changes.

Architecture and ownership

Design the Sage & Pastel operating contract before the data flow

Most South African Sage or Pastel projects use a customer-hosted scheduled connector because the accounting product and its data interface sit inside the office network. The exact design depends on whether the buyer uses Sage 50cloud Pastel, Sage 200 Evolution, Sage 300 or Sage Business Cloud Accounting; those products are not one interchangeable API. A responsible scope starts with the product name, version, database or SDK entitlement, company code, warehouse model and document type.

Sage or Pastel normally owns the posted accounting document, customer account code, VAT treatment and the official external order or invoice number.

SalesPro Hub owns the rep’s mobile draft, visit context and the submitted field order before the accounting hand-off.

The implementation must choose which system owns prices and available stock, including when each quantity becomes effective.

Customer and product master data may flow from accounting to the field platform, but creation and change authority must be declared separately.

Security review boundary

For an on-premise edition, the Windows service should run under a least-privilege service identity with only the SDK, database and folder access the adapter needs. The customer should record the outbound hub destinations, proxy or TLS-inspection behaviour, credential rotation procedure and local break-glass owner. Managed remote settings are restricted to an adapter schema and do not create a generic command shell or unrestricted database browser.

Failure recovery

Decide what happens when the happy path stops

A useful Sage & Pastel integration is not defined by one successful demo. It is defined by what remains durable, what can be replayed safely, what must stop, who sees the exception and how both systems are reconciled.

Failure or conflictRequired response
Unknown customer or SKUReject the individual record with the unmapped identity visible; never substitute a similar name automatically.
Accounting service unavailableKeep the operation durable, retry only a bounded temporary fault and preserve the same order identity.
Response lost after commitLook up the stable source reference before attempting another document creation.
Tax or warehouse validation errorQuarantine the permanent mapping error for finance or ERP administration instead of retrying forever.
Credential or host changeDeliver an approved versioned setting, validate locally and retain the previous known-good configuration for rollback.

Acceptance plan

Tests to run with the buyer’s real edition and workflow

A sandbox proves API syntax. Production readiness requires representative identities, accounting or CRM rules, failures and reconciliation. Record the result against the exact product edition and adapter release; do not transfer evidence from a different vendor version by assumption.

  • Create representative cash and account customers, including one intentionally unmapped account.
  • Post orders with discounts, VAT, multiple warehouses and an invalid SKU.
  • Replay the same submitted order before and after a simulated lost response.
  • Stop the accounting service and Windows service independently, then confirm durable recovery.
  • Reconcile item quantities, exclusive and inclusive values, tax, document number and SalesPro Hub external reference.
  • Rotate the credential and complete a signed connector upgrade and rollback exercise.

Delivery lifecycle

From Sage & Pastel discovery to a supportable steady state

Treat the connection as a small operational product with owners, release evidence and a lifecycle. These phases stop a promising prototype from becoming an invisible production dependency that only one developer understands.

  1. 1

    Discover the real workflow

    Name the exact Sage & Pastel product, edition, company or tenant, licensed interface and deployment. Follow one representative customer and order from field capture to its final external state. Record current manual checks, approval points, cut-off times, volumes and the people who resolve errors. Brand-level assumptions are not a technical scope.

  2. 2

    Write the data contract

    List required and optional fields, types, formats, allowed values and stable identities. Declare a source of truth for customers, outlets, products, prices, tax, stock, documents and status. Define create, update, deactivate and delete behaviour separately. Include the idempotency key, cursor or event identity and the external reference returned after a successful commit.

  3. 3

    Build the exception contract

    Classify authentication, rate-limit, connectivity, validation, mapping, conflict and external-service errors. Decide which faults retry, how often and with what backoff; which stop immediately; and where exhausted work becomes visible. Assign a named business or technical owner and define the evidence needed to replay, correct, reject or manually reconcile an operation.

  4. 4

    Prove a controlled pilot

    Use representative South African customers, addresses, SKUs, rand values, VAT rules, discounts, warehouses and approval cases. Include duplicates, missing mappings, offline or network loss, service restart, expired credentials and a lost response after external commit. Reconcile counts and commercial totals in both systems; a green API response alone is not acceptance.

  5. 5

    Release with a rollback plan

    Version the mapping, adapter and configuration together. Record the approved package, supported architectures, required runtime, database or API prerequisites and the previous known-good state. Start with a bounded customer or order cohort, monitor exceptions and keep a tested way to pause new work without deleting the durable queue or losing reconciliation evidence.

  6. 6

    Operate and review

    Monitor reachability, authentication, latency, retry and dead-letter trends, external rate limits, installed version and reconciliation differences. Rotate credentials and exercise recovery before an emergency. Review vendor API or SDK changes and the adapter support matrix before upgrades. Retire obsolete credentials, mappings and data under the agreed security and POPIA operating process.

South African procurement note: confirm the parties’ POPIA roles, purposes, access, retention, operator terms and incident process during procurement. Hosting and subprocessors should be confirmed from current contractual evidence. Product controls can support a lawful implementation, but an integration page cannot certify the buyer’s operating practices or replace legal and security review. Before expanding the pilot, agree measurable release criteria: the maximum acceptable age of a pending operation, expected daily reconciliation window, alert response owner, acceptable mapping-error rate, retry ceiling and the evidence required to close an incident. Keep deployment, configuration and mapping versions beside the reconciliation result so a later difference can be traced to the exact operating state. Review those criteria when order volume, product range, warehouses, tax treatment or the external vendor version changes. A technically healthy connector can still create the wrong commercial result if ownership or mapping assumptions have drifted. Keep the sign-off, evidence and named operational owners accessible for every later support and change review.

Decision-maker intent

Questions different buyers ask about Sage & Pastel

Finance

Will this create the correct accounting document?

The document type, status, tax, account, warehouse and approval rules must be agreed and tested for the exact Sage or Pastel edition. The field order alone cannot choose those accounting policies.

IT

Do you need permanent RDP access?

Routine enrolment, monitoring, approved settings and upgrades are designed for self-service or remote control on Enterprise. Machine or network failures that break the hub channel still need a narrow local support path.

Operations

How do we see a stuck order?

A production adapter needs visible operation state, retry count, last error, external reference and reconciliation ownership. A background task with no exception queue is not an acceptable go-live design.

Professional includes scoped APIs and signed webhooks for custom, customer-operated middleware. A managed Windows connector, remote configuration, heartbeat/version monitoring and managed recovery require Enterprise—and only become available for this named system after its real adapter passes the published release boundary.

Buyer decision guide

Scope the Sage & Pastel connection before buying implementation

A good trial should prove the workflow with your data—not rely on a sales promise.

Strong fit when you need

  • Teams that have already proved the SalesPro Hub field workflow with real data.
  • Businesses able to assign an owner for mapping, credentials and exception handling.
  • Integrations built around stable customer, order or product identifiers.

Confirm during the trial

  • The exact Sage & Pastel product, edition and API access available to your account.
  • The system of record for customers, stock, tax, status and accounting documents.
  • Whether polling, signed webhooks or middleware best fits your network and support model.

Implementation flow

How the connection works

  1. 1

    Read submitted field orders

    Poll pending, unacknowledged orders or react to an order-submitted webhook. Stable cursors prevent ties from skipping orders.

  2. 2

    Create the Sage/Pastel document

    Your connector maps customer code, SKU, quantity, price, discount and VAT into the appropriate Sage sales-order workflow.

  3. 3

    Store the ERP reference

    Acknowledge the SalesPro Hub order with the new Sage reference. Conflicting retries return a 409 instead of silently relinking the order.

  4. 4

    Reconcile fulfilment and stock

    Return status as the office fulfils the order and publish current stock by SKU according to the agreed system-of-record policy.

Field mapping starting point

SalesPro Hub field/eventSage & Pastel equivalentImplementation note
customer.external_idSage customer/account IDImmutable identity; do not match by name.
order_numberImport/source referenceUse as the inbound deduplication key.
external_referenceSage sales order/invoice numberWritten back after creation.
items[].skuSage item codeSKUs must be aligned before go-live.
stock_qtyQuantity on handAbsolute quantity, not a relative movement.

Sage & Pastel integration questions

Does SalesPro Hub have a native Sage or Pastel integration?

It provides the order, customer, inventory, webhook and status APIs plus a guided implementation recipe. A Sage SDK script or middleware is still required, so it is not described as a one-click native connector.

Can SalesPro Hub orders be imported into Sage automatically?

Yes, once a scheduled connector or webhook consumer has been implemented. The connector polls submitted orders, creates the Sage document, and acknowledges the SalesPro Hub order with the Sage reference.

How is duplicate order creation prevented?

Use the SalesPro Hub order number as the inbound idempotency key. Acknowledgement and status callbacks are replay-safe, and conflicting external references are rejected.

Can Sage remain the stock system of record?

Yes. Publish absolute stock quantities to SalesPro Hub by SKU and configure the inventory deduction policy so the same delivery is not deducted independently in both systems.

Does SalesPro Hub provide the Sage & Pastel ERP licences?

SalesPro Hub Enterprise covers the managed connector service only. It does not include or resell the ERP product, ERP modules, API, SDK, e.net, runtime, user or vendor-partner licences. The client must provide and maintain every third-party licence, supported integration interface, vendor permission and licensed test or production environment required by their ERP.

Validate the field workflow before connecting accounting

Import real products and customers, capture a representative order, then scope the integration against evidence instead of assumptions.

Start the free trial