Page Comparison

The purpose of this inquiry is to display a list view of all New, Approved, Ready to Post, and Posted journal entry lines. From this page, users may view the corresponding journal entry record view or the source transaction record view . This inquiry can be accessed from either the Inquiries page, or the GL Account Balances List View, or from the GL Account Balances By Period Inquiry. Beginning Balance Row. Also, info about grouped by GL Account.

Software Version: 2020.xx.xx and newer

...

Filter Items

Description

Account Class

Insert excerpt

	Inq - GL Account Class
	Inq - GL Account Class
nopanel	true

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt

	Def - GL Account Class
	Def - GL Account Class
nopanel	true

The lookup contains a list of all GL Account Classes.

Category

Insert excerpt

	Inq - GL Category
	Inq - GL Category
nopanel	true

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
nopanel	true

This lookup contains the values in the GLAccountClassCategory Enumeration Class.

Control Account Type

Insert excerpt

	Inq - GL Control Account Type
	Inq - GL Control Account Type
nopanel	true

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
nopanel	true

This lookup contains the values in the GLControlAcctType Enumeration Class.

Fiscal Period

Insert excerpt

	Inq - Fiscal Period
	Inq - Fiscal Period
nopanel	true

This is a multi-select standard lookup that is not required to return results. If the inquiry is opened from the Inquiries page or the GL Account Balances List View, it defaults as blank. If the inquiry is opened from the GL Account Balances by Period Inquiry, it defaults with the selected Fiscal Period.

Insert excerpt

	Def - Fiscal Period
	Def - Fiscal Period
nopanel	true

The lookup contains a list of all Fiscal Periods.

Fiscal Year

Insert excerpt

	Inq - Fiscal Year
	Inq - Fiscal Year
nopanel	true

This is a multi-select standard lookup that is not required to return results. If the inquiry is opened from the Inquiries page, it defaults as the current year. If the inquiry is opened from the GL Account Balances List View, it defaults as blank. If the inquiry is opened from the GL Account Balances by Period Inquiry, it defaults from the selected Fiscal Year.

Insert excerpt

	Def - Fiscal Year
	Def - Fiscal Year
nopanel	true

The lookup contains a list of all Fiscal Years.

GL Account

Insert excerpt

	Inq - GL Account
	Inq - GL Account
nopanel	true

This is a multi-select standard lookup that is not required to return results. If the inquiry is opened from the Inquiries page, it defaults as blank. If the inquiry is opened from the GL Account Balances List View or the GL Account Balances by Period Inquiry, it defaults with the selected GL Account.

Insert excerpt

	Def - GL Account Description
	Def - GL Account Description
nopanel	true

The lookup contains a list of all GL Accounts.

GL Date

Insert excerpt

	Inq - GL Date Range
	Inq - GL Date Range
nopanel	true

This is a date range editor that is not required to return results. It defaults as blank.

Insert excerpt

	GL Date
	GL Date
nopanel	true

Search

Insert excerpt

	Search - Search Options
	Search - Search Options
nopanel	true

Account (search a single account "1000" or a range of accounts "1000:2000” to return all GL Accounts between "1000" and "2000")
Account Description

Saved Search Options

Insert excerpt

	Search Options for Framework 3.0 - Global
	Search Options for Framework 3.0 - Global
nopanel	true

...

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Excel

Insert excerpt

	Excel - LV 3.0
	Excel - LV 3.0
nopanel	true

Favorites

Insert excerpt

	Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

Group By Show/Hide

Insert excerpt

	Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Help

Insert excerpt

	Help - Global 3.0
	Help - Global 3.0
nopanel	true

More Actions

Insert excerpt

	More Actions - Global 3.0
	More Actions - Global 3.0
nopanel	true

Reverse/Correct: Opens the Reverse/Correct page and allows the user to either Reverse or Reverse & Correct a journal entry.

Quick Filter

Insert excerpt

	Quick Filter
	Quick Filter
nopanel	true

Refresh

Insert excerpt

	Refresh - Global 3.0
	Refresh - Global 3.0
nopanel	true

View

Insert excerpt

	View - Inquiry Grid 3.0
	View - Inquiry Grid 3.0
nopanel	true

Journal: Opens the Journal Entry Record View for the selected journal line in a new tab
Source Transaction: Opens the source transaction (i.e. Payment, Fish Ticket, Transfer, etc.) for the selected journal line in a new tab

Saved Column Layouts

Insert excerpt

	Column Layouts for Framework 3.0 - Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

Fields

Description

Account Description

Insert excerpt

	GL Account Description
	GL Account Description
nopanel	true

This can be edited from the 'Account Description' field on the GL Accounts List View.

Insert excerpt

	Def - GL Account Description
	Def - GL Account Description
nopanel	true

Database Field: ERPx_GLAccount.Description

Account Number

Insert excerpt

	GL Account ID
	GL Account ID
nopanel	true

This field is not editable once it has been Saved.

Insert excerpt

	Def - GL Account ID
	Def - GL Account ID
nopanel	true

Database Field: ERPx_GLAccount.AccountNumber

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.

The Balance column represents the GL Account balance after the Journal Line and is calculated as [Prev Balance + Net Change].

Comment

Database Field: ERPx_GLJournalHeader.Comment

Created

Database Field: ERPx_GLJournalHeader.CreatedDate

Created By

Database Field: ERPx_GLJournalHeader.CreatedBy

Credit

Identifies the total amount from all posted transactions that negatively affect the GL balance 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.

Database Field: ERPx_GLJournalLine.CreditAmount

Debit

Identifies the total amount from all posted transactions that positively affect the GL balance 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.

Database Field: ERPx_GLJournalLine.DebitAmount

Distributed To

Database Fields: ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK

Distributed Type

Database Field: ERPx_GLJournalLine.MFDistributionAccountTypeEN

Fiscal Period

Identifies the Period on a Fiscal Calendar. This can be edited from the 'Period Name' field on the Fiscal Periods master file.

Insert excerpt

	Def - Fiscal Period
	Def - Fiscal Period
nopanel	true

Database Field: ERPx_MFFiscalPeriod.PeriodName

Fiscal Year

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

Insert excerpt

	Def - Fiscal Year
	Def - Fiscal Year
nopanel	true

Database Field: ERPx_MFFiscalYear.FiscalYear

Functional Area

Host JE

Journal Date

Database Field: ERPx_GLJournalHeader.JournalDate

Journal ID

Database Field: ERPx_GLJournalHeader.JournalID

Journal Type

Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK

Last Updated

Database Field: ERPx_GLJournalLine.LastUpdated

Last User

Database Field: ERPx_GLJournalLine.LastUser

Line Comment

Database Field: ERPx_GLJournalLine.Comment

Master Number

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.

Note

Database Field: ERPx_GLJournalHeaderNote.NoteHTML where ERPx_GLJournalHeaderNote.JournalHeaderSK = ERPx_GLJournalLine.JournalHeaderSK

Posted

Database Field: ERPx_GLJournalHeader.PostedDate

Posted By

Database Field: ERPx_GLJournalHeader.PostedBy

Reference

Database Field: ERPx_GLJournalHeader.Reference

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.

Insert excerpt

	Def - General Ledger Account Segment
	Def - General Ledger Account Segment
nopanel	true

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.

Insert excerpt

	Def - General Ledger Account Segment
	Def - General Ledger Account Segment
nopanel	true

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.

Insert excerpt

	Def - General Ledger Account Segment
	Def - General Ledger Account Segment
nopanel	true

Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

Source Trans Date

Database Field: ERPx_GLJournalHeader.SourceTransactionDate

Source Trans Detail

Source Trans Type

Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName

Status

Database Field: ERPx_GLJournalHeader.TransactionStatusSK

...

Version	Old Version 5	New Version 6
Changes made by	Emma Greenwood	Emma Greenwood
Saved on	Dec 23, 2020	May 24, 2021

Versions Compared

Key