Intacct to Adaptive: 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 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 |
Reporting Book | Optional | Selection | Select from Default, Cash, Accrual or ID* |
Reporting Book ID* | Optional | Free Text | Will only display if ID is selected in the previous step. A Book ID will need to be entered as free text |
Start Account | Required | Drop-down menu | Select from the Intacct list of GL Accounts |
End Account | Required | 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 | Free Text or Column Selection Options | Select text to enter free text for Level (e.g. Balance Sheet). Select Column to select a Sage Intacct column (Department ID, Department Title, Location ID, 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.