Page Comparison

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. Also, info about grouped by GL Account

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.xx08.xx 11 and newer

Table of Contents

type	flat

...

Filter Items

Description

Account Class

Insert excerpt

	Inq - GL Account Class
	Inq - GL Account Class
nopanel	true

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

The lookup contains a list of all GL Account Classes.

Auto Hide Filters

Insert excerpt

	Auto Hide Filters
	Auto Hide Filters
nopanel	true

Auto Refresh on Open

Insert excerpt

	Auto Refresh on Open
	Auto Refresh on Open
nopanel	true

Category

Insert excerpt

	Inq - GL Category
	Inq - GL Category
nopanel	true

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

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

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

This lookup contains the values in the GLControlAcctType Enumeration Class.

Fiscal Period

Insert excerpt

	Inq - Fiscal Period
	Inq - Fiscal Period
nopanel	true

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 PeriodIt defaults as blank.

Insert excerpt

	Def - Fiscal Period
	Def - Fiscal Period
nopanel	true

The lookup contains a list of all Fiscal Periods.

Fiscal Year

Insert excerpt

	Inq - Fiscal Year
	Inq - Fiscal Year
nopanel	true

This is a multi-select standard lookup that is not required to return results. If the inquiry is opened from the Inquiries page, it 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
nopanel	true

The lookup contains a list of all Fiscal Years.

GL Account

Insert excerpt

	Inq - GL Account
	Inq - GL Account
nopanel	true

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

The lookup contains a list of all GL Accounts.

GL Date

Insert excerpt

	Inq - GL Date Range
	Inq - GL Date Range
nopanel	true

This is a date range editor that is not required to return results. It defaults as blank.

Insert excerpt

	GL Date
	GL Date
nopanel	true

Include

Insert excerpt

	Inq - Include
	Inq - Include
nopanel	true

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

Account (search a single account "1000" or a range of accounts

Search Options
nopanel	true

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")Account Description.
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
nopanel	true

...

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

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Excel

Insert excerpt

	Excel - LV 3.0
	Excel - LV 3.0
nopanel	true

Favorites

Insert excerpt

	Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

Group By Show/Hide

Insert excerpt

	Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Help

Insert excerpt

	Help - Global 3.0
	Help - Global 3.0
nopanel	true

More Actions

Insert excerpt

	More Actions - Global 3.0
	More Actions - Global 3.0
nopanel	true

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

Refresh

Insert excerpt

	Refresh - Global 3.0
	Refresh - Global - Global 3.0
nopanel	true

Saved Layouts

Insert excerpt

	Column Layouts for Framework 3.0 - Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

ViewSearch Options

Insert excerpt

View

	Search Options - Inquiry Grid 3.0

View

	Search Options - Inquiry Grid 3.0
nopanel	true

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

nopanel

true

Fields

Description

Account Description

Insert excerpt

GL Account Description

nopanel

true

Insert excerpt

Def - GL Account Description

Fields

Description

Account

Insert excerpt

	GL Account ID
	GL Account ID
nopanel	true

This field is not editable once it has been Saved.

Insert excerpt

	Def - GL Account ID
	Def - GL Account ID
nopanel	true

Database Field: ERPx_GLAccount.AccountNumber

Account Description

Insert excerpt

	GL Account Description
	GL Account Description
nopanel	true

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

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

Database Field: ERPx_

GLJournalHeader.

Comment

Account NumberCreated

GL Account ID

Insert excerpt

GL Account ID

Created
	Created
nopanel	true

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

Database Field: ERPx_GLAccountGLJournalHeader.AccountNumberCreatedBy

BalanceCredit

Identifies the beginning balance amount for a 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 field comes from the amounts on journal line entries created from posted transactions. This field should match the 'Period Balance' column on the previous 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.

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.

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

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

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

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

Insert excerpt

	Def - Functional Area
	Def - Functional Area
nopanel	true

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

Insert excerpt

Def - Fiscal Period

GL Date
	GL Date
nopanel	true

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

Database Field: ERPx_

MFFiscalYear.FiscalYearFunctional AreaHost JEJournal Date

GLJournalHeader.JournalID

Journal Type

Insert excerpt

	Journal Type
	Journal Type
nopanel	true

Database Field: ERPx_GLJournalHeader.JournalDate

Journal ID

JournalTransactionTypeSK

Last Updated

Insert excerpt

	Last Updated
	Last Updated
nopanel	true

Database Field: ERPx_GLJournalHeader.JournalID

Journal Type

Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSKGLJournalLine.LastUpdated

Last Updated By

Insert excerpt

	Last Updated By
	Last Updated

Database Field: ERPx_GLJournalLine.LastUpdated

Last User

By
nopanel	true

Database Field: ERPx_GLJournalLine.LastUser

Line Comment

Insert excerpt

	Comment
	Comment
nopanel	true

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

Insert excerpt

	Posted Date
	Posted Date
nopanel	true

Database Field: ERPx_GLJournalHeader.PostedDate

Posted By

Insert excerpt

	Posted By
	Posted By
nopanel	true

Database Field: ERPx_GLJournalHeader.PostedBy

Reference

Insert excerpt

	Reference
	Reference
nopanel	true

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 excerpt

	Def - General Ledger Account Segment
	Def - General Ledger Account Segment
nopanel	true

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

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

Segment
nopanel	true

Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

Source Trans Date

Insert excerpt

	Source Transaction Date
	Source Transaction Date
nopanel	true

Database Field: ERPx_

GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSKSource Trans Date

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

Source Trans DetailID

Insert excerpt

	Source Transaction ID
	Source Transaction ID
nopanel	true

Source Trans Type

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

Insert excerpt

	Def - Transaction Types
	Def - Transaction Types
nopanel	true

Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName

Status

Insert excerpt

	Status
	Status
nopanel	true

Database Field: ERPx_GLJournalHeader.TransactionStatusSK

...

Version	Old Version 5	New Version Current
Changes made by	Emma Greenwood	Emma Greenwood
Saved on	Dec 23, 2020	Dec 19, 2023

Versions Compared

Key