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 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.
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 account flags can be set for the Operational Chart of Account.