Journal Entry History Inquiry
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: 2023.08.11 and newer
Page Header
Search
Filter Items | Description |
|---|---|
Auto Hide Filters | |
Auto Refresh on Open | |
Fiscal Period |
The lookup contains a list of all Fiscal Periods. |
Fiscal Year |
The lookup contains a list of all Fiscal Years. |
GL Date |
|
Journal Type | |
Search |
|
Saved Search Options |
Page Detail
Toolbar Icons | Description |
|---|---|
Column Filter Show/Hide | |
Excel | |
Favorites | |
Group By Show/Hide | |
Help | |
More Actions |
|
Quick Column Filter | |
Refresh | |
Saved Layouts | |
Search Options | |
Fields | Description |
Comment | Database Field: ERPx_GLJournalHeader.Comment |
Created | Database Field: ERPx_GLJournalHeader.CreatedDate |
Created By | 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. 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 |
Functional Area | Identifies the Functional Area where the Journal ID originated. |
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 | 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 Updated By | 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 | Database Field: ERPx_GLJournalHeader.PostedDate |
Posted By | Database Field: ERPx_GLJournalHeader.PostedBy |
Reference | Database Field: ERPx_GLJournalHeader.Reference |
Source Trans Date | 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]). Database Field: ERPx_GLJournalHeader.SourceTransactionDetail |
Source Trans ID | |
Source Trans Type | Identifies the Transaction Type of the transaction that created the Journal Entry. Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName |