Account Class

The lookup contains a list of all GL Account Classes.

Auto Hide Filters

Auto Refresh on Open

Balances Thru

Category

This lookup contains the values in the GLAccountClassCategory Enumeration Class.

• Asset

• Liability

• Equity

• Income Statement

Control Account Type

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

The lookup contains a list of all GL Accounts.

Include

• 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

Search

• 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)

  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.

Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

Help

More Actions

• 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

Refresh

Saved Layouts

Search Options

Fields

Description

Checkbox

Account

Database Field: ERPx_GLAccount.AccountNumber

Account Class

Database Fields: ERPx_GLAccountClass.ClassName, ERPx_GLAccount.AccountClassSK

Account Description

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 Thru

Identifies 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

Database Fields: ERPx_GLAccountClass.ClassName, ERPx_GLAccount.AccountClassSK

Control Account Type

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.

Database Field: ERPx_GLAccount.GLAccountPostingTypeEN