Introduction
The GL Explorer gives you a detailed drill-down of the figures contained in Financial Reports including:
- Profit & Loss Reports
- Balance Sheets
- Trial Balance
- Extended Business Analysis (BI Code) Reports
The GL Explorer’s layout and sort-order sequencing reflect each report layout. Each level is progressively more detailed.
Each GL Account Code belongs to a GL Sub-category, that in turn belongs to a GL Category. Both the GL Category and Sub-Category have a sort order that determines how they will appear in the Report. General Ledger Codes appear in numerical or alphabetic sequence within General Ledger Sub-Category.
The GL Account Codes link to a version of the Transaction Browser displaying all transactions making up a particular GL Account Code Amount. These transactions then further link to accounts like Supplier, or Bank.
See:
General Ledger Overview (7.0) - AIQ Academy
GL Explorer (11.4) - AIQ Academy
Query Tools (GL Explorer, Transaction browser) (1.6) - AIQ Academy
Consolidated Reporting (12.3) - AIQ Academy
How do I Use & Customise the Transaction Browser?
Selecting Enquiry Parameters
- Go to General > General Ledger Accounts > GL Explorer.
- In the top part of the GL Explorer, select your parameters:
- Profit and Loss, Balance Sheet, Trial Balance: Select which type of Report you wish to examine.
- View: Select either Period values or Year to Date values.
- Dataset: Select Actual, Budget, or Revised Budget values. Underneath the Dataset parameters you can view the Period and Year selection for that Dataset.
- Compare with: Select either Actual, Budget, and Revised Budget, together with the date parameters.
-
Analyse By: This is for BI Code Report based Enquiries. You can examine individual Locations, Divisions, or Departments, depending on what you have previously set up.
In the example below, the Company has a GL Category called Project, with GL Sub-Categories for Project Code, Activity (e.g. “Mechanical”, “Electrical”, “Chemical”, etc.), and Project Manager. This facilitates P & L reporting. Selecting a GL Category from the upper Analyse By dropdown determines which GL Sub-Categories appear in the lower dropdown. 
3. Click Apply Filter to display the chosen values.
Click Refresh at the bottom of the Window to update your data as other users could have added new transactions to the system.
The system automatically saves the last set of Parameters you used and will display them next time you open the GL Explorer. However, if you continue with that set of Parameters, remember to click Refresh to get the latest data.
See:
How do I Implement Extended Business Analysis?
How do I Implement Job or Project Analysis using Extended Business Analysis?
Using the Drill Down Facilities
Drilling Down to Transaction-level in Trading Entities
Click the arrows to Drill down to the next level, from General Ledger Category to General Ledger Sub-Category, and then to General Ledger Account Code. Click the arrows again to exit from the detailed level and return to the summary level.
Export on the bottom left-hand corner of the GL Explorer Window lets you export your results as word, excel, or PDF.
Drilling Down to Transaction-level in Consolidation Entities
In a Consolidation Entity, you can drill down to the transactions in both the Sub-Consolidation and Trading Entities.
The balance appearing for the Trading Entities is in the currency of that entity, not the currency of the Consolidation Entity.
Viewing Transactions in the Transaction Browser
Click any of the references to open the Transaction Browser Window and view the list of transactions making up that Amount.
Open any of the transactions and edit them by clicking the pencil icon if necessary.
See:
How do I Use & Customise the Transaction Browser?
How Do I Amend, Cancel or Delete Transactions?