Versions Compared

Version Old Version 2 New Version Current
Changes made by

Janice Dannenberg (Unlicensed)

Emma Greenwood

Saved on

Key

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

The purpose of this inquiry is to display a list view of all New, Approved, Ready to Post, and Posted journal entry lines. From this page, users may view the corresponding journal entry record view or the source transaction record view . This inquiry can be accessed from either the Inquiries page or from the GL Account Balances By Period Inquiry.

Software Version: 2020.xx.xx 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.

...

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

(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
Account Class

Insert excerpt
Inq - GL Account Class
Inq - GL Account Class
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - GL Account Class
Def - GL Account Class
nopaneltrue

The lookup contains a list of all GL Account Classes.

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
Category

Insert excerpt
Inq - GL Category
Inq - GL Category
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - General Ledger Account Category
Def - General Ledger Account Category
nopaneltrue

This lookup contains the values in the GLAccountClassCategory Enumeration Class.

  • Asset
  • Liability
  • Equity
  • Income Statement
Control Account Type

Insert excerpt
Inq - GL Control Account Type
Inq - GL Control Account Type
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Control Account
Def - Control Account
nopaneltrue

This lookup contains the values in the GLControlAcctType Enumeration Class.

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 Account

Insert excerpt
Inq - GL Account
Inq - GL Account
nopaneltrue
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.

Insert excerpt
Def - GL Account Description
Def - GL Account Description
nopaneltrue

The lookup contains a list of all GL Accounts.

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

Include

Insert excerpt
Inq - Include
Inq - Include
nopaneltrue

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

Insert excerpt
Search - Search Options
Search - Search Options
nopaneltrue

  • 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

Insert excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue
  

Page Detail

Toolbar IconsDescriptionColumn Filter Show/Hide Insert excerptColumn Filter Show/Hide - GlobalColumn Filter Show/Hide - GlobalnopaneltrueExcel Insert excerptExcel - LV 3.0Excel - LV 3.0nopaneltrueFavorites Insert excerptFavorites Add/Remove - GlobalFavorites Add/Remove - GlobalnopaneltrueGroup By Show/Hide Insert excerptGroup By Show/Hide - GlobalGroup By Show/Hide - GlobalnopaneltrueHelp Insert excerptHelp - Global 3.0Help - Global 3.0nopaneltrueQuick Filter Insert excerptQuick FilterQuick FilternopaneltrueRefresh Insert excerptRefresh - Global 3.0Refresh - Global 3.0nopaneltrueView Insert excerptView - Inquiry Grid 3.0View - Inquiry Grid 3.0nopaneltrue
  • Journal Line History: Opens the Journal Line History Inquiry for the selected GL Account period in a new tab
Saved Column Layouts Insert excerptColumn Layouts for Framework 3.0 - GlobalColumn Layouts for Framework 3.0 - GlobalnopaneltrueFieldsDescriptionAccount Insert excerptGL Account IDGL Account IDnopaneltrue This field is not editable once it has been Saved.
Insert excerptDef - GL Account IDDef - GL Account ID
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.
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
Account

Insert excerpt
GL Account ID
GL Account ID
nopaneltrue
This field is not editable once it has been Saved.

Insert excerpt
Def - GL Account ID
Def - GL Account ID
nopaneltrue

Database Field: ERPx_GLAccount.AccountNumber

Account Description

Insert excerpt
GL Account Description
GL Account Description
nopaneltrue
This can be edited from the 'Account Description' field on the GL Accounts List View.

Insert excerpt
Def - GL Account Description
Def - GL Account Description
nopaneltrue

The lookup contains a list of all GL Accounts.

Posting Type

Used to select one or more Posting Types. 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 GLAccountPostingType Enumeration Class.

Search Insert excerptSearch - Search OptionsSearch - Search Optionsnopaneltrue
  • Account (search a single account "1000" or a range of accounts "1000:2000” to return all GL Accounts between "1000" and "2000")
  • Account Description
Saved Search Options Insert excerptSearch Options for Framework 3.0 - GlobalSearch Options for Framework 3.0 - Globalnopaneltrue  

Page Detail

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

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

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.

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

Database Field: ERPx_GLJournalHeader.JournalDate

Journal ID

Insert excerpt
Journal ID - LV
Journal ID - LV
nopaneltrue

Database Field: ERPx_

GLAccount

GLJournalHeader.

AccountNumber

JournalID

Account DescriptionGL Account Description
Journal Type

Insert excerpt

GL Account Description

Journal Type
Journal Type
nopaneltrue

This can be edited from the 'Account Description' field on the GL Accounts List View. Def - GL Account Description

Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK

Last Updated

Insert excerpt

Def - GL Account Description

Last Updated
Last Updated
nopaneltrue

Database Field: ERPx_

GLAccount.DescriptionBeginning BalanceIdentifies 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.
CreditIdentifies the total amount from all posted transactions that negatively affect the GL balance for a Fiscal Period. 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.DebitIdentifies the total amount from all posted transactions that positively affect the GL balance for a Fiscal Period. 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

Identifies the Period on a Fiscal Calendar. This can be edited from the 'Period Name' field on the Fiscal Periods master file.

Insert excerptDef - Fiscal PeriodDef - Fiscal Period

GLJournalLine.LastUpdated

Last Updated By

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue

Database Field: ERPx_GLJournalLine.LastUser

Line Comment

Insert excerpt
Comment
Comment
nopaneltrue

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 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.
Fiscal Period
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

Insert excerpt
Posted Date
Posted Date
nopaneltrue

Database Field: ERPx_GLJournalHeader.PostedDate

Posted By

Insert excerpt
Posted By
Posted By
nopaneltrue

Database Field: ERPx_GLJournalHeader.PostedBy

Reference

Insert excerpt
Reference
Reference
nopaneltrue

Database Field: ERPx_

MFFiscalPeriod

GLJournalHeader.

PeriodName

Reference

Fiscal Year
Segment 1

Identifies the

Year on a Fiscal Calendar. This is a system assigned value and cannot be edited

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 excerpt
Def -

Fiscal Year

General Ledger Account Segment
Def -

Fiscal Year

General Ledger Account Segment
nopaneltrue

Database

Field: ERPx_MFFiscalYear.FiscalYearNet ChangeIdentifies the difference between the Debit and Credit columns for a Fiscal Period. It comes from the 'Debit' and 'Credit' columns for the Fiscal Period and is calculated as [Debit] - [Credit]. This field is not stored in the database.Period Balance Identifies the total balance of the Fiscal Period

Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

Segment 2

Identifies the second part (segment) of the GL Account Format. It comes from the '

Beginning Balance' and 'Net Change' columns for the Fiscal Period and is calculated as [Beginning Balance] + [Net Change]. This field is not stored in the database.
Segment 1Identifies the first

Number' column on the GL Account Format Record View. This field is never editable.

Insert excerpt
Def - General Ledger Account Segment
Def - General Ledger Account Segment
nopaneltrue

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.

Insert excerpt
Def - General Ledger Account Segment
Def - General Ledger Account Segment
nopaneltrue

Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

Segment 2Identifies 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.
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 -

General Ledger Account Segment

Transaction Types
Def -

General Ledger Account Segment

Transaction Types
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.

Def - General Ledger Account Segment

GLJournalHeader.SourceTransactionTypeName

Status

Insert excerpt

Def - General Ledger Account Segment

Status
Status
nopaneltrue

Database Field: ERPx_

GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

GLJournalHeader.TransactionStatusSK

Related Topics

User Guide: Fiscal Periods

...