Account Class

The lookup contains a list of all GL Account Classes.

Auto Hide Filters

Auto Refresh on Open

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.

Fiscal Period

The lookup contains a list of all Fiscal Periods.

Fiscal Year

The lookup contains a list of all Fiscal Years.

GL Account

The lookup contains a list of all GL Accounts.

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

• Account Description
  
  

• Natural Account Range

  • Search a range of values "1000:2000” to return all Accounts between "1000-000-00" and "2000-000-00"

  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: ". Instead, 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: Journal Line History: Opens the Journal Line History Inquiry for the selected GL Account period in a new tab

Quick Column Filter

Refresh

Saved Layouts

Search Options

Fields

Description

Checkbox

Account

Database Field: ERPx_GLAccount.AccountNumber

Account Description

Database Field: ERPx_GLAccount.Description

Beginning Balance

Identifies the beginning balance amount for a Fiscal Period. This field comes from the amounts on journal line entries created from posted transactions. This field should match the 'Period Balance' column on the previous Fiscal Period. This amount cannot be edited, unless the original posted transaction is voided, reversed or corrected.  This is a calculated field and not stored in the database.

Budget - Period

Identifies the budget amount for each combination of Fiscal Year, Period, and GL Account. This is not editable from this page. 

Budget - YTD

Identifies the cumulative budget amount for each combination of Fiscal Year, Period, and GL Account. This field is calculated differently for each GL Account Posting Type:

• Balance Sheet Accounts: displays the budget amount for the Fiscal Year & Period (it should match the value in the 'Budget - Period' column).

• Income Statement Accounts: displays the cumulative totals for each Period.

Credit

Identifies the total Credit amount from all posted transactions for a Fiscal Period. This field comes from the 'Credit' column on a Journal Entry Record View with a Date that falls within the Fiscal Period. This amount cannot be edited, unless the original posted transaction is voided, reversed or corrected. This is a calculated field and not stored in the database.

Debit

Identifies the total Debit amount from all posted transactions for a Fiscal Period. This field comes from the 'Debit' column on a Journal Entry Record View with a Date that falls within the Fiscal Period. This amount cannot be edited, unless the original posted transaction is voided, reversed or corrected. This is a calculated field and not stored in the database.

Fiscal Period

Identifies the Period on a Fiscal Calendar. This value is looked up from the 'Period Name' field on the Fiscal Periods master file.

Database Field: ERPx_MFFiscalPeriod.PeriodName

Fiscal Year

Identifies the Year on a Fiscal Calendar. This is a system assigned value and cannot be edited.

Database Field: ERPx_MFFiscalYear.FiscalYear

Net Change

Identifies the difference between the Debit and Credit columns for a Fiscal Period. It comes from the 'Debit' and 'Credit' columns for the Fiscal Period and is calculated as [Debit] - [Credit]. This field is not stored in the database.

Period Balance

Identifies the total balance of the Fiscal Period. It comes from the 'Beginning Balance' and 'Net Change' columns for the Fiscal Period and is calculated as [Beginning Balance] + [Net Change]. This field is not stored in the database.

Segment 1

Identifies the first part (segment) of the GL Account Format. It comes from the 'Number' column on the GL Account Format Record View. This field is never editable.

Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

Segment 2

Identifies the second part (segment) of the GL Account Format. It comes from the 'Number' column on the GL Account Format Record View. This field is never editable.

Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

Segment 3

Identifies the third part (segment) of the GL Account Format. It comes from the 'Number' column on the GL Account Format Record View. This field is never editable.

Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK