In this section we are going to build the Operational Chart of Accounts from CSV/Excel file.
Menu: Apliqo Settings / Chart of Accounts
Building the OCoA from the Staging Cube
In this example we are going to load the OCoA Sample file into the Chart of Accounts.
We have only load the Operational Chart of Account to the Chart of Account staging area. Before we can build the FIN OCoA dimension we need to map some Fixed Accounts.
Set the Fixed Accounts
There are a number of fixed accounts that can be mapped to your Opearational Chart of Account. They are used for reporting, planning and KPI calcuations. Before we can build the FIN OCoA dimension the compulsory Fixed Accounts must be mapped to the Operational Chart of Account.
Once the Fixed Accounts have been mapped the Automation can be set to Update Flags in the Operational Chart of Accounts.