The purpose of the Journal Line History inquiry is to display journal lines from 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 GL Account Balances List View, or the GL Account Balances By Period 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

[ 1 Page Header ] [ 1.1 Search ] [ 2 Page Detail ] [ 2.1 Related Topics ] [ 2.1.1 Page Definitions ] [ 2.1.2 Technical Details ]

Page Header

Search

Filter Items	Description

Filter Items	Description
Account Class	This is a multi-select standard lookup that is not required to return results. It defaults as blank. The lookup contains a list of all GL Account Classes.
Auto Hide Filters
Auto Refresh on Open
Category	This is a multi-select standard lookup that is not required to return results. It defaults as blank. This lookup contains the values in the GLAccountClassCategory Enumeration Class. Asset Liability Equity Income Statement
Control Account Type	This is a multi-select standard lookup that is not required to return results. It defaults as blank. This lookup contains the values in the GLControlAcctType Enumeration Class.
Fiscal Period	This is a multi-select standard lookup that is not required to return results. It defaults as blank. The lookup contains a list of all Fiscal Periods.
Fiscal Year	This is a multi-select standard lookup that is not required to return results. It defaults as the current year. The lookup contains a list of all Fiscal Years.
GL Account	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. The lookup contains a list of all GL Accounts.
GL Date	This is a date range editor that is not required to return results. It defaults as blank.
Include	Beginning Balances. If selected, a row will be inserted for each GL Account that calculates the Beginning Balance for the account.
Search	Account. Search for all or part of a GL Account number. Account Description. Search for all or part of a GL Account Description. Natural Account Range. Search for a range of "Natural" accounts (e.g. "1000:2000” to return all GL Accounts between "1000" and "2000"). Journal ID. Search for all or part of a Journal ID.
Saved Search Options

Page Detail

Toolbar Icons	Description

Toolbar Icons	Description
Column Filter Show/Hide
Excel
Favorites
Group By Show/Hide
Help
More Actions	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.
Quick Column Filter
Refresh
Saved Layouts
Search Options
Fields	Description
Account	This field is not editable once it has been Saved. Database Field: ERPx_GLAccount.AccountNumber
Account Description	This can be edited from the 'Account Description' field on the GL Accounts List View. Database Field: ERPx_GLAccount.Description
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 Credit amount of the journal line. 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 Debit amount of the journal line, 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	Identifies the name of entity the Journal Line was Distributed to, for Journal Lines that were "Distributed To" a Project, Fisherman, or Employee. Database Fields: ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK
Distributed Type	Identifies the "Type" of entity the Journal Line was Distributed to, for Journal Lines that were "Distributed To" a Project, Fisherman, or Employee. 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. 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
Line Comment	Database Field: ERPx_GLJournalLine.Comment
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
Net Change	Identifies the Debit or Credit amount of the line. If the Journal Line was a Debit then the amount will be display as a positive number. If the Journal Line was a Credit then the amount will be displayed as a negative (e.g. (150.25). This field is not stored in the database.
Note	Displays the first 30 characters of 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
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
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
Status	Database Field: ERPx_GLJournalHeader.TransactionStatusSK

Journal Line History Inquiry

Page Header

Search

Page Detail