General Ledger > GL Structure Query

GL Structure Query

You use this program to query financial information by currency, account type and financial year, including comparisons to various years or budgets.

The information is provided in the form of a treeview showing the sections hierarchy, and a chart showing the values for the selected section. You can also drill down to transactions at ledger code level.

Period end closing balances can be queried at section level and fiscal year and compared to other fiscal or budget years.

Toolbar and menu

Menu options Description
Preferences The selections you make against the Preferences menu are automatically retained when exiting the program.
Auto Preview Transactions Select this to automatically display transaction information in the Ledger Transactions listview.
Transaction Options Select this to indicate the periods for which you want to view transactions in the Ledger Transactions listview.
Sort Lowest Level by Name Select this to view the account codes in the treeview by account description rather than by the default account code.
Balances at Each Period Select this to view the data as the actual balances at each period.
Movements Between Each Period Select this to view the data as the movements between each period.
Include Purchase Commitment This option is only enabled if you selected the option: Purchase commitment required (GL Structure Definition).
Toolbar options Description
Currency code If you used the GL Alternative Currency Setup program to create General Ledgers in alternate reporting currencies, then you can use this option to select the currency in which to view the data.
Account type Values are held by account type. Select the required account type from the Account type selection box. The net difference between revenue and expense is displayed if Net Income is selected from the Account type selection box. When querying ledger code details the Account type is disabled.
Financial year Select the required financial year from the Financial year selection box.
Compare to Optionally, select the comparison fiscal or budget year from the Compare to selection box
Current financial year This field displays the year in which your general ledger is currently in.
Current period This field displays the period in which your general ledger is currently in.

GL Structure

You use this treeview to select the section or ledger code for which you want to view the information.

In addition, you can post to the highlighted ledger code in the treeview, by typically using your right mouse button to select the Post To This Account option. Selecting this option loads the GL Journal Entry program.

Section information is displayed in the treeview hierarchy in section code sequence. To view the lowest level in the treeview (this would be the full ledger code node) in the sequence of the description or name of the section code, select the Sort Lowest Level by Name option from the Preferences menu.

[Note]

  • The values for budgets for capital, liability and revenue account types are shown as negative values even if the budgets were originally entered as positive values. This is to ensure that budget and history values are compared using the same sign.

  • Although the treeview displays all available sections defined in the GL Structure Definition program, details are only displayed for the sections to which you have access (GL Structure Access).

Movement Graph

This window displays the graph for the section or ledger code you selected in the treeview.

Periods for branch

Details that can be viewed include the following:

  • Commitment

    This only applies if the preference: Include Purchase Commitment is selected.

Ledger Information

Details that can be viewed in this pane include the following:

  • Ledger code

    • Ledger Code Quick View
    • Query (see GL Query)
    • Ledger Codes Setup (see General Ledger Codes)
    • Multimedia

Period selected

View the source journals of a highlighted transaction.

Notes and warnings

Program access

  • This program can only be accessed if your General Ledger codes are structured and the option: Section analysis required is enabled (GL Structure Definition).

Restrictions and limits

  • The data presented in this query is influenced by your selection at the following options set in the (GL Structure Definition) program:

    • Budget analysis required

      When enabled, the selected financial year can be compared to the budget this year, the budget next year, or one of the eight alternate budgets in the bar graph and listview for the section.

    • Purchase commitment required

      When enabled, purchase commitments are displayed in the bar graph and listview for the section.

  • The data presented in this query is derived from special analysis tables that are automatically maintained by the system. The totals for each General Ledger account section are stored in the Section Analysis table by section and are updated each time a posting to the General Ledger is processed. The totals are not accumulated at the time of running the query.

    Although the analysis tables are automatically maintained by the system as postings occur, the tables can be rebuilt at any time by selecting the Rebuild Analysis function in the GL Structure Definition program. The values held in the analysis tables are held in the local and all alternate currencies.

    The following programs do not currently update the analysis tables and the Rebuild Analysis function of the GL Structure Definition program needs to be run after these programs are used:

    • GL Period End - Year end function only
    • Import GL Budgets
    • GL Global Budget Maintenance
    • GL Alternative Currency Setup
    • GL Copy, Merge and Delete
    • GL Control Record Update

    With the exception of the GL Control Record Update and GL Copy, Merge and Delete programs, the above programs display an option to update GL analysis tables, which, if selected, will load the Rebuild Analysis History screen after the program has completed its task.