General Ledger Analysis Codes

There are three levels of analysis in the General Ledger: Branch, Account and Subaccount. Use General Ledger Analysis Codes to define additional levels of analysis for more detailed reporting — for example, Branch-Account-Subaccount-Analysis1-Analysis2

Use GL analysis codes when you enter transactions. They are not available on any master files — for example, GL Control accounts, Stock Item records. If you can enter or edit a GL account on a transaction, you should also be able to enter analysis codes.

The General Ledger Report Writer does not report on GL Analysis Codes. To report on them, use Clarity Reports.

Setting up GL Analysis Codes

Select Setup > Setup Analysis Codes to define the codes. If this menu option is not available, it must be added to the menu using the Menu Designer - Setup > Setup Menu or use Exo Business Configurator.

The current number of analysis codes in use displays. Enter the number of codes in the Proposed number of codes field. If this number is changes, you must update the database to recreate the GL Movements metadata. Exo Business closes automatically so you can run an update from Exo Business Configurator.

If the Accept valid analysis codes only option is not selected, you can enter any number as a GL analysis code.

If the option is selected, you must set up codes on the Validation tab:

Click New to create a code, then enter a descriptive name. Codes are automatically numbered sequentially starting at 1.

The Validation tab contains a numbered column for each analysis code. For example, if you selected to use two codes on the General tab, there are two columns on the Validation tab. For each code, enter Y or N in each column to indicate whether you can use the code.

In the example above, you can use codes 1 and 2 (Internal and External) for Analysis Code 1 or Analysis Code 2, while you can use code 3 (Special) only for Analysis Code 2. This GL code is valid: 00-0100-01-1-2.

However, this GL code is invalid, as code 3 displays in the Analysis Code 1 position: 00-0100-01-3-2.

Using GL Analysis Codes

Enter GL analysis codes by appending them to GL codes in the GL Code fields on transaction entry screens. GL analysis codes are separated by hyphens – for example, Branch-Account-Subaccount-Analysis1-Analysis2.