Solver has created a robust integration to the Intacct Accounting System. Solver's Intacct connector allows users to create integrations, pulling data from Intacct into the Solver Cloud or Private Host solution. This article will detail the minimum configuration required in Intacct for a successful integration.
Note: the information discussed in this article is relevant to Solver Cloud and Private Host customers. Customers using the BI360 4x Product must reference information here on the 4x Intacct Connector.
This article is broken down into the following sections:
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.
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
Solver Intacct Connector and 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.
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.
Solver's Intacct connector requires a user with the following minimum permissions.
- 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.
- 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".
- Click on the Applications tab to expand the drop down menu > Click Company > Select the Company option under Configuration.
- You should now be in the Company information tab, click the Edit button on the top right corner.
- Click into the Security tab, scroll down to Web Services authorizations.
- 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.
- 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
- Log into Intacct.com as an administrator.
- Click on Applications > Company > Users or Web Service Users depending on your configuration.
- 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.
- A popup will appear showing the permissions of this user and/or the roles this user has been assigned to.
- 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.
- 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.
- 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.
- 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.
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.
- Log into Intacct as an Admin account.
- Navigate to Company > General Ledger > Setup > Reporting Periods
- 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:
- Bring in the sum of all transactions for prior years into the report to do the calculation.
- Find where the beginning balance object is in Intacct (if it exists) and bring that into the Data Warehouse.
- Create a business rule that calculates beginning balance for the year.
- Manually add the beginning balance to the Data Warehouse.
- Create an integration to the GLACCOUNTBALANCE object only.
- Load the beginning balance to scenario OBA (Opening Balance Actuals).
- 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.
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
For instructions on how to troubleshoot common integration errors, please refer to ➜ this article.
Intacct Specific Errors
PL0400005: You do not have permission for API operation READ_BY_QUERY on objects
The web service user being used in the integration does not have the appropriate permissions, in this case, to ReportingPeriod.
Ensure you have View and List permissions enabled to Reporting Periods.
- Navigate to Roles or Web Services users in the Company module, depending on your organization's security setup.
- Click on View Permissions & Roles.
- Scroll down to the General Ledger module, look for Reporting Periods, click Edit tp add View and List permissions.
- Save the changes, navigate back to the Cloud portal, you should now be able to get past the error.
Cannot insert the value NULL into column 'Account'
Cause and Resolution
By default, Intacct has two system objects for accounts, GLACCOUNT and STATACCOUNT. If stat accounts are being used in the Intacct system, you will need to create another integration to bring in all of the stat accounts.