Intacct to Adaptive: Income Statement and Balance Sheet
Prerequisites
In order to fully utilize the Workflow Wizard, credentials will need to be set up beforehand. Both Sage Intacct and Workday Adaptive Planning credentials will need to be set up first.
Configuration
The Workflow Wizard can be accessed by navigating to Workflows and clicking the Wizard button
Choose Type
Option | Required/ Optional | Type | Description |
|---|---|---|---|
Source | Required | Drop-down menu | Select Intacct |
Destination | Required | Drop-down menu | Select Adaptive |
Type | Required | Drop-down menu | Select Income Statement and Balance Sheet |
2. Intacct Setup
Option | Required/ Optional | Type | Description |
|---|---|---|---|
New Datasource Name | Required | Free Text | Enter a name for the Data Source. By default this is Intacct but it can be overwritten with any free text |
Intacct Credential | Required | Drop-down menu | Select the source credential that has been set up beforehand (see: Sage Intacct) |
Start Date | Required | Drop-down menu | Select from the list of Relative Dates |
End Date | Required | Drop-down menu | Select from the list of Relative Dates |
Book Id | Optional | Drop-down menu | Select from the Intacct list of Book Id’s |
Start Account | Optional | Drop-down menu | Select from the Intacct list of GL Accounts |
End Account | Optional | Drop-down menu | Select from the Intacct list of GL Accounts |
Dimensions | Optional | Multi-select drop-down menu | Select from the Intacct list of dimensions |
3. Query Setup
Option | Required/ Optional | Type | Description |
|---|---|---|---|
Level | Required | Drop-down menu | Select from Department Id, Department Name, Location Id or Location Name |
4. Adaptive Setup
Option | Required/ Optional | Type | Description |
|---|---|---|---|
Adaptive Credential | Required | Drop-down menu | Select the source credential that has been set up beforehand (see: Workday Adaptive Planning) |
Version Name | Required | Drop-down menu | Select from the various Adaptive versions |
5. Review
The final step will display all of the elements that will get created in DataBlend based on options selected
in the prior steps. Click Create to build all of these elements.
Once everything is created, the final Workflow is displayed. From here, the Workflow can be executed, scheduled or favorited.