---
name: sage-intacct-salesforce
description: Build a production-grade Sage Intacct to Salesforce integration covering architecture, the step-by-step build with Apex code, field mapping, API and governor limits, security, monitoring, and the pitfalls to design out. Use when connecting, building, or debugging a Sage Intacct and Salesforce integration.
---

# Sage Intacct to Salesforce integration

> Cloudsheer's delivery playbook for Sage Intacct on Salesforce, distilled from 2 client projects and 14 delivery tasks. Apply it as the reference approach when building this integration.

## Overview

Two-way Salesforce and Sage Intacct accounting sync via MuleSoft. We have shipped it across 2 client projects and 14 build tasks.

The value is one source of truth: both systems stay current, records reconcile automatically, and every error is logged for review.

We use Sage Intacct as governed middleware: Salesforce and your other systems connected once, mappings and transforms kept in one place, and scheduled flows with retries and monitoring.

Every Sage Intacct build is delivered by a senior Salesforce architect on a fixed price, tested end to end in a sandbox, deployed to your org, and backed by 30 days of hypercare. You own the result: documented, source-controlled, and free of black-box middleware lock-in.

## Integration facts

**Connects via:**
- MuleSoft (Anypoint / Composer) Sage Intacct Connector performing bi-directional sync with Salesforce
- Sage Intacct XML Web Services via HTTP POST to the XML gateway
- DataWeave transforms map Salesforce fields to Intacct dimensions and objects

**Package:** Custom build (no managed package)

**Authentication:** XML Web Services: senderId + senderPassword (partner credentials) plus company login; getAPISession returns a Session ID and a unique session endpoint used for all subsequent requests

**API type:** SOAP/XML

**API base:** `https://api.intacct.com/ia/xml/xmlgw.phtml (getAPISession returns a session-specific endpoint)`

**Key endpoints:**
- `getAPISession`
- `create_sotransaction (AR invoice, ARINVOICE + lines)`
- `create_journalentry (GL journal)`
- `readByQuery`
- `readByName`

**Official docs:** https://developer.intacct.com/web-services/

## Prerequisites

- A Salesforce edition with API access (Enterprise, Unlimited, or Developer)
- A dedicated sandbox to build and test in
- A Sage Intacct account on a plan with API access
- System Administrator access on both systems
- A dedicated integration user with a minimum-access permission set
- Agreement on the objects, fields, and sync direction for the Sage Intacct data

## Architecture

Data flows left to right through four lanes:

1. **Sources:** Salesforce records, Sage Intacct
2. **Integration layer:** Mapping and transforms, Push on trigger, Scheduled pull
3. **Salesforce:** Invoice, Related records, Reports
4. **Outcomes:** Both systems current, Auto-reconciled, Errors logged

## How it works at runtime

1. **Change in either system** `[Either system]`: A change in Salesforce or in Sage Intacct starts the sync.
   - Note: `Salesforce side via flow or Change Data Capture; vendor side via webhook or scheduled pull.`
2. **Transform and route** `[In transit]`: The integration layer maps and transforms the payload between the two data models.
   - Note: `DataWeave or Apex converts between the Salesforce and vendor schemas.`
3. **Push and scheduled pull** `[In transit]`: Records push on trigger and pull on a schedule so both sides stay current.
   - Note: `An updatedSince delta filter keeps each batch small and current.`
4. **Reconciled both ways** `[Both systems]`: Records reconcile across systems, with every error logged for review.
   - Note: `Conflicts resolved by rule; failures land in an Error Log object for replay.`

## Step-by-step build

### Step 1: Plan the integration and prerequisites

We line up both systems and the platform first.

- API access on Salesforce and your other systems, plus the Sage Intacct environment and connectors
- The objects, direction, sync pattern, and success criteria agreed up front

### Step 2: Connect Salesforce to Sage Intacct

We wire up the Salesforce connector securely.

- Configure the Salesforce connector with a Connected App and OAuth, or JWT for a headless flow
- Give the connector a dedicated least-privilege integration user

### Step 3: Connect the target systems

We bring the other endpoints into the platform.

- Configure each target connector with its own secure credentials

### Step 4: Design a canonical data model

We map everything to one shared shape, not point to point.

- Define a canonical model so each system maps to and from one schema, which scales as systems are added

### Step 5: Build the transforms

We keep all the mapping logic in one governed place.

- Build the Sage Intacct flows or recipes that move each record
- Map and transform payloads (for example, DataWeave on MuleSoft) to and from the canonical model

Reference implementation (`snippets/transform.dwl`):

```dataweave
%dw 2.0
output application/json
---
payload map (row) -> {
  External_Id__c: row.id,
  AccountId: row.customerId,
  Amount__c: row.total,
  Status__c: upper(row.state)
}
```

### Step 6: Choose the sync pattern

We pick real-time or batch per use case.

- Real-time via Platform Events or Change Data Capture, or scheduled batch with an updatedSince filter

Reference implementation (`snippets/OrderEventTrigger.trigger`):

```apex
// Real-time: Salesforce publishes a Platform Event, the iPaaS subscribes
trigger OrderEventTrigger on Order_Event__e (after insert) {
  List<Sync_Task__c> tasks = new List<Sync_Task__c>();
  for (Order_Event__e ev : Trigger.new) {
    tasks.add(new Sync_Task__c(Order_Id__c = ev.Order_Id__c, Status__c = 'Queued'));
  }
  insert tasks;
}
```

### Step 7: Add error handling and retries

We make it reliable at volume.

- Batch records in chunks, add retries with backoff, and route failures to a dead-letter queue

Reference implementation (`snippets/DeltaPullScheduler.cls`):

```apex
// Scheduled delta pull: only records changed since the last successful run
global class DeltaPullScheduler implements Schedulable {
  global void execute(SchedulableContext ctx) {
    Datetime since = IntegrationConfig.lastSync();
    ExternalService.pullUpdatedSince(since);     // the iPaaS flow filters by updatedSince
    IntegrationConfig.setLastSync(System.now());  // watermark for the next run
  }
}
```

> **Pro tip: build for retries** At volume, transient failures are normal. Batch in chunks and add retries with a dead-letter queue, so a blip never means lost data.

### Step 8: Test in a sandbox environment

We validate before production.

- Run representative loads end to end and confirm both sides reconcile

### Step 9: Deploy with CI and monitor

We ship it and keep it observable.

- Promote Sage Intacct artifacts through environments with CI, and monitor the flows with alerting plus 30 days of support

## Data model

| Object | Purpose | Key fields |
| --- | --- | --- |
| `Invoice` | The primary Salesforce record Sage Intacct data maps onto. | `External_Id__c, Name, Status` |
| `Account` | Matched or created for the customer or company behind the record. | `Name, External_Id__c` |
| `Error_Log__c (custom)` | Captures every request, response, and failure so anything can be replayed. | `Payload__c, Status__c, Related_Id__c` |
| `Sync_Log__c (custom)` | Tracks the last-synced timestamp per record for delta pulls. | `Last_Synced__c, Direction__c` |

Salesforce objects typically in play: `Account`, `Opportunity`, `Order`, `custom AR invoice line object`, `custom GL journal entry object`

## Field mapping (example)

| Sage Intacct | Salesforce | Notes |
| --- | --- | --- |
| Sage Intacct record id | `Invoice.External_Id__c` | Unique external id, upsert key |
| Sage Intacct number | `Invoice.Name` |  |
| Sage Intacct customer | `Account` | Matched or created |
| Sage Intacct amount / total | `Invoice.Total__c` |  |
| Sage Intacct status | `Invoice.Status` | Picklist value mapping |
| Created / updated at | `LastModifiedDate` | Enables delta sync and audit |
| Owner or rep | `Invoice.OwnerId` | Assignment rules or a default owner |

Tailor the full mapping to the org. Always upsert on an external-id field so retries are idempotent.

## API and rate limits

### Sage Intacct-specific

- Session IDs are idle-timeout limited and must be refreshed
- Per-company concurrency throttling; Intacct recommends single-threaded use of a session
- Large loads should use offline/async processing to avoid gateway timeouts

### Salesforce platform

- Sage Intacct manages throttling and backpressure between systems, so neither side is overwhelmed.
- Salesforce Bulk API handles large loads, conserving the standard REST API allocation.
- Change Data Capture and Platform Events stream changes in real time instead of polling.

## Security checklist

- Secrets stored in Named Credentials and permission sets, never in code or metadata
- A least-privilege integration user, with field-level security and sharing scoped tight
- All traffic over TLS, with signature verification on inbound events
- Shield Platform Encryption available for sensitive fields
- A full audit trail: every request and response logged for traceability
- Every automation runs as a dedicated integration user, so actions are attributable and revocable
- Sandbox-first delivery and change-set deployment keep production changes reviewed and controlled

## Monitoring and reliability

- Every request and response is logged to a custom Error Log object, tagged with the related record id.
- Failed calls retry with exponential backoff; anything still failing lands in a dead-letter queue for review.
- Idempotency keys guarantee a retried or duplicate event never double-posts a record.
- A dashboard surfaces failures, latency, and volume so problems are caught before users notice.
- Optional email or Slack alerts fire on repeated failures or a stalled sync.

## Testing and deployment

- Apex unit tests with HttpCalloutMock cover the success path, failure handling, and a 200-record bulk case, at 75 percent or higher coverage.
- The full flow is validated in a sandbox against real sample data and the edge cases that matter.
- A parallel run reconciles the integration against your live system before cutover.
- Everything deploys through change sets or an SFDX and CI pipeline, under version control.
- Permission sets, sharing, and Named Credentials are configured in production, then we run 30 days of monitored hypercare.

## Pitfalls to design out

- **Point-to-point sprawl:** Map every system through one canonical model instead of pairwise connections.
- **Silent failures at volume:** Add retries with backoff and a dead-letter queue with alerting.
- **Schema drift breaks the flow:** Version the transforms and validate payloads against a contract.
- **No visibility when it breaks:** We log every call and surface failures on a dashboard with alerts, so an issue never goes unnoticed.
- **Reporting drifts from reality:** External-id keys and a delta timestamp keep Salesforce and the source reconciled, so reports stay trustworthy.

### Sage Intacct-specific gotchas

- A function-level controlid is required for idempotency; without it, retries can post duplicate invoices or journal entries
- Returned session endpoints must be validated to intacct.com domains
- The Web Services subscription and a dedicated sender id must be enabled in Intacct before any call succeeds

## FAQ

**How do you authenticate Sage Intacct with Salesforce?**

We connect Sage Intacct using MuleSoft with secure credentials and store every secret in Salesforce Named Credentials with a permission set, so nothing is hard-coded or shipped in metadata.

**Does the Sage Intacct integration handle bulk volume?**

Yes. All Apex is bulkified, volume moves to Queueable or Batch Apex, and we respect the Salesforce governor limits (SOQL, DML, and callout caps per transaction).

**How do you prevent duplicate records?**

We upsert on a unique external-id field, so a retried or duplicate payload is idempotent and never creates a second Invoice.

**How is the integration tested and deployed?**

Apex tests with HttpCalloutMock cover the success, failure, and a 200-record bulk case (75 percent plus coverage). We deploy via change sets or an SFDX and CI pipeline.

**What happens if Sage Intacct or Salesforce is briefly down?**

Failed calls retry with backoff and land in an Error Log object with alerting, so nothing is lost and any event can be replayed.

**Real-time or batch sync?**

Either. We use Platform Events or Change Data Capture for real-time, or a scheduled batch with an updatedSince delta filter for high volume.

---

Maintained by [Cloudsheer](https://www.cloudsheer.com). Full illustrated guide: [Sage Intacct technical guide](https://www.cloudsheer.com/integrations/sage-intacct/technical-guide). Want it built for you at a fixed price? [Book a free 30-minute call](https://cal.com/cloudsheer-consulting/30min?overlayCalendar=true).