Sage Intacct

Sage Intacct is a provider of cloud-based accounting software which can provide real-time financial and operational insights, as well as the ability to automate critical processes.

Features

Supported deployment models

We support the SaaS Deployment model for the connector.

Setup guide

Follow our step-by-step Sage Intacct setup guide to connect Sage Intacct with your destination using Fivetran connectors.

Sync overview

• We store timestamp-based attributes as TIMESTAMP. Previously, we stored these attributes as VARCHAR in the destination.
• If you have previously synced a table with timestamp-based attributes, to ensure data integrity, drop the table from your destination and trigger a table re-sync.
• When you trigger re-sync, we soft delete the records of the parent table and hard delete the records of the child table before starting a re-sync.

NOTE: Resyncs will result in a large number of API calls to Sage Intacct, which may lead to additional charges at the source as per the Sage Intacct API pricing model.

Custom fields

We support custom fields for the SO_DOCUMENT and SO_DOCUMENT_ENTRY endpoints. To sync these fields, you must enable the SO_DOCUMENT_PARAMS endpoint.

Capture deletes

We use the Sage Intacct API to fetch the deleted records from the AUDIT_HISTORY object.

If you want the AUDIT_HISTORY object to capture the deletions of GL_BATCH transactions originating from subledgers, do the following:

1. Log in to your Sage Intacct account.
2. Go to General Ledger > Setup > Configurations.
3. Select the Enable auditing of transactions posted from subledgers checkbox.
4. Go to Platform Services
5. Under Custom Reports and Interactive Custom Reports sections, select List and View.

NOTE:

• We don't capture deletes for custom objects as the Intacct API does not offer a mechanism for this.
• We do not capture deletes for objects where the OBJECTKEY in the AUDIT_HISTORY response is not the same as the object's primary key.
• The AUDIT_HISTORY object does not provide any data related to the deletes in the GL_DETAIL table. Therefore, we do not capture deletes for the GL_DETAIL table.

Schema information

This schema applies to all Sage Intacct connectors.