In this section we are building the Operational Chart of Account dimension in Apliqo FPM. To start, access the Chart of Accounts setup through the page: Administration > Chart of Accounts.

Building the Management Trial Balance

Step 1: Loading the Management Trial Balance rollup

We are going to start building the Balance Sheet rollup excluding the natural accounts. You will need to download this Balance Sheet file to be uploaded in the walk through.

Click for a guided walkthrough.

Step 2: Adding the natural accounts from an ODBC source

Next, we are going to create an automation step that load the natural accounts from an ODBC source using the SQL query statement:

The query returns the natural accounts and their direct parent account code that is in the Balance Sheet rollup loaded in the previous section. The query includes the attribute information for the natural accounts.

Click for a guided walk through.

Step 3: Unwind the Business CoA rollup.

To allow for changes in the rollup we need to unwind the rollup before rebuilding the rollup for the data sources. In the above example we are updating the rolling in two automation steps. Each step can unwind the rollup however we only need to unwind the existing roll once. This is where order of the automation steps is important.

In the first step, Load Operational Chart of Account Hierarch, change the Rebuild Option parameter to be Unwind. The Unwind Consolidation parameter should be the top consolidation of the Business CoA in the Operational CoA. In this case 9999 - Total - All Accounts Total.

Subsequent automation steps should use the Rebuild Option parameter value of Add Component Only.