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: 20202023.0608.10 11 and newer
| Table of Contents | ||
|---|---|---|
|
...
| Filter Items | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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.
| ||||||||||||||||
| 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. | ||||||||||||||||
| GL Date |
| ||||||||||||||||
| Include |
| ||||||||||||||||
| Search |
| ||||||||||||||||
| Saved Search Options |
|
...
| 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 | ||||||||||||||||
| Account |
Database Field: ERPx_GLAccount.AccountNumber | ||||||||||||||||
| Account Description |
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 UserUpdated 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]). | ||||||||||||||||
| 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 |
...