> ## Documentation Index > Fetch the complete documentation index at: https://www.domo.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # Sage Intacct Connector **Important:** Sage Intacct imposes a "concurrency limit" on API requests to their systems. Most customers are allowed 2 concurrent requests. However, depending on your service level agreement with Sage Intacct, you may have a greater concurrency limit. If you have a service level agreement that allows for a greater number of concurrent connections, you will need to go into your Domo account in the account center (https\://\[yourinstance].domo.com/datacenter/accounts) and update the value in your Sage Intacct account. Otherwise, Domo will simply default your account to the normal limit of 2 concurrent requests imposed by Sage Intacct. For more information, refer to the API documentation [https://developer.intacct.com/api/general-ledger/trial-balances/](https://developer.intacct.com/api/general-ledger/trial-balances/). This change will improve performance and help increase the stability of the Sage Intacct Connector. Overall, this should have very little impact on your DataSets, however, the downside of this change is that you may see an increase in the amount of time it takes to get your data into Domo if you do not update your account to reflect the appropriate limit. Additional steps can be taken to mitigate any potential slowdown by scheduling your Sage Intacct DataSets in such a way that they do not overlap each other. ## Intro Sage Intacct helps you manage financials on your own terms with cloud-based accounting software. With Domo, stakeholders can visualize Sage Intacct data together with data from any other system in a real-time dashboard. That means fewer reports for finance and better insights all around.\ Once your data is in Domo, connect easily to your data and create powerful, dynamic visualizations. Get the up-to-date information you need to make smart decisions on cashflow, ledgers, accounts receivable, accounts payable, journals, P\&L, and more. Get real-time alerts via email and text when Sage Intacct metrics hit your predefined levels. Use Domo's Sage Intacct Connector to retrieve data relating to customers, accounts, invoices, payments, expenses, and the like. To learn more about the Sage Intacct API, visit their page ([https://developer.intacct.com/](https://developer.intacct.com/)). You can connect to your Sage Intacct account in the Data Center. This topic discusses the fields and menus that are specific to the Sage Intacct Connector user interface. To add add DataSets, set update schedules, and edit DataSet information, see [Adding a DataSet Using a Connector](/docs/s/article/360042926274). **Note:** The Sage Intacct Connector only imports standard reports. Within your Sage Intacct account you can create custom reports, set them to run on a schedule and have them delivered in a CSV format to a cloud storage service. Sage Intacct supports Dropbox, Box, Google Drive, and Amazon S3.Once delivered there customers can use the relevant Domo connector to import the custom report from the cloud storage service into Domo. | | | | --------------------------------------------------------- | -------------------------------------------------------------------------------------------------------- | | **Primary Use Cases** | This connector is appropriate for pulling financial reporting and accounting, sales, and inventory data. | | **Primary Metrics** | - Cashflow - Ledgers - Accounts receivable - Accounts payable - Journals - Profits and loss | | **Primary Company Roles** | - CFO - Accountant - Sales - Inventory | | **Average Implementation Time** | Connector runtimes vary based on data, but generally it should take between 2 and 8 hours. | | **Ease of Use (on a 1-to-10 scale with 1 being easiest)** | 7 | ## Best Practices Keep date ranges reasonable. If you only need the last quarter, do the last quarter; if you need the last three years, do all three years. For Custom report, this Connector only supports 'current month' and 'current year' as the reporting period values. There might be a possibility of having other/additional supported values for Reporting Period. Contact Sage Intacct for other possible Reporting Duration values for filtering the data. ## Prerequisites To connect to your Sage Intacct account and create a DataSet, you must have the following: * The user ID for your Sage Intacct account. This is the same user ID you use to sign into the Sage Intacct cloud ERP software. * The password for your Sage Intacct account. This is the same password you use to sign into the Sage Intacct cloud ERP software. * Your Sage Intacct company ID. This ID is usually different for sandbox and production accounts. To locate the Company ID in Sage Intacct, hover over **Company** and click **Company Info**. **Company ID** is found in the **ID** field. * (Optional) You can also provide a Location ID. This may help narrow your data request to a specific location. To locate the location ID in Sage Intacct, hover over **Company** and click **Locations**. Select a **Location ID** from the report. * (Optional) Max Concurrent Connections. This is a number value for the maximum number of concurrent connections that Sage Intacct allows for your account. If you have increased your API rate limits with Sage Intacct, you can provide how many concurrent connections you are allowed here. * Additionally, the Customer may need to add "Domo" as an **authorized sender ID** in their company configurations Security tab. To obtain Sage Intacct Web Services credentials, contact your Sage Intacct account representative. ## Connecting to Your Sage Intacct Account This section enumerates the options in the **Credentials** and **Details** panes in the Sage Intacct Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in great detail in [Adding a DataSet Using a Connector](/docs/s/article/360042926274). ### Credentials Pane This pane contains fields for entering credentials to connect to your Sage Intacct account. The following table describes what is needed for each field: | Field | Description | | -------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | User ID | Enter your Intacct user ID. See "Prerequisites" for more details. | | Password | Enter your Intacct password. See "Prerequisites" for more details. | | Company ID | Enter your Intacct company ID. This ID is usually different for sandbox and production accounts. | | Location ID | Enter your Intacct location ID. This may help you narrow your data request to a specific location. | | Max Concurrent Connections | Enter the number value for the maximum number of concurrent connections that Intacct allows for your account. If you have increased your API rate limits with Intacct, specify how many concurrent connections you are allowed here. | Once you have entered valid Sage Intacct credentials, you can use the same account any time to create a new Sage Intacct DataSet. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Manage Connector/Adapter Accounts](/docs/s/article/360042926054). ### Details Pane This pane contains a primary **Reports** menu, along with various other menus which may or may not appear depending on the report type you select.

Note: There might be a possibility of having other/additional supported values for Reporting Period. Contact Sage Intacct for other possible Reporting Duration values for filtering the data.

{" "} Report{" "}

{" "}

Report	Description
Account Group	Receives data about Intacct Account Group accounting reports.{" "}
AP Account Label	Receives data about Intacct Accounts Payable Account Label accounting reports.{" "}
AP Adjustment	Receives data about Intacct Accounts Payable Adjustment accounting reports. Date Filter is required for this report.{" "}
AP Bill	Receives data about Intacct Accounts Payable Bill accounting reports. Date Filter is required for this report.{" "}
AP Bill Detail	Receives data about Intacct Accounts Payable Bill Detail accounting reports.{" "}
AP Payment	Receives data about Intacct Accounts Payable Payment accounting reports. Date Filter is required for this report.{" "}
AP Payment Request	Receives data about Intacct Accounts Payable Payment Request accounting reports. Date Filter is required for this report.{" "}
AP Term	Receives data about Intacct Accounts Payable Term accounting reports.{" "}
AR Account Label	Receives data about Intacct Accounts Receivable Account Label accounting reports.{" "}
AR Adjustment	Receives data about Intacct Accounts Receivable Adjustment accounting reports. Date Filter is required for this report.{" "}
AR Invoice	Receives data about Intacct Accounts Receivable Invoice accounting reports. Date Filter is required for this report.{" "}
AR Invoice Detail	Receives data about Intacct Accounts Receivable Invoice Detail accounting reports.{" "}
AR Payment	Receives data about Intacct Accounts Receivable Payment accounting reports. Date Filter is required for this report.{" "}
AR Payment Summary	Receives data about Intacct Accounts Receivable Payment Summary accounting reports. Date Filter is required for this report.{" "}
AR Term	Receives data about Intacct Accounts Receivable Term accounting reports.{" "}
AR Transaction Definition	Receives data about Intacct Accounts Receivable Transaction Definition accounting reports.{" "}
Bank Account	Receives data about Intacct Bank Account accounting reports.{" "}
Bill	Receives data about Intacct Bill accounting reports.{" "} Date Filter is required for this report.{" "}
Class	Receives data about Intacct Class accounting reports.
Company Information	Receives data about Intacct Company Information accounting reports.{" "}
Contact	Receives data about Intacct Contact accounting reports.
Contact Tax Group	Receives data about Intacct Contact Tax Group accounting reports.{" "}
CSN History	Receives data about Intacct CSN History accounting reports.{" "}
Cust GL Group	Receives data about Intacct Cust General Group accounting reports.{" "}
Customer	Receives data about Intacct Customer accounting reports.
Customer Ach Info	Receives data about Intacct Customer Ach Info accounting reports.{" "}
Customer Bank Account	Receives data about Intacct Customer Bank Account accounting reports.{" "}
Customer Charge Card (Deprecated)	Receives data about Intacct Customer Charge Card accounting reports.{" "}
Customer P Package	Receives data about Intacct Customer P Package accounting reports.{" "}
Custom Reports	Receives data about Intacct Custom accounting reports.
Department	Receives data about Intacct Department accounting reports.
Employee	Receives data about Intacct Employee accounting reports.
Expense Report	Receives data about Intacct Expense Report accounting reports.{" "}
Expense Report Summary	Receives data about Intacct Expense Report Summary accounting reports.{" "}
Expense Types	Receives data about Intacct Expense Types accounting reports.{" "}
GL Account	Receives data about Intacct General Account accounting reports.{" "}
GL Account Balance	Receives data about Intacct General Account Balance accounting reports.{" "}
GL Account Group	Receives data about Intacct General Account Group accounting reports.{" "}
GL Account Group Member	Receives data about Intacct General Account Group Member accounting reports.{" "}
GL Batch	Receives data about Intacct General Batch accounting reports.{" "} Date Filter is required for this report.{" "}
GL Budget	Receives data about Intacct General Budget accounting reports.{" "}
GL Budget Item	Receives data about Intacct General Budget Item accounting reports.{" "}
GL Account Category	Receives data about Intacct General Account Category accounting reports.{" "}
GL Entry	Receives data about Intacct General Entry accounting reports.{" "} Date Filter is required for this report.{" "}
GL Transaction	Receives data about Intacct General Transaction accounting reports. Date Filter is required for this report.{" "}
IC Item	Receives data about Intacct Inventory Control Item accounting reports.{" "}
IC Transaction	Receives data about Intacct Inventory Control Transaction accounting reports. Date Filter is required for this report.{" "}
IC Transaction Definition	Receives data about Intacct Inventory Control Transaction Definition accounting reports.{" "}
Invoice	Receives data about Intacct Invoice accounting reports.{" "} Date Filter is required for this report.{" "}
Item GL Group	Receives data about Intacct Item General Group accounting reports.{" "}
Item Tax Group	Receives data about Intacct Item Tax Group accounting reports.{" "}
Journal	Receives data about Intacct Journal accounting reports.
Location	Receives data about Intacct Location accounting reports.
Location Entity	Receives data about Intacct Location Entity accounting reports.{" "}
Location Group	Receives data about Intacct Location Group accounting reports.{" "}
PO Price List	Receives data about Intacct Purchase Order Price List accounting reports.{" "}
PO Transaction	Receives data about Intacct Purchase Order Transaction accounting reports. Date Filter is required for this report.{" "}
PO Transaction Definition	Receives data about Intacct Purchase Order Transaction Definition accounting reports.{" "}
Pricelist Item	Receives data about Intacct Pricelist Item accounting reports.{" "}
Product Line	Receives data about Intacct Product Line accounting reports.{" "}
Project	Receives data about Intacct Project accounting reports.
Renewal Macro	Receives data about Intacct Renewal Macro accounting reports.{" "}
Reporting Period	Receives data about Intacct Reporting Period accounting reports.{" "}
Revenue Recognition Schedule	Receives data about Intacct Revenue Recognition Schedule accounting reports.{" "}
Revenue Recognition Schedule Entry	Receives data about Intacct Revenue Recognition Schedule Entry accounting reports.{" "}
Revenue Recognition Template	Receives data about Intacct Revenue Recognition Schedule Template accounting reports.{" "}
Sales Document	Receives data about Intacct Sales Document reports.
Sales Document Detail	Receives data about Intacct Sales Document Detail reports.
Sales Document Subtotals	Receives data about Intacct Sales Document Subtotal reports.{" "}
Smart Event Log	Receives data about Intacct Smart Event Log reports.{" "} Date Filter is required for this report.{" "}
SO Price List	Receives data about Intacct Sales Order Price List accounting reports.{" "}
SO Transaction	Receives data about Intacct Sales Order Transaction accounting reports. Date Filter is required for this report.{" "}
SO Transaction Definition	Receives data about Intacct Sales Order Transaction Definition accounting reports.{" "}
SO Transaction Detail	Receives data about Intacct Sales Order Transaction Detail accounting reports.{" "}
Stat GL Account	Receives data about Intacct Stat General Ledger Account accounting reports.{" "}
Statistical Journal	Receives data about Intacct Statistical Journal accounting reports.{" "}
ST Kit Transaction	Receives data about Intacct Kit Transaction accounting reports.{" "} Date Filter is required for this report.{" "}
Subscription	Receives data about Intacct Subscription accounting reports.{" "}
Tax Detail	Receives data about Intacct Tax Detail accounting reports.
Tax Schedule	Receives data about Intacct Tax Schedule accounting reports.{" "}
Tax Schedule Detail	Receives data about Intacct Tax Schedule Detail accounting reports.{" "}
Tax Schedule Map	Receives data about Intacct Tax Schedule Map accounting reports.{" "}
Territory	Receives data about Intacct Territory accounting reports.
Transaction Currency	Receives data about Intacct Transaction Currency accounting reports. Date Filter is required for this report.{" "}
Unit of Measure	Receives data about Intacct Unit of Measure accounting reports.{" "}
Vendor GL Group	Receives data about Intacct Vendor General Group accounting reports.{" "}
Vendor	Receives data about Intacct Vendor accounting reports.{" "} Date Filter is required for this report.{" "}
VSOE Item Pricelist	Receives data about Intacct Vendor-Specific Objective Evidence Item Pricelist accounting reports.{" "}
VSOE Pricelist	Receives data about Intacct Vendor-Specific Objective Evidence Pricelist accounting reports.{" "}
Warehouse	Receives data about Intacct Warehouse accounting reports.

{" "}

{" "} Reporting Period{" "}

{" "} Select a reporting period name, if applicable.{" "}

{" "} Number of Months Back{" "}

{" "} Enter the number of months of historical data to retrieve.{" "}

{" "} Date Filter{" "}

{" "} Select whether you want to filter results by the date of creation or the date when they were last modified.{" "}

{" "} Page Size{" "}

{" "} Select the page size. It must be between 10 and 250. The page size number limits how much data is consumed from the API at once. If you are receiving an error, try decreasing the page size.{" "}

{" "} Custom Report Name{" "}

Enter the custom report name.

{" "} Filter Data{" "}

{" "} Select this checkbox if you'd like to filter your custom report by date. If your report supports date filtering, you'll be able to select options to set the date range.{" "}

{" "} Filter Arguments{" "}

{" "} Filter Arguments give you options to filter the custom report by a specific or relative date range, or by a reporting period such as 'Current Month' or 'Current Year'. If your custom report does not support date filters, this drop down will be empty.{" "}

{" "} Module Key{" "}

Select a module key.

{" "} Date{" "}

{" "} Specify whether the report's data is for a single date or a range of dates.{" "}

Single date : Choose a specific day for which you would like to receive the data by entering a number relative to today. For example, enter 0 for today, 1 for yesterday, or 7 for 7 days ago.{" "}
Date range: When you select the date range option, the option to select the custom start and end dates appears.{" "}
- Start Date : Select the start date for your report. You can either select a specific start date or a relative start date.{" "}
- End Date : Select the end date for your report. You can either select a specific end date or a relative end date.{" "}

{" "} Start Date - Relative - Days Back

{" "} Choose the day for which you would like to start receiving the data by entering a number relative to today. For example, enter 1 for yesterday, 7 for 1 week ago, and 30 for 1 month ago.{" "}

{" "} End Date - Relative - Days Back

{" "} Choose the day for which you would like to stop receiving data by entering a number relative to today. For example, enter 1 for yesterday, 7 for 1 week ago, and 30 for 1 month ago.{" "}

{" "} Single date - Relative - Days Back

{" "} Specify the number of days before today for which you would like to receive the data. For example, enter 0 for today or 7 for seven days ago.{" "}

{" "} Reporting Period Name

Select a reporting period name (optional).

{" "} Show starting and ending balance debits and credits

{" "} Show beginning and ending balance debits and credits. Set to True to include these values in the results.{" "}

{" "} Show zero balance accounts

{" "} Set to True to include accounts with a zero balance in the results.{" "}

{" "} Expand department detail

{" "} Set to True to include expanded department details in the results.{" "}

{" "} Expand location detail

{" "} Set to True to include expanded location details in the results.{" "}

{" "} Reporting book ID

{" "} Enter the reporting book ID. Use ACCRUAL or CASH, depending on your company configuration.{" "}

{" "} Date Type

Select the date type to use for filtering:

Created Date filters records based on when the item was created.
Modified Date filters records based on when the item was last modified.
Batch Date filters records based on the item's batch date.

{" "} Reset Schema

Select whether to refresh the schema.

Warning: Refreshing the schema can result in data loss or changes to column data types based on the data returned by the Intacct API.

We recommend selecting Refresh Schema only when necessary, and then switching back to Keep Schema{" "} after the schema update is complete.

{" "} Batch Size (rows per page)

Specify the number of rows to retrieve per API call (1-1000). The default value is 1000. If you experience connection-related extraction failures, reduce this value. Smaller batch sizes can improve reliability but may increase processing time.{" "}

### Other Panes For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Connector](/docs/s/article/360042926274). ## Troubleshooting * The biggest pitfall with this connector is credentials. Often, the username or password is wrong and the connector will fail. See Prerequisites to get the right information. * If you cannot authenticate, even with correct credentials, you may need to enable the XML Gateway API for your company. To do this, follow these instructions: 1. Log into Sage Intacct. 2. Mouse over the **Company** tab. 3. Click the plus button next to **Users.** 4. Fill in the fields as follows: * **User ID**: Enter xml\_gateway. * **Last Name:** Enter Gateway. * **First Name:** Enter XML. * **Email address:** Enter your own email address. * **User Type**: Select **Business**. * **Admin Privileges**: Select **Full**. 5. Check the box that reads "Keep my password until I reset it."

6. Do one of the following: * If you use roles... 1. Open the **Roles Information** tab. 2. Click in row 1 to show a dropdown menu. 3. Select the role that should have full access in your system (most likely **Admin**). * If you are not using roles... 1. Save your changes. 2. Give the user the proper subscriptions. 7. Click **Save**. This sets up the user. Sage Intacct now sends an email with a temporary password to the email address you specified. You should now be able to use this user to log into the Connector interface in Domo.