CONN Cloud Getting Started: Intacct Connector

Summary:

This article details Solver's robust integration to the Intacct Accounting System. Solver's Intacct connector allows users to create integrations, pulling data from Intacct into the Solver Cloud solution. This article details the minimum configuration required in Intacct for a successful integration. 

Note: the information in this article is relevant to Solver Cloud customers only.

Article Sections:

• More Information
  
  • Requirements
  • Features
  • Data Delivery Services (DDS)
  • Configuration
  • Authorizing Solver's SenderID
  • Configure User Permissions
  • Setting Reporting Periods to Budgetable
  • How to get Opening Balance Transactions in Intacct 
  • Checklist
  • Troubleshooting
• Properties

More Information:

Intacct performs maintenance every Friday from 7:30-11:30 PM Pacific time. Integrations may be impacted during this time and Intacct's maintenance may run longer than expected.

Reference Intacct's status page for more info.

Requirements

The following are requirements to use the Intacct Connector with Solver:

• Customer must have an active account with Intacct.
• Solver's Intacct connector does not include an Intacct user license for this. Please contact your Intacct system administrator to create this account.
• Please verify the allotted API limits your organization has. 
• Solver's Intacct connector and the speed at which you can load data into Solver are restricted by the terms of your Intacct purchase including the number of concurrent sessions your organization has access to.
• You MUST authorize Solver's SenderID to make requests to your company's data. Solver's senderID is "Solver" (no quotes). 
• General Ledger, including beginning balance, is available in Intacct's GLACCOUNTBALANCE endpoint. This endpoint requires that Reporting Periods are set to Budgetable.
  • Please contact your Intacct administrator for assistance in setting this up. 
  • If you choose not to make your Reporting Periods Budgetable, Solver provides business rules that can create General Ledger data from the General Ledger Detail data. 
• In order to connect to custom objects, the user will need to enable permissions for Custom Application.

At the end of this article, users can find a checklist to help you mark off each requirement of Solver's Intacct connector.

Features

Solver Cloud supports all financial and operational dimensions and transactional endpoints made available by Intacct. Additionally, not specifically documented in the Intacct API, Solver's Intacct API also supports:

• Custom Dimensions (UDDs)
• Custom Attributes

Intacct has deprecated endpoints but they are still available for selection. These endpoints include

• GLBUDGET
• BUDGETHEADER

These endpoints will not work and will return and error message referencing "...ReadByQuery failed".

The Intacct developer blog is a great place to keep track of supported Intacct features.

Data Delivery Services (DDS)

Data Delivery Services (DDS) is an Intacct add-on for organizations who have chosen this method to extract data from Intacct. DDS may be used in cases where: 

• Organizations are extracting large amounts of data that cannot be extracted by the API. 
• Extra only the transactions that have changed ("deltas") from the last DDS data pull.

Organizations who have purchased DDS from Intacct will need to use the Solver Gateway instead of the Solver Intacct Connector. Please contact your Solver salesperson or your partner for more information. 

Configuration

The screenshots and steps in the below section are from Intacct. These steps may change if Intacct has updated their interface. Please contact your Intacct administrator for assistance. 

Solver Support does not assist in the configuration of the Intacct Accounting system. 

User Account

Solver's Intacct connector requires a user with the following minimum permissions. 

1. Is a Web Service account.
   • A separate account is strongly recommended as a user may be set into a “LOCKEDOUT” state by Intacct if logging in from multiple locations.
2. Has View and List permissions to the necessary endpoints to be consumed by Solver's Intacct connector.

Authorizing Solver's SenderID

Solver's SenderID is "Solver" (no quotes) and is case sensitive. When typing this value into your web services authorization menu, make sure to type it in exactly as "Solver". 

1. Click on the Applications tab to expand the drop down menu > Click Company > Select the Company option under Configuration.
   
2. You should now be in the Company information tab, click the Edit button on the top right corner.
   
3. Click into the Security tab, scroll down to Web Services authorizations.
   
4. Click the Add button, enter the Sender ID, which would be Solver. Optionally, add a Description for the sender. 
   
   
   NOTE: Sender IDs are case sensitive and cannot be changed after the authorization is added.
   
5. Click on the Save button to save the changes.
   
   

This completes the process to whitelist Solver's SenderID within your Intacct System. 

Configure User Permissions

1. Log into Intacct.com as an administrator.
2. Click on Applications > Company > Users or Web Service Users depending on your configuration.
3. A listing of your users will appear. Find the user to be used with Solver Cloud and click on the View Permissions and Roles link under Permissions Report. This will bring up a window containing the permissions and roles that the user is associated to.
   
4. A popup will appear showing the permissions of this user and/or the roles this user has been assigned to.
5. Solver Cloud needs at a minimum "List" and "View" permissions to any field that will be brought into the application. Additional permissions can be added but are not needed for Solver Cloud. A web service only account is useful here where you can define these permissions.
6. Should you need to modify these permissions click on Company > Roles and select the role to be modified.
   
   • On the first page, fill out the role description if it has not been provided. This is optional. Click View Subscription.
7. On the next page, you will see the modules that this role has access to as indicated with a check mark. Click Permissions to see the specific permissions for that role.  
   
   • Company and General Ledger must be selected to load your GL data for Intacct via QuickStart
8. A popup will appear showing the permissions. As mentioned above, List and View are the required permissions for Solver Cloud. Here you can see an example setup for General Ledger. 
   
   Click Read More in the upper right hand corner as a a quick way to select all options. Review what has been enabled to ensure you are ok with what has been selected
   
   • In the Company object, make sure you select List and View for Account Periods as well, this is not selected by default when you choose Read Only
     
     

You have completed setting up a user for use with Solver Cloud. 

Setting Reporting Periods to Budgetable

In order to integrate with your General Ledger data, you must set Reporting Periods to Budgetable within Intacct. 

1. Log into Intacct as an Admin account.
2. Navigate to Company > General Ledger > Setup > Reporting Periods
   
3. In the grid of configured periods that have been created, click the checkbox to make a period Budgetable to enable Solver to bring in data associated to this period for the GLACCOUNTBALANCE object. This object is used to load in GL data including beginning balances.

At this point, you have completed all the Intacct Configuration steps to connect your Intacct account to Solver. 

How to Get Opening Balance Transactions in Intacct

Beginning balance can be found in the GLACCOUNTBALANCE object. There are a couple ways to accomplish this. You can either:

1. Bring in the sum of all transactions for prior years into the report to do the calculation.
2. Find where the beginning balance object is in Intacct (if it exists) and bring that into the Data Warehouse.
3. Create a business rule that calculates beginning balance for the year.
4. Manually add the beginning balance to the Data Warehouse.

  Solver’s recommendation:

1. Create an integration to the GLACCOUNTBALANCE object only.
2. Load the beginning balance to scenario OBA (Opening Balance Actuals).
3. The data mapping needs to be similar to GL/GL Detail, Category will also need to be mapped.

#2 is most common because set up simply requires the user to find the object in Intacct.

#3 is the next best step.

Prior to creating integrations, it is best to discuss the ideal setup with your consultant first to ensure a successful implementation as well as to eliminate any possible unforeseen issues.

Checklist

The below checklist includes a list of items that need to be configured in Intacct for a successful connection between Solver Cloud and Intacct. 

▢ Create a web service user in Intacct.

▢ Configure the web service user with appropriate permissions.

▢ Authorize Solver's SenderID - 'SOLVER'

▢ Set Reporting Periods to 'Budgetable' (to connect to GLACCOUNTBALANCE)

▢ Enable permissions for custom objects

Troubleshooting

For instructions on how to troubleshoot common integration errors, please refer to this article.  

Intacct Specific Errors:

Properties:

Cloud