...
You can access the Chart of Accounts setup through the page: Administration > Chart of Accounts.
Creating a configuration to load the trial balance.
For this training we are using the SQL-Lite database to load the trial balance. An ODBC connection (ApliqoFPM_ODS) has been setup to connect to the SQL-Lite database. A turbo Integrator (TI) process: }APQ.C3.FIN.Cub.GeneralLedgerTB.Update.From.ODS_Demo has been written to load the trial balance the Apliqo_Demo sqlite database.
...
Running the Training - Load TB a configuration
In this section we are going run the configuration to load the Trial Balance for the 2022 financial year.
...
Exercise: Run the configuration process for 2023 financial year.
Checking the Trial Balance
Select the Actuals tab on the Data Processing page.
Trial Balance Report
The Total GL Account row for the Consolidation Measure TB should be zero. TB means the account movement have been loaded in Debits (+) and Credits (-). The 9999 Total - All Account TB will not balance here because the signs movements of the liabilities, revenue and expenses accounts have not changed. There is no data in the Process Data (GL) as we have not run the GL Update process.
...
TB Check popup.
The TB Check is an overview of the trial balance check for all companies for the financial year. If company fails the trial balance check, a warning message will show the number of months that failed. Click on the company to view the discrepancies for that company. You have the following resolve the discrepancies.
...
Click on Check Again to check the Trial Balance again.
...
Account Mapping
New accounts can be added by the custom process that loads the Trial Balance. Here is a snippet of code to add an account to the rollup.
...
On the left select the account that is 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 add the selected accounts to the account node. Click on Sync to commit the changes to the FIN OCoA dimension.
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. Run the round trip from the financial year 2022 and 2023.
...
Checking for Errors
The configuration will stop when it encounters an error. Click on the
icon to see the error message.
...
To fix this error go to back the Chart of Account page. Select the Fixed Account tab. Find the C3_EQ_RETAIN fixed account. Map it to the account 2360_N. Sync the Operational CoA to apply the changes to the FIN OCoA dimension. Once that is done re-run the Training - Load TB configuration. Confirm there are no errors.
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 financial year 2023
Load the Trial Balance for period 2023-Jan to 2023-Mar for Company 1000.
More Information
...