Versions Compared

Version Old Version 1 New Version Current
Changes made by

Tom Williams

Emma Greenwood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Software Version: 2020.06.10 and newer

Table of Contents
typeflat

Page Header

...

The lookup contains a list of all GL Account Classes.

...

This lookup contains the values in the GLAccountClassCategory Enumeration Class.

  • Asset
  • Liability
  • Equity
  • Income Statement

...

This lookup contains the values in the GLControlAcctType Enumeration Class.

...

The lookup contains a list of all Fiscal Periods.

...

The lookup contains a list of all Fiscal Years.

...

The lookup contains a list of all GL Accounts.

...

  • Beginning Balances. If selected, a row will be inserted for each GL Account that calculates the Beginning Balance for the account.

...

  • 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.

...

Page Detail

...

  • 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.

...

Database Field: ERPx_GLAccount.AccountNumber

...

Database Field: ERPx_GLAccount.Description

...

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].

...

Database Field: ERPx_GLJournalHeader.Comment

...

Database Field: ERPx_GLJournalHeader.CreatedDate

...

Database Field: ERPx_GLJournalHeader.CreatedBy

...

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

...

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

...

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

...

Identifies the "Type" of entity the Journal Line was Distributed to, for Journal Lines that were "Distributed To" a Project, Fisherman, or Employee.

...

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.

(lightbulb) 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

Table of Contents
typeflat

Page Header

Filter ItemsDescription
Auto Hide Filters
Insert excerpt
Auto Hide Filters
Auto Hide Filters
nopaneltrue
Auto Refresh on Open
Insert excerpt
Auto Refresh on Open
Auto Refresh on Open
nopaneltrue
Fiscal Period

Insert excerpt
Inq - Fiscal Period
Inq - Fiscal Period
nopaneltrue
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
nopaneltrue

The lookup contains a list of all Fiscal Periods.

Fiscal Year

Insert excerpt
Inq - Fiscal Year
Inq - Fiscal Year
nopaneltrue
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
nopaneltrue

The lookup contains a list of all Fiscal Years.

GL Date

Insert excerpt
Inq - GL Date Range
Inq - GL Date Range
nopaneltrue
This is a date range editor that is not required to return results. It defaults as blank.

Insert excerpt
GL Date
GL Date
nopaneltrue

Journal Type

Insert excerpt
Journal Type
Journal Type
nopaneltrue

Insert excerpt
Def - Journal Type
Def - Journal Type
nopaneltrue

Search

Insert excerpt
Search - Search Options
Search - Search Options
nopaneltrue

  • 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
nopaneltrue
  

Page Detail

Database Field: ERPx_GLJournalHeader.JournalDate

Database Field: ERPx_GLJournalHeader.JournalID

Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK

trueblank.

Database Field: ERPx_GLJournalLineGLJournalHeader.LastUpdatedHostJournalID

Last User
Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

  • 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
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh

Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue

Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
Search Options
Insert excerpt
Search Options - Inquiry Grid 3.0
Search Options - Inquiry Grid 3.0
nopaneltrue
FieldsDescription
Comment

Insert excerpt
Comment
Comment
nopaneltrue

Database Field: ERPx_GLJournalHeader.Comment

Created

Insert excerpt
Created
Created
nopaneltrue

Database Field: ERPx_GLJournalHeader.CreatedDate

Created By

Insert excerpt
Created By
Created By
nopaneltrue

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
nopaneltrue

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
nopaneltrue

Database Field: ERPx_MFFiscalYear.FiscalYear

Functional Area

Identifies the Functional Area where the Journal ID originated.

Insert excerpt
Def - Functional Area
Def - Functional Area
nopaneltrue

Host JEGL Date
nopaneltrue
Journal ID
Insert excerpt
Journal ID - LVJournal ID - LV
nopaneltrue
Journal Type
Insert excerpt
Journal TypeJournal Type
nopaneltrue
Last Updated

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.		Journal Date
Insert excerpt
GL Date

Insert excerpt
Last UpdatedLast Updatednopanel
Journal Date

Last Updated By

Insert excerpt
Last Updated By
GL Date
GL Date
nopaneltrue

Database Field: ERPx_GLJournalLineGLJournalHeader.LastUserJournalDate

Line CommentJournal ID

Comment

Insert excerpt
Comment
Journal ID - LV
Journal ID - LV
nopaneltrue

Database Field: ERPx_GLJournalLineGLJournalHeader.CommentJournalID

Master NumberNet ChangeIdentifies 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.NoteJournal Type

Insert excerpt
Journal Type
Journal Type
nopaneltrue

Database Field: ERPx_

GLJournalHeaderNote.NoteHTML where ERPx_GLJournalHeaderNote.JournalHeaderSK = ERPx_GLJournalLine.JournalHeaderSKPosted

GLJournalHeader.JournalTransactionTypeSK

Last Updated

Posted Date

Insert excerpt
Posted Date
Last Updated
Last Updated
nopaneltrue

Database Field: ERPx_GLJournalHeaderGLJournalLine.PostedDateLastUpdated

Posted Last Updated By

Insert excerpt
Posted
Last Updated By
Posted
Last Updated By
nopaneltrue

Database Field: ERPx_GLJournalHeaderGLJournalLine.PostedByLastUser

Reference Insert excerptReferenceReferencenopaneltrue

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 excerptDef - General Ledger Account SegmentDef - General Ledger Account SegmentMaster 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
nopaneltrue

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 excerptDef - General Ledger Account SegmentDef - General Ledger Account Segment

GLJournalHeader.PostedDate

Posted By

Insert excerpt
Posted By
Posted By
nopaneltrue

Database Field: ERPx_

GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSKSegment 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.

GLJournalHeader.PostedBy

ReferenceDef - General Ledger Account Segment

Insert excerpt

Def - General Ledger Account Segment

Reference
Reference
nopaneltrue

Database Field: ERPx_

GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

GLJournalHeader.Reference

Source Trans Date

Insert excerpt
Source Transaction Date
Source Transaction Date
nopaneltrue

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
Insert excerpt
Source Transaction ID
Source Transaction ID
nopaneltrue
Source Trans Type

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

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue

Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName

Status Insert excerptStatusStatusnopaneltrueDatabase Field: ERPx_GLJournalHeader.TransactionStatusSK

Related Topics

User Guide: Fiscal Periods

...