Ecommerce and marketplaces
Send approved customers, orders, invoices, payments, or related records from an online sales workflow when the required SQL Accounting endpoints are supported.
SQL Accounting integration planning guide
Plan a SQL Accounting integration before you build.
Use this technical guide to map a controlled data flow from ecommerce, ERP, CRM, POS, warehouse, order management, or custom software into SQL Accounting. Compare connection options, confirm supported records, and define ownership and failure handling before choosing an implementation path.
External systemsControlled data flowOn-premise accounting
Source systems
What can connect to SQL Accounting?
The external system decides when data should move. AcctBridge provides the managed path to the selected SQL Accounting company database, while the integration maps source events to operations supported by the COM BizObjects connector.
ERP, CRM and order management
Keep operational sales and customer workflows outside accounting, then write the final supported records into SQL Accounting.
POS, retail and warehouse systems
Connect store, stock, delivery, or payment processes while keeping each accounting installation and credential isolated.
Custom portals and internal software
Let an internal application validate a workflow or collect approvals before it calls supported SQL Accounting records.
Integration planning
Choose how the external system will reach SQL Accounting.
Confirm the SQL Accounting edition, company database, connector runtime, document numbering, required fields, and exact read, create, update, or delete operation. Then define data ownership, duplicates, retries, and who resolves rejected records.
Integration options
Direct site access
This can work inside one trusted network, but every source system must own local connectivity, credentials, accounting-specific access, and support.
One-off integration middleware
A dedicated connector can own mapping and business rules, but its team must also maintain secure site access, diagnostics, credentials, and upgrades.
Managed SQL Accounting API connection
AcctBridge handles outbound site connectivity, API credentials, routing, connection checks, and OpenAPI documentation while your integration owns the workflow.
Implementation checklist
Define the system of record
Decide which system owns customers, products, orders, invoices, payments, and status changes before mapping fields.
Confirm record and field coverage
Check required create, update, delete, lookup, tax, and knock-off operations against the current SQL Accounting OpenAPI document.
Plan failures and duplicates
Define idempotency, retries, validation errors, reconciliation, and who resolves records that SQL Accounting rejects.
Common data flows
Master data
Read or write supported customer, stock, supplier, tax, and related reference records according to the chosen ownership model.
Sales and financial documents
Create supported invoices, payments, credit notes, purchases, or related records after upstream business checks pass.
Status and reconciliation
Read accounting results back into the source system and surface rejected, duplicate, or unmatched records for review.
Implementation path
From business workflow to a tested accounting data flow.
A SQL Accounting integration starts with the company database and BizObjects operation the workflow needs. Validate field mapping, document rules, delete or reversal behaviour, and error handling before external software writes live records.
1
Map the business data flow
Document the source event, target SQL Accounting record, required fields, ownership, update direction, and expected accounting result.
2
Validate API coverage
Compare every required read, create, update, delete, and reconciliation step with the current SQL Accounting endpoints.
3
Connect the SQL Accounting site
Install the local agent, establish outbound connectivity, and issue a separate API key for the accounting installation.
4
Test success and failure paths
Verify field mapping, duplicates, retries, accounting validation errors, reconciliation, and operational ownership before production use.
FAQ
SQL Accounting integration questions.
What business systems can integrate with SQL Accounting through AcctBridge?
Ecommerce stores, marketplaces, ERP, CRM, POS, warehouse, order management, reporting tools, and custom software can integrate when they can call REST APIs and the required SQL Accounting records are supported.
Is this a ready-made Shopify, marketplace, or POS connector?
No. AcctBridge provides the managed SQL Accounting API and connection layer. Your team or implementation partner maps the source system workflow, or AcctBridge can assess and build that integration as a custom service.
What SQL Accounting data can an external system read or write?
Current public endpoints cover supported customer, invoice, payment, stock, supplier, purchase, credit note, and related workflows. Review the SQL Accounting API page and OpenAPI document before committing to a field mapping.
How does AcctBridge reach the SQL Accounting connector runtime?
A Windows service runs where it can access the SQL Accounting COM BizObjects runtime and company database. It initiates the outbound gateway connection, so the site does not need inbound ports, a static public IP, or a VPN endpoint.
Should we use the SQL Accounting API directly or request a custom integration?
Use the API directly when your team can own mapping, business rules, retries, testing, and deployment. Request a custom integration when you need AcctBridge to assess the workflow and build or maintain the middleware or user interface.
Does AcctBridge work outside Malaysia?
Yes. AcctBridge works wherever a SQL Accounting installation is running, including Singapore and the rest of Southeast Asia. The outbound connection setup is the same regardless of location.
Optional implementation help
Need a technical fit check before you build?
Use the commercial service page to share one real workflow. We will review the required records, access constraints, known gaps, and a sensible next step before any implementation commitment.