Page Comparison

The purpose of the Journal Entry History inquiry is to display posted journal entries. From this page, users can open the corresponding journal entry record view, the source transaction record view, or the Reverse/Correct window. This inquiry can be accessed from either the Inquiries page, or the Journal Line History inquiry.

This record view also contains columns for each Attribute that is set up for the 'Financial' attribute type. Because these are user defined, they are not included in the default view but can be added a saved column layout. Financial attributes are not included in the help documentation.

Software Version: 20202023.0608.10 11 and newer

Table of Contents

type	flat

...

Filter Items

Description

Auto Hide Filters

Insert excerpt

	Auto Hide Filters
	Auto Hide Filters
nopanel	true

Auto Refresh on Open

Insert excerpt

	Auto Refresh on Open
	Auto Refresh on Open
nopanel	true

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. It defaults as blank.

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. It defaults as the current year.

Insert excerpt

	Def - Fiscal Year
	Def - Fiscal Year
nopanel	true

The lookup contains a list of all Fiscal Years.

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

Journal Type

Insert excerpt

	Journal Type
	Journal Type
nopanel	true

Insert excerpt

	Def - Journal Type
	Def - Journal Type
nopanel	true

Search

Insert excerpt

	Search - Search Options
	Search - Search Options
nopanel	true

Journal ID. Search for all or part of a Journal ID.
Journal ID Range. Search for a range of Journal IDs (e.g. "25130:25150” to return all Journal Entries between "25130" and "25150").

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

RV: Journal. Opens the Journal Entry Record View.
RV: Source Transaction. Opens the Record View of the Source Transaction.
Reverse/Correct. Opens the Reverse/Correct page and allows the user to either Reverse or Reverse & Correct a journal entry.

Print

Insert excerpt

	Print - LV 3.0
	Print - LV 3.0
nopanel	true

Quick Column Filter

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

Refresh

Insert excerpt

	Refresh - Global 3.0
	Refresh - Global 3.0
nopanel	true

Saved Layouts

Insert excerpt

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

Search Options

Insert excerpt

	Search Options - Inquiry Grid 3.0
	Search Options - Inquiry Grid 3.0
nopanel	true

Fields

Description

Comment

Insert excerpt

	Comment
	Comment
nopanel	true

Database Field: ERPx_GLJournalHeader.Comment

Created

Insert excerpt

	Created
	Created
nopanel	true

Database Field: ERPx_GLJournalHeader.CreatedDate

Created By

Insert excerpt

	Created By
	Created By
nopanel	true

Database Field: ERPx_GLJournalHeader.CreatedBy

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

Identifies the Functional Area where the Journal ID originated.

Insert excerpt

	Def - Functional Area
	Def - Functional Area
nopanel	true

Host JE

Identifies the Journal ID from the Host System. This is only populated for companies that export their Journal Entries to a host system. For companies that do not, this field is blank.

Database Field: ERPx_GLJournalHeader.HostJournalID

Journal Date

Insert excerpt

	GL Date
	GL Date
nopanel	true

Database Field: ERPx_GLJournalHeader.JournalDate

Journal ID

Insert excerpt

	Journal ID - LV
	Journal ID - LV
nopanel	true

Database Field: ERPx_GLJournalHeader.JournalID

Journal Type

Insert excerpt

	Journal Type
	Journal Type
nopanel	true

Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK

Last Updated

Insert excerpt

	Last Updated
	Last Updated
nopanel	true

Database Field: ERPx_GLJournalLine.LastUpdated

Last UserUpdated By

Insert excerpt

	Last Updated By
	Last Updated By
nopanel	true

Database Field: ERPx_GLJournalLine.LastUser

Master Number

Displays the master number of the corresponding journal entry to give users the ability to audit the trail of journal history.

Database Field: ERPx_GLJournalHeader.MasterNumber

Note

Displays the Internal Note from a Manual Journal Entry.

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

Posted

Insert excerpt

	Posted Date
	Posted Date
nopanel	true

Database Field: ERPx_GLJournalHeader.PostedDate

Posted By

Insert excerpt

	Posted By
	Posted By
nopanel	true

Database Field: ERPx_GLJournalHeader.PostedBy

Reference

Insert excerpt

	Reference
	Reference
nopanel	true

Database Field: ERPx_GLJournalHeader.Reference

Source Trans Date

Insert excerpt

	Source Transaction Date
	Source Transaction Date
nopanel	true

Database Field: ERPx_GLJournalHeader.SourceTransactionDate

Source Trans Detail

Identifies details of the Source Transaction. For example, if the journal entry came from an AP Invoice this specifies the [Vendor Name] ([Vendor ID]).

Source Trans ID

Insert excerpt

	Source Transaction ID
	Source Transaction ID
nopanel	true

Source Trans Type

Identifies the Transaction Type of the transaction that created the Journal Entry.

Insert excerpt

	Def - Transaction Types
	Def - Transaction Types
nopanel	true

Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName

...

Versions Compared

Old Version 4

New Version 5

Key