Skip to main content
sage-intacct icon

Sage Intacct Connector

SourceAPI DocsAPI ChangelogConnector Changelog

Description

Sage Intacct is an industry-leading financial accounting software system with a broad set of functionalities for businesses across a number of different verticals.

This component allows you to create, update, and query financial data including invoices, payments, vendors, and customers.

API Documentation

This component was built using the Sage Intacct API.

Connections

Sage Intacct Connection

key: sageIntacctConnection

To connect to Sage Intacct, Web Services credentials are required. These credentials consist of sender credentials (provided by Sage Intacct) and company/user credentials (created within the Sage Intacct platform).

Sage Intacct uses a dual authentication model:

  • Sender credentials (Sender ID and Sender Password) are provisioned by Sage Intacct for customers or partners with an active Web Services developer license
  • Company credentials (Company ID, User ID, and User Password) are created within the Sage Intacct account

Refer to Sage Intacct's Web Services documentation for additional information on authentication.

Prerequisites

  • An active Sage Intacct account with a Web Services developer license
  • Administrative access to configure Web Services settings
  • Sender ID and Sender Password provisioned by Sage Intacct
  • A Sage Intacct user account with appropriate API permissions

Setup Steps

To obtain Web Services credentials:

  1. Obtain Sender Credentials:

    • Contact Sage Intacct support or the account representative to request Web Services access
    • Once provisioned, Sage Intacct will provide a Sender ID and Sender Password
    • These credentials are used to authenticate the integration at the organization level
  2. Enable Web Services in Sage Intacct:

    • Log in to Sage Intacct as an administrator
    • Navigate to Company > Setup > Company > Security
    • Locate the Web Services authorizations section
    • Enable Web Services for the organization
  3. Identify Company Credentials:

    • The Company ID is the unique identifier for the Sage Intacct company
    • This is typically visible in the Sage Intacct URL or company settings
    • Navigate to Company > Setup > Company > Company info to verify the Company ID
  4. Create or Identify API User:

    • Create a dedicated user account for API access or use an existing user
    • Navigate to Company > Admin > Web Services users
    • Ensure the user has the necessary permissions for the integration's operations
    • Note the User ID (username) and User Password for this account
  5. Determine Entity ID (Multi-Entity Only):

    • If the Sage Intacct account uses multiple entities, determine the Entity ID for the entity to access
    • Navigate to Company > Setup > Entities to view available entities
    • If using a single-entity account, the Entity ID can be left blank

Configure the Connection

Enter the following credentials into the connection configuration:

  • Sender ID: The Sender ID provided by Sage Intacct for Web Services authentication
  • Sender Password: The Sender Password provided by Sage Intacct
  • Company ID: The unique company identifier in Sage Intacct
  • User ID: The username of the Web Services user account
  • User Password: The password for the Web Services user account
  • Entity ID (optional): The entity identifier for multi-entity environments. Leave blank for single-entity accounts.
Multi-Entity Environments

For Sage Intacct accounts with multiple entities, specify the Entity ID to connect to a specific entity. If left blank, the integration will use the default entity associated with the user account.

Security Best Practice

Use a dedicated user account for API integrations with minimal required permissions. Avoid using personal administrator accounts for Web Services authentication.

InputNotesExample
Company ID

Your Sage Intacct Company ID. This is your unique company identifier in Sage Intacct.

ACME_INC
Entity ID

Optional entity ID for multi-entity Sage Intacct environments. Leave blank if your organization uses a single entity.

ENTITY_001
Sender ID

The Sender ID provided by Sage Intacct for Web Services authentication. Find this in your Sage Intacct account under Company > Setup > Company > Security.

ACME_CORP
Sender Password

The Sender Password for Web Services authentication. This password is set when configuring Web Services access in Sage Intacct.

User ID

The User ID (username) for Web Services authentication. This must be a user with appropriate API permissions.

apiuser@acme.com
User Password

The password for the Web Services user account.

Triggers

New and Updated Records

Checks for new and updated records in Sage Intacct on a configured schedule. | key: pollChangesTrigger

InputNotesExample
Connection

The Sage Intacct connection to use.

Resource Type

The Sage Intacct object to poll for new or updated records.

Show New Records

When true, newly created records are included in the trigger output.

true
Show Updated Records

When true, records updated since the last poll are included in the trigger output.

true

This trigger polls Sage Intacct for new or updated records of the selected object on a scheduled basis using the Sage Intacct XML API.

It uses each object's WHENMODIFIED timestamp to detect changes since the last poll, then categorizes results as new or updated based on the WHENCREATED timestamp.

How It Works

  1. The trigger runs on the configured schedule (e.g., every 5 minutes).
  2. It queries Sage Intacct's Functions.Common.ReadByQuery endpoint with a server-side filter of the form OBJECT.WHENMODIFIED > '{lastPolledAt}'. A newly created record has WHENMODIFIED == WHENCREATED, so this single query captures both new and updated records.
  3. Returned records are split client-side into created and updated arrays based on whether WHENCREATED is greater than the last poll timestamp.
  4. The trigger persists the current poll timestamp via context.polling.setState() so the next execution resumes from where this one left off.
  5. On the very first poll, lastPolledAt is initialized to the current time so historical records do not flood the workflow.

Configuration

Configure the following inputs:

  • Connection: The Sage Intacct connection to use.
  • Resource Type: The Sage Intacct object to poll for new or updated records. Supported types are listed below.
  • Show New Records: When enabled, newly created records are included in the trigger output. Defaults to true.
  • Show Updated Records: When enabled, records updated after the last poll are included in the trigger output. Defaults to true.

If both Show New Records and Show Updated Records are disabled, the trigger short-circuits and returns empty arrays without making an API call.

Supported Resource Types

Available Resource Types (8)
Resource TypeSage Intacct Object
VendorsVENDOR
CustomersCUSTOMER
Bills (AP)APBILL
Invoices (AR)ARINVOICE
ContactsCONTACT
EmployeesEMPLOYEE
ProjectsPROJECT
AR PaymentsARPYMT

Returned Data

The trigger returns separate arrays for newly created and updated records:

Example response payload
{
"data": {
"created": [
{
"RECORDNO": "12345",
"VENDORID": "V-001",
"NAME": "Acme Supplies",
"WHENCREATED": "2026-05-04T10:30:00Z",
"WHENMODIFIED": "2026-05-04T10:30:00Z"
}
],
"updated": [
{
"RECORDNO": "67890",
"VENDORID": "V-002",
"NAME": "Globex Corp",
"WHENCREATED": "2026-04-15T09:00:00Z",
"WHENMODIFIED": "2026-05-04T14:22:00Z"
}
]
}
}

The exact fields returned depend on the selected resource type. Each record reflects the full object as returned by the Sage Intacct XML API.

Best Practices

  • Polling Frequency: Use 5-15 minute intervals to balance timeliness with API rate limits.
  • First Poll: The first execution after deployment establishes the baseline timestamp and returns no records. Subsequent polls return changes made after that baseline.
  • Toggles: Disable Show New Records or Show Updated Records to filter the output to only one category of change.

Data Sources

Select Contact

A picklist of contacts in Sage Intacct. | key: selectContact | type: picklist

InputNotesExample
Connection

The Sage Intacct connection to use.

Return Contact Name

Turn on to return the Contact Name instead of the Record No.

false

Select Customer

A picklist of customers in Sage Intacct. | key: selectCustomer | type: picklist

InputNotesExample
Connection

The Sage Intacct connection to use.

Return ID

Turn on to return the ID of the object (e.g. CUSTOMERID, PROJECTID, VENDORID, etc.) instead of the Record No.

false

Select Invoice

A picklist of AR invoices in Sage Intacct. | key: selectInvoice | type: picklist

InputNotesExample
Connection

The Sage Intacct connection to use.


Select Project

A picklist of projects in Sage Intacct. | key: selectProject | type: picklist

InputNotesExample
Connection

The Sage Intacct connection to use.

Return ID

Turn on to return the ID of the object (e.g. CUSTOMERID, PROJECTID, VENDORID, etc.) instead of the Record No.

false

Select Vendor

A picklist of vendors in Sage Intacct. | key: selectVendor | type: picklist

InputNotesExample
Connection

The Sage Intacct connection to use.

Return ID

Turn on to return the ID of the object (e.g. CUSTOMERID, PROJECTID, VENDORID, etc.) instead of the Record No.

false

Actions

Create AR Advance

Creates a new AR Advance. | key: createARAdvance

InputNotesExample
Additional XML Tags

Additional XML tags that might not be covered by the standard inputs.

<PRBATCH>123456</PRBATCH>
              <PRBATCHKEY>123456</PRBATCHKEY>
              <DOCNUMBER>123456</DOCNUMBER>
              <DESCRIPTION>Advance Description</DESCRIPTION>
              <CURRENCY>USD</CURRENCY>
              <BASECURR>USD</BASECURR>
              <EXCH_RATE_DATE>
                <year>2021</year>
                <month>09</month>
                <day>12</day>
              </EXCH_RATE_DATE>
              <EXCH_RATE>1.23</EXCH_RATE>
              <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
              <SUPDOCID>123456</SUPDOCID>              
              <ACTION>Draft</ACTION>
AR Advance Items

Advance lines, must have at least 1. Check Documentation for additional tags.

<ARADVANCEITEM>
        <ACCOUNTNO>4055</ACCOUNTNO>
        <ACCOUNTLABEL>Misc Sales</ACCOUNTLABEL>
        <TRX_AMOUNT>1000</TRX_AMOUNT>
        <LOCATIONID>CA</LOCATIONID>
      </ARADVANCEITEM>
Connection

The Sage Intacct connection to use.

Customer ID

Unique ID. Required if company does not use document sequencing, or you can provide a value to use instead of the document sequence value.

CUST-12345
Financial Entity

ID of the checking or savings account to deposit the funds to. A create request must contain FINANCIALENTITY or UNDEPOSITEDACCOUNTNO when automatic summaries are enabled.

1020
Payment Date

Date the advance payment was made, in the mm/dd/yyyy format.

09/12/2021
Payment Method

Payment method used for the advance.

Cash
Receipt Date

Receipt date in the mm/dd/yyyy format. If automatic summaries are enabled, this is the date on which the advance will be posted to the General Ledger.

09/12/2021
Undeposited Account No

Undeposited funds account number. A create request must contain FINANCIALENTITY or UNDEPOSITEDACCOUNTNO when automatic summaries are enabled.

1020
Example Payload for Create AR Advance
Loading…

Create Bill

Create a new bill. | key: createBill

InputNotesExample
AP Bill Items

AP bill items, must have at least 1. Each item must be wrapped in <APBILLITEM></APBILLITEM> tags.

https://developer.intacct.com/api/accounts-payable/bills/#create-bill
Attachments ID

Id of an attachment group of one or more supporting files

ATT-001
Base Currency

Base currency code

USD
Bill Number

A Bill Number identifier

BILL-2024-001
Bill Transaction Date

Transaction date in MM/DD/YYYY format

12/06/2023
Bill GL Posting Date

General ledger posting date in MM/DD/YYYY format

12/06/2023
Connection

The Sage Intacct connection to use.

Currency

Transaction currency code

USD
Description

Description of the bill

Office supplies for Q1 2024
Reference Number

A reference number for the bill

REF-2024-5678
Due Date

Due date

12/06/2023
On Hold

Place this bill on hold

Payment PriorityHigh
Recommended to pay on

Payment date in MM/DD/YYYY format

12/06/2023
Term Name

Payment term, this should be a previously created term

Net 30
Vendor ID

The vendor ID.

V-01879
Example Payload for Create Bill
Loading…

Create Contact

Creates a new contact. | key: createContact

InputNotesExample
Active Status

When true, the record is active and available for use. When false, the record is inactive.

Company Name

Name of the company

Acme Corporation
Connection

The Sage Intacct connection to use.

Contact Details

Address, phone, email, and other contact channel details.

Contact Name

Contact name to create

John Doe
Name

First, middle, and last name with prefix.

Print Name As

Determine the format the name should be printed.

John A. Doe
Tax Information

Tax ID, taxable status, and tax group.

Example Payload for Create Contact
Loading…

Create Customer

Creates a customer and specifies a display contact and a contact list (provided via customer contacts). | key: createCustomer

InputNotesExample
Active Status

When true, the record is active and available for use. When false, the record is inactive.

Attachments ID

Id of an attachment group of one or more supporting files

ATT-001
Billing and Delivery Preferences

Payment term, delivery method, default invoice message, and shipping method.

Comments

Additional comments

Company Name

Name of the company

Acme Corporation
Connection

The Sage Intacct connection to use.

Contact Details

Address, phone, email, and other contact channel details.

Credit Limit

Credit limit amount

50000
Contact Roles

Primary, bill-to, and ship-to contact assignments.

Customer ID

Unique ID. Required if company does not use document sequencing, or you can provide a value to use instead of the document sequence value.

CUST-12345
Customer Name

Customer name

Global Tech Solutions
Customer Type ID

Identifier for the type of customer

TYPE-001
Custom Fields

Custom field names and values as defined for this object

[["fieldName1",123],["fieldName2","someStringValue"],["fieldName3",{"key":"value"}]]
Default Currency

Default currency code

USD
Excluded From Contact List

When true, this contact will be excluded from contact lists and searches. When false, the contact appears in all lists.

GL Accounts

GL group, offset AR GL account, and default revenue GL account numbers.

Name

First, middle, and last name with prefix.

One Time

One time. Use false for No, true for Yes. If you want to simplify your customer list page by displaying only your regularly-used customers, we recommend you select this option for customers that you use only once or just occasionally. These customers will not appear in the customer list page unless you click Include one-time use at the top of the list page, in which case, you'll see all your customers regardless of frequency of use.

On Hold

When true, the account is placed on hold and transactions are suspended. When false, the account operates normally.

Parent Customer ID

Identifier of the parent customer

CUST-PARENT-001
Print Name As

Determine the format the name should be printed.

John A. Doe
Print Options

Document template assignments for invoices, quotes, orders, and adjustments.

Resale Number

Resale certificate number for tax-exempt purchases

RSL-123456
Restricted Department

Restricted department IDs. Use if OBJECTRESTRICTION is Restricted

Restricted Location

Restricted location ID. Use if OBJECTRESTRICTION is Restricted

Restriction Type

Type of restriction

Sales Rep Employee ID

Employee ID of the sales representative

EMP-001
Tax Information

Tax ID, taxable status, and tax group.

Territory ID

Identifier for the territory

TERR-001
Example Payload for Create Customer
Loading…

Create Invoice

Creates an invoice. | key: createInvoice

InputNotesExample
Attachments ID

Id of an attachment group of one or more supporting files

ATT-001
Bill To Contact Name

The name of the contact to bill to. This should be an existing contact in Intacct.

Jane Smith
Connection

The Sage Intacct connection to use.

Currency and Exchange Rate

Base currency, transaction currency, and exchange rate details.

Customer ID

The customer ID to create the invoice for.

C-00269
Custom Fields

Custom field names and values as defined for this object


  <customfield>
    <customfieldname>MYCUSTOMFIELD</customfieldname>
    <customfieldvalue>MYCUSTOMFIELDVALUE</customfieldvalue>
  </customfield>
  
Date Created

Invoice date creation date

12/06/2023
GL Date Posted

Invoice General Ledger posted date

12/06/2023
Description

The description of the invoice.

Some description
Due Date

The due date of the invoice.

12/06/2023
External ID

An external ID for the invoice

1234
Invoice Line Items

Invoice lines, must have at least 1. Each item must be wrapped in <lineitem></lineitem> tags.

https://developer.intacct.com/api/accounts-receivable/invoices/#create-invoice-legacy
Invoice Number

Invoice number

1234
No GL

Do not post to GL. Use false for No, true for Yes.

Reference Number

A reference number for the invoice

1234
Record No

A Summary RECORDNO for the invoice.

12345
Ship To Contact Name

The name of the contact to ship to. This should be an existing contact in Intacct.

Bob Johnson
Term Name

Payment term, this should be a previously created term

Net 30
Example Payload for Create Invoice
Loading…

Create Project

Creates a new project. | key: createProject

InputNotesExample
Additional Fields

Additional fields that are not covered by the standard inputs.

{
  "customerId": "cust001",
  "projectManagerEmployeeId": "emp123",
  "externalUserId": "ext456",
  "salesContactEmployeeId": "sales789",
  "referenceNo": "ref987",
  "userRestrictions": "None",
  "transactionRules": [
    "Rule1",
    "Rule2"
  ],
  "primaryContactName": "John Doe",
  "billToContactName": "Jane Smith",
  "shipToContactName": "Bob Brown",
  "paymentTerms": "Net 30",
  "billingType": "Time and Materials",
  "beginDate": "2023-01-01T00:00:00.000Z",
  "endDate": "2023-12-31T23:59:59.999Z",
  "departmentId": "dept001",
  "locationId": "loc001",
  "classId": "class001",
  "attachmentsId": "att001",
  "billableEmployeeExpense": true,
  "billableApPurchasing": true,
  "currency": "USD",
  "salesOrderNo": "SO12345",
  "purchaseOrderNo": "PO54321",
  "purchaseOrderAmount": "50000",
  "purchaseQuoteNo": "PQ12345",
  "contractAmount": "100000",
  "laborPricingOption": "Standard",
  "laborPricingDefaultRate": "150",
  "expensePricingOption": "Standard",
  "expensePricingDefaultRate": "50",
  "apPurchasingPricingOption": "Standard",
  "apPurchasingPricingDefaultRate": "30",
  "budgetedBillingAmount": "120000",
  "budgetedCost": "90000",
  "budgetedDuration": "12 months",
  "glBudgetId": "gl12345",
  "invoiceMessage": "Thank you for your business",
  "invoiceCurrency": "USD",
  "customFields": [
    [
      "customField1",
      "value1"
    ],
    [
      "customField2",
      42
    ]
  ]
}
Connection

The Sage Intacct connection to use.

Invoice with Parent

Use false for No, true for Yes. (Default: false)

false
Parent Project ID

Parent project ID for the to-be-created object.

21-1234
Project Category

Project category for the to-be-created object.

Contract
Project Description

Project description for the to-be-created object.

This is a sample project
Project ID

Unique ID for the project. Required if company does not use document sequencing, or you can provide a value to use instead of the document sequence value.

21-1234
Project Name

Project name for the to-be-created object.

Sample Project
Project Status

Project status for the to-be-created object.

In Progress
Project Type

Project type for the to-be-created object.

Type 1
Status

Use false for Inactive, true for Active. (Default: true)

true
Example Payload for Create Project
Loading…

Create Vendor

Creates a new vendor. | key: createVendor

InputNotesExample
ACH Banking

ACH bank account and routing details.

Active Status

When true, the record is active and available for use. When false, the record is inactive.

Attachments ID

Id of an attachment group of one or more supporting files

ATT-001
Comments

Additional comments

Company Name

Name of the company

Acme Corporation
Connection

The Sage Intacct connection to use.

Contact Details

Address, phone, email, and other contact channel details.

Credit Limit

Credit limit amount

50000
Custom Fields

Custom field names and values as defined for this object

[["fieldName1",123],["fieldName2","someStringValue"],["fieldName3",{"key":"value"}]]
Default Currency

Default currency code

USD
Excluded From Contact List

When true, this contact will be excluded from contact lists and searches. When false, the contact appears in all lists.

Form 1099

Form 1099 tax reporting details.

GL Accounts

GL group, default expense GL account, and offset GL account numbers.

Location Assigned Account No Displayed On Check Stub
Name

First, middle, and last name with prefix.

One Time

One time. Use false for No, true for Yes. If you want to simplify your vendor list page by displaying only your regularly-used vendors, we recommend you select this option for vendors that you use only once or just occasionally. These vendors will not appear in the vendor list page unless you click Include one-time use at the top of the list page, in which case, you'll see all your vendors regardless of frequently of use.

On Hold

When true, the account is placed on hold and transactions are suspended. When false, the account operates normally.

Parent Vendor IDVENDOR-PARENT-001
Payment Settings

Payment method, terms, and notification preferences.

Print Name As

Determine the format the name should be printed.

John A. Doe
Restricted Department

Restricted department IDs. Use if OBJECTRESTRICTION is Restricted

Restricted Location

Restricted location ID. Use if OBJECTRESTRICTION is Restricted

Restriction Type

Type of restriction

Tax Information

Tax ID, taxable status, and tax group.

Vendor Account NoVEND-ACC-001
Contact Roles

Primary, pay-to, and return-to contact assignments.

Vendor ID

Unique ID for the vendor. Required if company does not use document sequencing, or you can provide a value to use instead of the document sequence value.

VENDOR-001
Vendor NameAcme Supplies Inc.
Vendor Type IDTYPE-001
Example Payload for Create Vendor
Loading…

Delete Object

Deletes different objects in Sage Intacct. | key: deleteObject

InputNotesExample
Connection

The Sage Intacct connection to use.

Keys

A key or comma-separated list (123,456) of keys (RECORDNO's) to delete

123
Object

Type of object to delete

Example Payload for Delete Object
Loading…

Get AP Payment

Retrieve a single AP Payment. | key: getApPayment

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Record No

The unique record number identifier

12345
Example Payload for Get AP Payment
Loading…

Get AR Adjustment

Retrieve a single AR Adjustment. | key: getARAdjustment

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Record No

The unique record number identifier

12345
Example Payload for Get AR Adjustment
Loading…

Get AR Adjustment Line

Retrieve a single AR Adjustment Line. | key: getARAdjustmentLine

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Record No

The unique record number identifier

12345
Example Payload for Get AR Adjustment Line
Loading…

Get AR Advance

Retrieve a single AR Advance. | key: getARAdvance

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Record No

The unique record number identifier

12345
Example Payload for Get AR Advance
Loading…

Get AR Payment

Retrieve a single AR Payment. | key: getArPayment

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Record No

The unique record number identifier

12345
Example Payload for Get AR Payment
Loading…

Get Bill

Retrieve a single bill. | key: getBill

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Record No

The unique record number identifier

12345
Example Payload for Get Bill
Loading…

Get Contact

Retrieve a single contact. | key: getContact

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Record No

The unique record number identifier

12345
Example Payload for Get Contact
Loading…

Get Customer

Retrieve a single customer. | key: getCustomer

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Record No

The unique record number identifier

12345
Example Payload for Get Customer
Loading…

Get Invoice

Retrieve a single invoice. | key: getInvoice

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Record No

The unique record number identifier

12345
Example Payload for Get Invoice
Loading…

Get Project

Retrieve a project by record number. | key: getProject

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Record No

The unique record number identifier of the project to retrieve.

12345
Example Payload for Get Project
Loading…

Get Vendor

Retrieve a single vendor. | key: getVendor

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Record No

The unique record number identifier

12345
Example Payload for Get Vendor
Loading…

Query and List Records

Lists specified criteria based on a query. | key: queryAndList

InputNotesExample
Connection

The Sage Intacct connection to use.

Field

Field to retrieve, use * for all fields

*
Object Name

Name of the object to query. Possible values are: VENDOR, APBILL, APPYMT, ARPYMT, ARADJUSTMENT, ARADJUSTMENTITEM, ARADVANCE, etc.

VENDOR
Query

Query filter expression to filter the records

VENDOR.CREDITLIMIT > 10000
Example Payload for Query and List Records
Loading…

Raw Request

Send raw HTTP request to Sage Intacct | key: rawRequest

InputNotesExample
Connection

The Sage Intacct connection to use.

Data

The raw XML function to execute. Add the structure as per the Sage Intacct API documentation. For the provided default example, see the Query and List Contacts function. Authentication is already handled by the action.

<query>
<object>CONTACT</object>
<select>
    <field>RECORDNO</field>
    <field>CONTACTNAME</field>
</select>
</query>
Array JSON Nodes

Always put child nodes from XML in an array. If toggled off, an array is created only if there is more than one. Use this when 'Response Type' is set to 'JSON'.

true
Header

A list of headers to send with the request. <strong>Note:</strong> Sage Intacct API is XML based. Content-Type: 'application/xml' header is already added.

User-Agent: curl/7.64.1
Max Retry Count

The maximum number of retries to attempt. Specify 0 for no retries.

0
Response Type

The type of data format expected in the response. Select 'JSON' for JSON format or 'XML' for raw XML text.

json
Retry On All Errors

If true, retries on all erroneous responses regardless of type. This is helpful when retrying after HTTP 429 or other 3xx or 4xx errors. Otherwise, only retries on HTTP 5xx and network errors.

false
Retry Delay (ms)

The delay in milliseconds between retries. This is used when 'Use Exponential Backoff' is disabled.

0
Timeout

The maximum time that a client will await a response to its request

2000
Use Exponential Backoff

Specifies whether to use a pre-defined exponential backoff strategy for retries. When enabled, 'Retry Delay (ms)' is ignored.

false
Example Payload for Raw Request
Loading…

Update AR Adjustment

Update an existing AR Adjustment. | key: updateARAdjustment

InputNotesExample
Action

Action. Use Draft or Submit. (Default: Submit)

Additional XML Tags

Additional XML tags that might not be covered by the standard inputs.

<basecurr>USD</basecurr>
              <exchratedate>
                <year>2021</year>
                <month>09</month>
                <day>12</day>
              </exchratedate>
              <exchrate>1.23</exchrate>
    
Adjustment Number

AR Adjustment ADJUSTMENTNO to update.

AR Adjustment Line Items

AR Adjustment LINEITEMS to update. Each item must be wrapped in <updatelineitem></updatelineitem> or <lineitem></lineitem> tags.


  <updatelineitem line_num="1">
    <glaccountno>4000</glaccountno>
    <amount>100.25</amount>
    <memo>line 1</memo>
    <locationid>L100</locationid>
    <departmentid>D200</departmentid>
  </updatelineitem>
  <lineitem>
    <glaccountno>4000</glaccountno>
    <amount>20.99</amount>
    <memo>add a new line</memo>
    <locationid>L100</locationid>
    <departmentid>D200</departmentid>
  </lineitem>
Connection

The Sage Intacct connection to use.

Currency

AR Adjustment CURRENCY to update.

USD
Customer ID

AR Adjustment CUSTOMERID to update.

CUST-12345
Date Created

AR Adjustment DATECREATED to update.

12/06/2023
GL Date Posted

AR Adjustment DATEPOSTED to update.

12/06/2023
Description

AR Adjustment DESCRIPTION to update.

Office supplies for Q1 2024
Exchange Rate Type

AR Adjustment EXCHRATETYPE to update.

Intacct Daily Rate
Invoice Number

AR Adjustment INVOICENO to update.

1234
Record Number

AR Adjustment RECORDNO of bill to update.

123
Example Payload for Update AR Adjustment
Loading…

Update AR Advance

Update an existing AR Advance. | key: updateARAdvance

InputNotesExample
Additional XML Tags

Additional XML tags that might not be covered by the standard inputs.

<PRBATCH>123456</PRBATCH>
              <PRBATCHKEY>123456</PRBATCHKEY>
              <DOCNUMBER>123456</DOCNUMBER>
              <DESCRIPTION>Advance Description</DESCRIPTION>
              <CURRENCY>USD</CURRENCY>
              <BASECURR>USD</BASECURR>
              <EXCH_RATE_DATE>
                <year>2021</year>
                <month>09</month>
                <day>12</day>
              </EXCH_RATE_DATE>
              <EXCH_RATE>1.23</EXCH_RATE>
              <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
              <SUPDOCID>123456</SUPDOCID>              
              
AR Advance Items

AR Advance ARADVANCEITEMS to update. <strong>Note:</strong> To add an advance line, supply all the original lines along with the new one. To delete a line, supply only the lines that you want to keep. To modify a line, supply all the original lines and change the field values you want.

<ARADVANCEITEM>
        <ACCOUNTNO>4055</ACCOUNTNO>
        <ACCOUNTLABEL>Misc Sales</ACCOUNTLABEL>
        <TRX_AMOUNT>1000</TRX_AMOUNT>
        <LOCATIONID>CA</LOCATIONID>
      </ARADVANCEITEM>
Connection

The Sage Intacct connection to use.

Financial Entity

AR Advance FINANCIALENTITY to update.

1020
Payment Date

AR Advance PAYMENTDATE to update.

09/12/2021
Payment Method

AR Advance PAYMENTMETHOD to update.

Cash
Receipt Date

AR Advance RECEIPTDATE to update.

09/12/2021
Record No

AR Advance RECORDNO to update.

12345
Undeposited Account No

AR Advance UNDEPOSITEDACCOUNTNO to update.

1020
Example Payload for Update AR Advance
Loading…

Update Contact

Update an existing contact. | key: updateContact

InputNotesExample
Active Status

When true, the record is active and available for use. When false, the record is inactive.

Company Name

Name of the company

Acme Corporation
Connection

The Sage Intacct connection to use.

Contact Details

Address, phone, email, and other contact channel details.

Contact Name

Full name of the contact

John Doe
Name

First, middle, and last name with prefix.

Print Name As

Determine the format the name should be printed.

John A. Doe
Tax Information

Tax ID, taxable status, and tax group.

Example Payload for Update Contact
Loading…

Update Customer

Updates an existing customer in Intacct. The customer is identified by the customer ID. | key: updateCustomer

InputNotesExample
Active Status

When true, the record is active and available for use. When false, the record is inactive.

Attachments ID

Id of an attachment group of one or more supporting files

ATT-001
Billing and Delivery Preferences

Payment term, delivery method, default invoice message, and shipping method.

Comments

Additional comments

Company Name

Name of the company

Acme Corporation
Connection

The Sage Intacct connection to use.

Contact Details

Address, phone, email, and other contact channel details.

Credit Limit

Credit limit amount

50000
Contact Roles

Primary, bill-to, and ship-to contact assignments.

Customer ID

Unique ID. Required if company does not use document sequencing, or you can provide a value to use instead of the document sequence value.

CUST-12345
Customer Name

Customer name

Global Tech Solutions
Customer Type ID

Identifier for the type of customer

TYPE-001
Custom Fields

Custom field names and values as defined for this object

[["fieldName1",123],["fieldName2","someStringValue"],["fieldName3",{"key":"value"}]]
Default Currency

Default currency code

USD
Excluded From Contact List

When true, this contact will be excluded from contact lists and searches. When false, the contact appears in all lists.

GL Accounts

GL group, offset AR GL account, and default revenue GL account numbers.

Name

First, middle, and last name with prefix.

One Time

One time. Use false for No, true for Yes. If you want to simplify your customer list page by displaying only your regularly-used customers, we recommend you select this option for customers that you use only once or just occasionally. These customers will not appear in the customer list page unless you click Include one-time use at the top of the list page, in which case, you'll see all your customers regardless of frequency of use.

On Hold

When true, the account is placed on hold and transactions are suspended. When false, the account operates normally.

Parent Customer ID

Identifier of the parent customer

CUST-PARENT-001
Print Name As

Determine the format the name should be printed.

John A. Doe
Print Options

Document template assignments for invoices, quotes, orders, and adjustments.

Resale Number

Resale certificate number for tax-exempt purchases

RSL-123456
Restricted Department

Restricted department IDs. Use if OBJECTRESTRICTION is Restricted

Restricted Location

Restricted location ID. Use if OBJECTRESTRICTION is Restricted

Restriction Type

Type of restriction

Sales Rep Employee ID

Employee ID of the sales representative

EMP-001
Tax Information

Tax ID, taxable status, and tax group.

Territory ID

Identifier for the territory

TERR-001
Example Payload for Update Customer
Loading…

Update Invoice

Updates an invoice. | key: updateInvoice

InputNotesExample
Attachments ID

Id of an attachment group of one or more supporting files

ATT-001
Connection

The Sage Intacct connection to use.

Contact Name

Full name of the contact

John Doe
Currency and Exchange Rate

Base currency, transaction currency, and exchange rate details.

Customer ID

Unique ID. Required if company does not use document sequencing, or you can provide a value to use instead of the document sequence value.

CUST-12345
Custom Fields

Custom field names and values as defined for this object


  <customfield>
    <customfieldname>MYCUSTOMFIELD</customfieldname>
    <customfieldvalue>MYCUSTOMFIELDVALUE</customfieldvalue>
  </customfield>
  
Date Created

Invoice date creation date

12/06/2023
Date Due

Due date. Required if not using termname.

12/06/2023
GL Date Posted

Invoice General Ledger posted date

12/06/2023
Description

The description of the invoice.

Some description
Invoice Line Items

To update an existing line use <updatelineitem></updatelineitem> otherwise to create a new line item use <lineitem></lineitem> instead.You can mix types in the array.

https://developer.intacct.com/api/accounts-receivable/invoices/#create-invoice-legacy
Invoice Number

Invoice number

1234
Record Number

Invoice RECORDNO to update

123
Reference Number

A reference number for the invoice

1234
Term Name

Payment term, this should be a previously created term

Net 30
Example Payload for Update Invoice
Loading…

Update Project

Updates an existing project. | key: updateProject

InputNotesExample
Additional Fields

Additional fields that are not covered by the standard inputs.

{
  "customerId": "cust001",
  "projectManagerEmployeeId": "emp123",
  "externalUserId": "ext456",
  "salesContactEmployeeId": "sales789",
  "referenceNo": "ref987",
  "userRestrictions": "None",
  "transactionRules": [
    "Rule1",
    "Rule2"
  ],
  "primaryContactName": "John Doe",
  "billToContactName": "Jane Smith",
  "shipToContactName": "Bob Brown",
  "paymentTerms": "Net 30",
  "billingType": "Time and Materials",
  "beginDate": "2023-01-01T00:00:00.000Z",
  "endDate": "2023-12-31T23:59:59.999Z",
  "departmentId": "dept001",
  "locationId": "loc001",
  "classId": "class001",
  "attachmentsId": "att001",
  "billableEmployeeExpense": true,
  "billableApPurchasing": true,
  "currency": "USD",
  "salesOrderNo": "SO12345",
  "purchaseOrderNo": "PO54321",
  "purchaseOrderAmount": "50000",
  "purchaseQuoteNo": "PQ12345",
  "contractAmount": "100000",
  "laborPricingOption": "Standard",
  "laborPricingDefaultRate": "150",
  "expensePricingOption": "Standard",
  "expensePricingDefaultRate": "50",
  "apPurchasingPricingOption": "Standard",
  "apPurchasingPricingDefaultRate": "30",
  "budgetedBillingAmount": "120000",
  "budgetedCost": "90000",
  "budgetedDuration": "12 months",
  "glBudgetId": "gl12345",
  "invoiceMessage": "Thank you for your business",
  "invoiceCurrency": "USD",
  "customFields": [
    [
      "customField1",
      "value1"
    ],
    [
      "customField2",
      42
    ]
  ]
}
Connection

The Sage Intacct connection to use.

Invoice with Parent
Parent Project ID

Parent project ID for the to-be-updated object.

21-1234
Project Category

Project category for the to-be-updated object.

Contract
Project Description

Project description for the to-be-updated object.

This is a sample project
Project ID

Project ID to update.

21-1234
Project Name

Project name for the to-be-updated object.

Sample Project
Project Status

Project status for the to-be-updated object.

In Progress
Project Type

Project type for the to-be-updated object.

Type 1
Status
Example Payload for Update Project
Loading…

Update Vendor

Updates an existing vendor. | key: updateVendor

InputNotesExample
ACH Banking

ACH bank account and routing details.

Active Status

When true, the record is active and available for use. When false, the record is inactive.

Attachments ID

Id of an attachment group of one or more supporting files

ATT-001
Comments

Additional comments

Company Name

Name of the company

Acme Corporation
Connection

The Sage Intacct connection to use.

Contact Details

Address, phone, email, and other contact channel details.

Credit Limit

Credit limit amount

50000
Custom Fields

Custom field names and values as defined for this object

[["fieldName1",123],["fieldName2","someStringValue"],["fieldName3",{"key":"value"}]]
Default Currency

Default currency code

USD
Excluded From Contact List

When true, this contact will be excluded from contact lists and searches. When false, the contact appears in all lists.

Form 1099

Form 1099 tax reporting details.

GL Accounts

GL group, default expense GL account, and offset GL account numbers.

Location Assigned Account No Displayed On Check Stub
Name

First, middle, and last name with prefix.

One Time

One time. Use false for No, true for Yes. If you want to simplify your vendor list page by displaying only your regularly-used vendors, we recommend you select this option for vendors that you use only once or just occasionally. These vendors will not appear in the vendor list page unless you click Include one-time use at the top of the list page, in which case, you'll see all your vendors regardless of frequently of use.

On Hold

When true, the account is placed on hold and transactions are suspended. When false, the account operates normally.

Parent Vendor IDVENDOR-PARENT-001
Payment Settings

Payment method, terms, and notification preferences.

Print Name As

Determine the format the name should be printed.

John A. Doe
Restricted Department

Restricted department IDs. Use if OBJECTRESTRICTION is Restricted

Restricted Location

Restricted location ID. Use if OBJECTRESTRICTION is Restricted

Restriction Type

Type of restriction

Tax Information

Tax ID, taxable status, and tax group.

Vendor Account NoVEND-ACC-001
Contact Roles

Primary, pay-to, and return-to contact assignments.

Vendor ID

Unique ID for the vendor. Required if company does not use document sequencing, or you can provide a value to use instead of the document sequence value.

VENDOR-001
Vendor NameAcme Supplies Inc.
Vendor Type IDTYPE-001
Example Payload for Update Vendor
Loading…

Changelog

2026-09-01

Restructured action inputs into structured objects for an improved configuration experience.

  • Create Vendor and Update Vendor group their inputs into Name, Contact Details, Tax Information, ACH Banking, Payment Settings, Form 1099, Contact Roles, and GL Accounts
  • Create Customer and Update Customer group their inputs into Name, Contact Details, Tax Information, Contact Roles, Print Options, GL Accounts, and Billing and Delivery Preferences
  • Create Contact and Update Contact group their inputs into Name, Contact Details, and Tax Information
  • Create Invoice and Update Invoice group their currency inputs into Currency and Exchange Rate

2026-05-05

Added New and Updated Records polling trigger to detect newly created or modified records across Vendor, Customer, AP Bill, AR Invoice, Contact, Employee, Project, and AR Payment, with server-side filtering so only changed records are returned each poll

2026-04-30

Updated spectral version

2026-03-31

Various modernizations and documentation updates

2026-03-24

Wired inputs to inline data sources for improved selection across multiple actions: Vendor ID now uses the Select Vendor inline data source

  • Customer ID now uses the Select Customer inline data source
  • Contact Name now uses the Select Contact inline data source
  • Invoice Number now uses the Select Invoice inline data source
  • Project ID now uses the Select Project inline data source

2025-12-19

Enhanced Get Contact, Update Contact, Get Customer, Update Customer, Get Invoice, Update Invoice, Get Project, Update Project, Get Vendor, and Update Vendor actions with inline data source support for improved usability:

  • The Record No input in Get Contact, Get Customer, Get Invoice, Get Project, and Get Vendor now displays available records directly in the dropdown
  • The Contact Name input in Update Contact now displays available contacts directly in the dropdown
  • The Customer ID input in Update Customer now displays available customers directly in the dropdown
  • The Record Number input in Update Invoice now displays available invoices directly in the dropdown
  • The Project ID input in Update Project now displays available projects directly in the dropdown
  • The Vendor ID input in Update Vendor now displays available vendors directly in the dropdown

2025-06-27

Added actions for AR advances and AR adjustments to enhance accounts receivable management