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/. 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/).

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.

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.

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.

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.

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.