Versions Compared

Version Old Version 6 New Version 7
Changes made by

Emma Greenwood

Tom Williams

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 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 from the GL Account Balances By Period Inquiry. Beginning Balance Row. 

Software Version: 2020.xx.xx and newer

...

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.

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.

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. If the inquiry is opened from the Inquiries page or the GL Account Balances List View, it defaults as blank. If the inquiry is opened from the GL Account Balances by Period Inquiry, it defaults with the selected Fiscal Period.

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. If the inquiry is opened from the Inquiries page, it defaults as the current year. If the inquiry is opened from the GL Account Balances List View, it defaults as blank. If the inquiry is opened from the GL Account Balances by Period Inquiry, it defaults from the selected Fiscal 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

Search

Insert excerpt
Search - Search Options
Search - Search Options
nopaneltrue

  • 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 excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue
  

Page Detail

in a new tabSaved Column Layouts

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

  • Reverse/Correct: Opens the Reverse/Correct page and allows the user to either Reverse or Reverse & Correct a journal entry.
Quick Filter
Insert excerpt
Quick Filter
Quick Filter
nopaneltrue
Refresh

Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue

View

Insert excerpt
View - Inquiry Grid 3.0
View - Inquiry Grid 3.0
nopaneltrue

  • Journal: Opens the Journal Entry Record View for the selected journal line in a new tab
  • Source Transaction: Opens the source transaction (i.e. Payment, Fish Ticket, Transfer, etc.) for the selected journal line
  • in a new tab
Saved Column Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
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 DescriptionColumn Layouts for Framework 3.0 - Global

Insert excerpt

Column Layouts for Framework 3.0 - Global

Account Description

GL Account Description
GL Account Description
nopaneltrue

FieldsDescriptionnopaneltrue This can be edited from the 'Account Description' field on the GL Accounts List View.
Insert excerptDef - GL Account DescriptionDef - GL Account Description

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

Insert excerpt
Def - GL Account Description

GL Account Description

Def - GL Account Description
nopaneltrue

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_

GLAccount

GLJournalHeader.

Description

Comment

Account NumberCreated

GL Account ID

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

Database Field: ERPx_GLJournalHeader.CreatedDate

Created By

Def - GL Account ID

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

Database Field: ERPx_GLAccountGLJournalHeader.AccountNumberCreatedBy

BalanceCredit

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

DebitCreated By

Database Field: ERPx_GLJournalHeader.CreatedBy

Credit

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.

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

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

GLJournalLine

MFFiscalPeriod.

CreditAmount

PeriodName

DebitFiscal Year

Identifies the

total amount from all posted transactions that positively affect the GL balance for

Year on a Fiscal

Period

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

Database Fields: ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK

Distributed Type

is a system assigned value and cannot be edited.

Insert excerpt
Def - Fiscal Year
Def - Fiscal Year
nopaneltrue

Database Field: ERPx_

GLJournalLine

MFFiscalYear.

MFDistributionAccountTypeEN

FiscalYear

Fiscal PeriodFunctional Area

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 PeriodFunctional Area where the Journal ID originated.

Insert excerpt
Def - Functional Area
Def - Functional Area
nopaneltrue

Host JEIdentifies 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
GL Date
nopaneltrue

Database Field: ERPx_

MFFiscalPeriod

GLJournalHeader.

PeriodName

JournalDate

Fiscal Year

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

Journal ID

Insert excerpt

Def

Journal ID -

Fiscal Year

LV

Def

Journal ID -

Fiscal Year

LV
nopaneltrue

Database Field: ERPx_

MFFiscalYear.FiscalYearFunctional AreaHost JEJournal Date

GLJournalHeader.JournalID

Journal Type

Insert excerpt
Journal Type
Journal Type
nopaneltrue

Database Field: ERPx_GLJournalHeader.JournalDate

Journal ID

JournalTransactionTypeSK

Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue

Database Field: ERPx_GLJournalHeader.JournalID

Journal Type

Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSKGLJournalLine.LastUpdated

Last User

Insert excerpt
Last Updated By
Last Updated

Database Field: ERPx_GLJournalLine.LastUpdated

Last User

By
nopaneltrue

Database Field: ERPx_GLJournalLine.LastUser

Line Comment

Insert excerpt
Comment
Comment
nopaneltrue

Database Field: ERPx_GLJournalLine.Comment

Master Number
Net 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]. 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


Database Field: ERPx_GLJournalHeaderNote.NoteHTML where ERPx_GLJournalHeaderNote.JournalHeaderSK = ERPx_

GLJournalLine.JournalHeaderSKPosted

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

Identifies the first

Database Field: ERPx_GLJournalHeader.Reference

Segment 1

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 excerpt
Def - General Ledger Account Segment
Def - General Ledger Account Segment
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 excerpt
Def - General Ledger Account Segment
Def - General Ledger Account Segment
nopaneltrue

Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

Segment 23

Identifies the second 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

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


Source Trans ID
Insert excerpt
Source Transaction ID
Source Transaction ID
nopaneltrue

Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

Segment 3Identifies 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.Source Trans TypeSource Trans Type

Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName

Status

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

Source Trans Date

Database Field: ERPx_GLJournalHeader.SourceTransactionDate

Source Trans Detail

GLJournalHeader.SourceTransactionTypeName

Status

Insert excerpt
Status
Status
nopaneltrue

Database Field: ERPx_GLJournalHeader.TransactionStatusSK

...