--- title: "Connect Pigment with Sage Intacct" slug: "connect-sage-intacct" description: "Learn how to connect Sage Intacct with Pigment to import data seamlessly, ensuring secure access and efficient data management." tags: ["Data Import", "Importing Exporting Data", "Pigment Integration", "Sage Intacct"] updated: 2025-05-30T13:37:40Z published: 2025-08-22T11:22:15Z --- > ## Documentation Index > Fetch the complete documentation index at: https://kb.pigment.com/llms.txt > Use this file to discover all available pages before exploring further. # Connect Pigment with Sage Intacct ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image(24).png) This article explains how to connect Sage Intacct with Pigment to import data into a Pigment Block. > [!WARNING] > **⚠️****Important** > > To perform the sync setup, you will need a Full Admin access to Sage Intacct. ### Step 1: Subscribe to Web Services Follow these steps to activate the **Web Services**option: 1. Log into Sage Intacct. 2. Go to **Company**, then****select **Subscriptions**. 3. In the Applications tab, find **Web Services**and toggle **Subscribe**to **On**. You can ignore the warning message about additional charges. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/e08779eb-b583-454e-b015-05b09335e20f.png) ### Step 2: Allow Pigment’s Sender Id and IP Address **IP Address** If your organization enforces the IP address check to connect to Sage Intacct, you must add Pigment’s IP Address to Sage Intacct’s allowed list. For more information, see Intacct’s [documentation](https://www.intacct.com/ia/docs/en_US/help_action/Company/Company_setup/Company_Information/Security/company-sign-in-settings.htm#EnforceIPaddressfilters). 1. Go to **Company**, then**Company Info**. 2. Click **EDIT**. 3. Click the **Security** tab. 4. Go to the field labeled **Enforce IP address filters** and click the **Edit**icon. 5. Add the following IP addresses: - `35.242.251.111` - `34.145.54.113` - `34.163.209.119` - `35.202.142.12` **Sender ID** Add Pigment’s Sender ID to the list of authorized Web Services. For more information, see Intacct’s [documentation](https://www.intacct.com/ia/docs/en_US/help_action/Company/Company_setup/Company_Information/Security/company-web-services-authorizations.htm). 1. Go to **Company,**then**Company Info**. 2. Select **EDIT** 3. Select the **Security**tab 4. Go to the **Web Services authorizations** section and add the following Sender ID : `PigmentMPP` ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/8229f1a7-b197-490a-af41-848f231c1cfa.png) ### Step 3: Create a Web Service User with Role-Based Security Pigment requires a **Web Service user** to connect to your Sage Intacct account. This user needs the required Permission and access. This section describes how to: - Create and configure a new **Role**. - Create and configure a new**Web Service User**. This user’s credential will be shared later with Pigment. **Create a Role** 1. Go to **Company**, then **Roles**. 2. Select **Add**. 3. Input the following values in the **Name** and **Description**fields: `Pigment` - `Role used for Pigment Web Service user.` 4. Select **Save**. 5. Select each Application/Module, select **Read Only**from the top right, and save changes. 6. Select **Save**. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/ee9f96b9-67bc-4410-aaf9-d039eb228a8a.png) ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/9f549992-0b27-4835-8e31-f83d511a3dde.png) **Create Web Service User** 1. Go to **Company**, then**Web Service User**. 2. Select **New**. 3. Input the following values for these fields: a. User ID: `Pigment` b. Last name: `Pigment` c. First name: `Connector` d. Email address: the email of the user which will receive this account credentials. e. Make sure the User Type = **Business User** 4. Select the **Roles information** tab and select the Role created in the prior step. 5. Select **Save** You can ignore the warning message about additional charges for creating a user. ## Setting up the Sage Intacct Connector within Pigment In your Pigment Workspace, go to **Settings,**then**Integrations**and select **+ Add** on the Sage Intacct integration. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/d5b5dcbf-a74d-4453-8514-2ce2aae9c8ff.png) | Select **Setup a Connection** and then complete the following fields: - **Name**: Give a name to your connection. - **Application Access**: List the application which will be allowed to use this connection. - **Company ID**: Enter the company ID you want to connect with. - **User ID**: Paste the User ID of the Web Service User. - **Password**: Paste the password generated for the Web Service User. Select **Setup**to finish the setup. | ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/5e36870b-b1e8-4258-b967-deae0be8c967.png) | | --- | --- | ## Load data into Pigment using the connector When the Sage Intacct Connection is configured, open an Application that the connection is available on and open the **Import Data** interface for the object you want to import data into. For example, if you were importing data into a Transactions List, you would open up that list and then select **Import and Download**and then**Import**. Instead of **Upload file**, select the **Integration**option. From here, select the **Sage Intacct**Connection you just configured. > [!NOTE] > ℹ️ **Note** > > If you don’t see the connection, go to **Integrations**, and verify that the Application is on the Application Access list. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/95d0179e-3e73-4767-84fc-3a975c89631f.png) The Sage Intacct connector allows you to load data into Pigment with two different modes: - Data Source - Custom Report ### Data source mode The Data Source mode allows the end-user to select one of the following Primary data sources: - General Ledger / Accounts - General Ledger / Account balances > [!NOTE] > ℹ️ **Note** > > For this Primary data source, you need to include PERIOD as a parameter in the **Define query to filter data** field, using the **Advanced Filter**option. For example: `PERIOD = 'Month Ended June 2024'` - General Ledger / Details - General Ledger / Journal entries - General Ledger / Journal entry lines - Revenue / Recognition schedules - Revenue / Recognition schedule entries - Contract / Billing schedules - Contract / Billing schedule entries - Contract / Expense schedule - Contract / Expense schedule entries - Contract / Revenue schedules - Contract / Revenue schedule entries - Bills - Contracts - Customers - Departments - Employees - Entities - Invoices - Locations - Vendors When you have selected a Primary data source, you need to specify the fields you want to load from the source. Some fields can have similar names because they are referring to a different parent object. Use the field description to ensure the parent object is correct one. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/96237118-a7a7-4971-b76f-f3cc8661ff4e.png) ### Filtering data before Importing: You can configure a connector to only load a part of the Data source. Select **Add Filter**and select the **Basic Filter**option. Then fill in the conditions you want to filter on. For more complex filtering conditions (for example, filters using OR condition) you can also use the **Advanced filter** option. Write a SQL-like filtering condition based on the Fields ID. The following operators are supported: `<`, `>`, `>=`, `<=`, `=`, `like`, `not like`, `in`, `not in`, `IS NOT NULL`, `IS NULL`, `AND` ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/1326ee0b-8ea8-4224-8d86-1663e5aeaaaf.png) ### Custom Report mode If you want to simply load a Report result into Pigment you might find it easier to use the **Custom Report.**With this mode, you configure all the report options in Sage Intact and type the report name in Pigment. > [!WARNING] > **⚠️****Important** > > The performance of the Custom report mode is way more limited than the Data source mode. Only use this mode for small data loads, that have fewer than 10 000 lines of data. ## Before you import Before importing, be aware of a limitation in Sage Intacct’s query process. If any changes are made to the source data in Sage Intacct while an import is running, the imported data might include duplicate rows or even miss some rows. This issue tends to happen more often when you're importing over 2,000 records. This is due to how the **Offset** parameter works during queries. To avoid issues, follow these recommendations: - Avoid making changes to the source data in Sage Intacct while an import is in progress. - After the import, check the data for any duplicates or missing rows. ## Scheduling of import Similar to other Native connectors, you can automate data load through the [Schedule Import interface.](/v1/docs/schedule-imports) However, we strongly recommend avoiding certain hours due to the timing of Sage Intacct maintenance. > [!CAUTION] > **🛡️ Warning** > > Don’t run jobs between 12:00am and 2:00am Pacific. This is the preferred timing for Sage Intacct maintenance, Scheduled imports might fail if triggered to run while Sage Intacct is not available for maintenance.