Versions Compared

Version Old Version 21 New Version Current
Changes made by

Tom Williams

Emma Greenwood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The purpose of the GL Account Balances page is to show current balances for all General Ledger Accounts.

Insert excerpt
Def - General Ledger Account
Def - General Ledger Account
nopaneltrue
From this page, users can drill down to Account Balances by Period or the Journal history for a single GL Account.

Software Version: 20212023.0504.21 28 and newer

Table of Contents
typeflat

...

Filter ItemsDescription
Account Class

Insert excerpt
Inq - GL Account Class
Inq - GL Account Class
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank. If blank, this parameter is not used but if filled in then the data is limited based on the selection.

Insert excerpt
Def - GL Account Class
Def - GL Account Class
nopaneltrue

The lookup contains a list of all GL Account Classes.

Auto Hide Filters
Insert excerpt
Auto Hide Filters
Auto Hide Filters
nopaneltrue
Auto Refresh on Open
Insert excerpt
Auto Refresh on Open
Auto Refresh on Open
nopaneltrue
Balances Thru

Insert excerpt
Inq - As Of Date
Inq - As Of Date
nopaneltrue
This is a text box that is not required to return results. It defaults to the current date and works in conjunction with 'Date Option'. If the 'Date Option' is "GL Date", then a valid date is required. If the 'Date Option' field is "Fiscal Period", then this field must be in a format of "[Fiscal Period]-[Year]".

Category

Insert excerpt
Inq - GL Category
Inq - GL Category
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - General Ledger Account Category
Def - General Ledger Account Category
nopaneltrue

This lookup contains the values in the GLAccountClassCategory Enumeration Class.

  • Asset
  • Liability
  • Equity
  • Income Statement
Control Account Type

Insert excerpt
Inq - GL Control Account Type
Inq - GL Control Account Type
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Control Account
Def - Control Account
nopaneltrue

This lookup contains the values in the GLControlAcctType Enumeration Class.

Date Option

Used in conjunction with the 'Balances Thru' option to identify the date format. This is a single-select standard lookup that is required to return results. It defaults as "GL Date".

This lookup contains the values:

  • Fiscal Period - The date values must be entered as [2-digit GL Period]-[GL Year]. For example if you want period 5 from 2020 you would enter "05-2020".
  • GL Date - The dates must be in a valid date format.
GL Account

Insert excerpt
Inq - GL Account
Inq - GL Account
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank. If blank, this parameter is not used but if filled in then the data is limited based on the selection. 

Insert excerpt
Def - GL Account Description
Def - GL Account Description
nopaneltrue

The lookup contains a list of all GL Accounts.

Include

Insert excerpt
Inq - Include
Inq - Include
nopaneltrue

  • 0.00 Balance GL Accounts. Defaults as unselected to ensure that only GL Accounts with a non-zero balance are displayed.
  • Inactive GL Account. Defaults as unselected to ensure that only 'Active' GL Accounts are displayed.
Posting Type

Used to select one or more Posting Types. This is a multi-select standard lookup that is not required to return results. It defaults as blank. If blank, this parameter is not used but if filled in then the data is limited based on the selection.

This lookup contains the values in the GLAccountPostingType Enumeration Class.

  • Balance Sheet
  • Income Statement
Saved Searches
Insert excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue
Search

Insert excerpt
Search - Search Options
Search - Search Options
nopaneltrue

  • Account
    • Search a single value "1000"
    • Search a range of values "1000:2000” to return all Accounts between "1000-000-00" and "2000-000-00"
  • Account Class
  • Account Description
  • Category (Asset, Liability, Equity, or Income Statement)
  • Posting Type (Balance Sheet or Income Statement)

(lightbulb)  Please note the use of keywords for searching has not been implemented on this page. For example, to search by a specific Account Description, users may not prepend the search value with the text "Account Description: ". If you have an Account Description containing "Checking", simply enter "Checking" into the Search text box. Clicking Refresh will return all results where the value "Checking" is stored in any of the searchable fields.

...

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

  • IQ: Account Balance by Period: Opens the Account Balance by Period Inquiry for the selected GL Account(s) in a new tab
  • IQ: Journal Line History: Opens the Journal Line History Inquiry for the selected GL Account(s) in a new tab
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh

Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue

Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
Search Options
Insert excerpt
Search Options - Inquiry Grid 3.0
Search Options - Inquiry Grid 3.0
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Account

Insert excerpt
GL Account ID
GL Account ID
nopaneltrue
This field comes from the 'Account' field on the GL Accounts List View. Once saved, this field is not editable.

Insert excerpt
Def - GL Account ID
Def - GL Account ID
nopaneltrue

Database Field: ERPx_GLAccount.AccountNumber

Account Class

Insert excerpt
GL Account Class
GL Account Class
nopaneltrue
Account Classes are dependent on the 'Posting Type' and 'Category' that are selected. This field comes from the 'Account Class' field on the GL Accounts List View. It is always editable.

Insert excerpt
Def - GL Account Class
Def - GL Account Class
nopaneltrue

Database Fields: ERPx_GLAccountClass.ClassName, ERPx_GLAccount.AccountClassSK

Account Description

Insert excerpt
GL Account Description
GL Account Description
nopaneltrue
This field comes from the 'Account Description' field on the GL Accounts List View. It is always editable.

Insert excerpt
Def - GL Account Description
Def - GL Account Description
nopaneltrue

Database Field: ERPx_GLAccount.Description

Budget

Identifies the budget amount for each GL Account. This is a calculated field that is not editable and calculates totals differently for each GL Account Posting Type:

  • Balance Sheet Accounts: displays the budget amount for the Period based on the GL Period or GL Date selected. 

  • Income Statement Accounts: displays the summary of Periods 01 thru the period associated with the GL Period or GL Date selected.

Balance Displays the balance of all posted transactions for the GL Account as of the 'Balances' Thru' date. This field comes from the amounts on journal line entries created from posted transactions. This is a calculated field and not stored in the database.
Balances ThruIdentifies the cutoff transaction date to view GL balances that occur on and before this date. This field comes from the 'Balances Thru' in the Search Options. This is a calculated field and not stored in the database.
Category

Insert excerpt
GL Account Category
GL Account Category
nopaneltrue
Categories are dependent on the 'Posting Type' that is selected. This field comes from the 'Category' field on the GL Accounts List View. It is always editable. If edited on an existing GL Account, then the 'Account Class' field will be cleared.

Insert excerpt
Def - General Ledger Account Category
Def - General Ledger Account Category
nopaneltrue

Database Fields: ERPx_GLAccountClass.ClassName, ERPx_GLAccount.AccountClassSK

Control Account Type

Insert excerpt
GL Control Account Type
GL Control Account Type
nopaneltrue
This field comes from the 'Control Account Type' field on the GL Accounts List View. It is always editable.

Insert excerpt
Def - Control Account
Def - Control Account
nopaneltrue

Database Field: ERPx_GLAccount.GLControlAccountTypeEN

Posting Type

Identifies whether the GL Account is an Income Statement Account or a Balance Sheet Account. This field comes from the 'Posting Type' field on the GL Accounts List View. It is always editable. If edited on an existing GL Account, then the 'Category' and 'Account Class' fields will be cleared.

Insert excerpt
Def - Balance Sheet Account
Def - Balance Sheet Account
nopaneltrue

Insert excerpt
Def - Income Statement Account
Def - Income Statement Account
nopaneltrue

Database Field: ERPx_GLAccount.GLAccountPostingTypeEN

...