CONN Cloud Getting Started: QuickStart for Intacct

Summary:

This article details steps to set up and configure QuickStart for Intacct. QuickStart is a wizard-driven process to assist you in quickly setting up an integration from your organization's Intacct implementation to Solver Cloud. 

Article Sections:

• More Information
  
  • Requirements
  • Features
  • Data Delivery Services (DDS)
  • Configuration
  • Authorizing Solver's SenderID
  • Configure User Permissions
  • Setting Reporting Periods to Budgetable
  • Quickstart Set-up
• 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 them 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 an 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 that 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 that 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 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. 

QuickStart Setup

Before beginning QS, make sure you have completed all the pre-configuration steps documented above. 

Using QuickStart begins with you receiving your Solver Cloud invite email. Follow the instructions to be logged in for the first time. 

You have logged in as an administrator. On the left-hand navigation bar, you will see all the applications you have purchased including the Data Warehouse. Select this option: 

1. You first need to create Periods. Follow these steps to create your Financial Calendar in Data Warehouse.
   • You will need to create, at a minimum, the prior year and current fiscal year with the Data Warehouse. 
2. Once completed, navigate to Data > Integrations > Add New.
   
3. You will now find the Intacct Connector
   
4. Click on the Intacct connector and choose QuickStart
   
5. Click Authenticate to begin the login process. As mentioned above, make sure that you have popup blockers disabled in your browser's settings for the Solver Cloud site.
6. Click Continue. 
7. On the next page, choose the dimensions that you'd like to bring into the Solver Cloud application and click Continue.
   
8. Login
9. The next page loads with a hierarchal view of a balance sheet and income statement report in the main grid with your account categories on the right-hand side. Drag the account category from the right-hand side into the appropriate position in the main grid. Complete this exercise for all account categories in use. 
   • It is strongly recommended to do the account category mapping exercise. By completing the account category mapping exercise, users get access to the Template Marketplace where "ready to use" reports are available for download. 
   
   
10. The next screen prompts users to create a job that will:
    • Execute daily
    • Distribute a success or failure notification to the user configuring this job
    • Click Add Another Email to add more users to the notification emails.
11. The last page is a summary page detailing what will be configured. Click Run Now to complete the configuration and begin the data load process. 
    

This completes the QuickStart process. You have now successfully begun a process to load last year to the current period GL Summary and Detail data. On the Jobs page, you can view the status of the data load. Once complete, you can navigate to the Template Marketplace to install and run reports off your Business Central data in Solver Cloud. 

Properties:

Cloud