Menu: Apliqo Settings / Data Integration / Data Processing / Automation

In previous sections we have set up the Company, Cost Center, Customer, and Account dimensions. In this section we are going to load the trial balance from and external source to the FIN General Ledger cube.

For this training we are using the demo.sqlite database to load the trial balance. An ODBC connection has been setup to connect to the demo.sqlite database. A turbo Integrator (TB) process has been written to load the trial balance into Apliqo FPM.

Add the TI process to Data Intergration

Add the process ‘}APQ.C3.FIN.Cub.GeneralLedgerTB.Update.From.ODS_Training’ to the data Processing automation.

Copy a Configuration

Apliqo FPM come shipped with a number of predefined configurations. In this section we are going to copy an existing configuration and add the step created above to the configuration.

Run a Configuration

In this section we are going run the configuration to load the Trial Balance for the 2022 financial year.

Run the configuration process for 2023 financial year.

Checking the Trial Balance

Select the Actual tab on the Data Processing page.

Confirm the Cube (Measure) is Trial Balance (TB) and Show Accounts under is Total GL Accounts.

For the TB Check to pass the Total GL Account should be zero.

Load the General Ledger

Now the Trial Balance balances to zero we can load the General Ledger.

Click on the Automation tab and check the following step in Training - Load TB configuration.

Checking for Errors

The configuration will stop when it encounters an error. Click on the info icon to see the error.

To fix error go back the Operational Chart of Account map the Fixed Account, C3_EQ_RETAIN to account 2360_N. Remember to Sync the FIN OCoA dimension to apply the change. Once done re-run the Training - Load TB configuration.