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.

Image Modified

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.

The [TB Check] popup should not be orange. If it is orange, then it will show the number of companies and months that are out balance.

For each company and month you can set a tolerance or override the difference. A global TB Tolerance can also be set. Click on [Check Again] to check the Trial Balance again.

Account Mapping

New account can be created by the Trial Balance load process. Any new accounts can mapped in the [Unmapped Accounts] popup.

On the left select the account to be mapped. On the right, select the node in the chart of accounts the selected account is to be mapped to. Click on the > icon to map the selected accounts. Click on SYNC to commit the changes to the FIN OCoA dimension.

This can also be done in the Apliqo Settings / Chart of Account / Operational CoA.

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.

Re-run the configuration and confirm there are no steps in error.

Checking the General Ledger

Select the Actual tab on the Data Processing page.

Confirm the Cube (Measure) is General Ledger (OPV) and Show Accounts under is 9999 Total.

Exercise

Load the Trial Balance for period 2023-Jan to 2023-Mar for Company 1000.

See Related: Loading Financial Data