Insert excerptDef - Journal EntryDef - Journal Entrynopaneltrue The purpose of the Journal Lines List View is to show (open/unposted) 'Manual' and 'Accrue & Reverse' journal lines assigned a Status of New and Approved. From here, users can add, edit, delete, or post unposted 'Manual' and 'Accrue & Reverse' journal entries. When these are posted, the General Ledger is updated.

Software Version: 2020.xx.xx and newer

Table of Contents

type	flat

Page Header

...

Insert excerpt

	Def - Journal Entry
	Def - Journal Entry
nopanel	true

The purpose of the Journal Lines List View is to show (open/unposted) 'Manual' and 'Accrue & Reverse' journal lines assigned a Status of New and Approved. From here, users can add, edit, delete, or post unposted 'Manual' and 'Accrue & Reverse' journal entries. When these are posted, the General Ledger is updated.

This list 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.12.19 and newer

Table of Contents

type	flat

Page Header

This is not required and is not editable. Journal lines displayed from this list view will always be of type 'Project

view while in a Status of 'New'.

Database Field: ERPx_GLJournalLine.

MFDistributionAccountTypeEN

CreditAmount

This is required and can be edited by changing the 'Date' field on the Home tab DebitThis is

Database Field: ERPx_GLJournalLine.DebitAmount

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

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

Delete

Insert excerpt

	Delete - LV 3.0
	Delete - LV 3.0
nopanel	true

Edit

Insert excerpt

	Edit - LV 3.0
	Edit - LV 3.0
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

Reverse/Correct: Opens the Reverse/Correct page and allows the user to either Reverse or Correct a journal entry.

New

Insert excerpt

	New - Multi-Select Trans Type - Global 3.0
	New - Multi-Select Trans Type - Global 3.0
nopanel	true

Manual: Opens a blank journal entry record.
Insert excerpt
Def - Journal Entry
Def - Journal Entry
nopanel true
Accrue & Reverse: Opens a blank Accrue & Reverse journal entry record.
Insert excerpt
Def - Journal Entry - Accrue & Reverse
Def - Journal Entry - Accrue & Reverse
nopanel true
Unrealized Currency Gain/Loss: Opens a blank Unrealized Gain/Loss record.
Insert excerpt
Def - Unrealized Gain/Loss
Def - Unrealized Gain/Loss
nopanel true

Print

Insert excerpt

	Print - LV 3.0
	Print - LV 3.0
nopanel	true

Quick Column Filter

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

Saved Layouts

Insert excerpt

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

Fields

Description

Checkbox

Used to select one or more records for Mass Update or Delete.

Account Description

Insert excerpt

	GL Account Description

Displays the name of the

	GL Account Description

associated with the Journal line. This


nopanel	true

This is required to save a Journal line and can be edited from the 'Account Number' field on the Journal lines grid of the Journal Entry record view while in a Status of 'New'.

Insert excerpt

	Def - GL Account Description
	Def - GL Account Description
nopanel	true

Database Field: ERPx_GLAccount.Description

Account NumberDisplays the GL Account Number associated with the Journal line.

Insert excerpt

	GL Account ID
	GL Account ID
nopanel	true

This is required to save a Journal line and can be edited from the 'Account Number' field on the Journal lines grid of the Journal Entry record view while in a Status of 'New'.

Insert excerpt

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

Database Field: ERPx_GLAccount.AccountNumber

Comment

Insert excerpt

	Comment

Shows the Comment entered for the transaction. This

	Comment
nopanel	true

This is not required and comes from the 'Comment' in the header of the Home tab on the Journal Entry Record View. This defaults to blank and is always editable for 'Manual' journal entities and for 'Accrue & Reverse' journal entries while they are in a Status of 'New'.

Database Field: ERPx_GLJournalHeader.Comment

Created

Insert excerpt

	Created
	Created
nopanel	true

This is a required field.

Database Field: ERPx_GLJournalHeader.CreatedDate

Created By

Displays the amount credited from the Journal line. This field is required and if no amount was entered, it will displays as "0.00". This can be edited from the 'Credit' field on the Journal lines grid of the Journal Entry record view while in a Status of 'New'

Insert excerpt

	Created By
	Created By
nopanel	true

This is a required field.

Database Field: ERPx_GLJournalHeader.CreatedBy

Credit


nopanel	true

This is a required field.

Database Field: ERPx_

GLJournalLine

GLJournalHeader.

CreditAmount

CreatedBy

DebitCredit

Displays the amount debited credited from the Journal line. This field is required and if no amount was entered, it will displays as "0.00". This can be edited from the 'Debit' field on the Journal lines grid of the Journal Entry record view while in a Status of 'New'.

Database Field: ERPx_GLJournalLine.DebitAmount

Distributed To

Displays the name of the Project the amount is distributed to. This is not required and . This can be edited from the 'ProjectCredit' field on the Journal lines grid of the Journal Entry record view while in a Status of 'New'.

Database Fields: ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK

Distributed Type

Insert excerpt

Distributed To Type

nopanel

true

GL Period

Insert excerpt

GL Period

nopanel

true

Displays the amount debited from the Journal line. This field is required and if no amount was entered, it will displays as "0.00". This can be edited from the 'Debit' field on the Journal lines grid of the Journal Entry record view while in a Status of 'New'.

GL Year

Insert excerpt

GL Year

nopanel

true

Distributed To

Displays the name of the Project the amount is distributed to. This is not required and can be edited

by changing

from the '

Date

Project' field on the

Home tab

Journal lines grid of the Journal Entry record view while in a Status of 'New'.

Database Fields: ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK

Journal Date

A non-editable text box that displays the date that the journal entry will post to the GL, formatted from the users 'Date Format' preference. Distributed Type

Insert excerpt

	Distributed To Type
	Distributed To Type
nopanel	true

This is not required and is not editable. Journal lines displayed from this list view will always be of type 'Project'.

Database Field: ERPx_

GLJournalHeader

GLJournalLine.

JournalDate

MFDistributionAccountTypeEN

Journal ID

GL Period

Journal ID - LV

Insert excerpt

Journal ID - LV

GL Period
	GL Period
nopanel	true

Clicking on the link opens the Journal Entry Record View for the selected Journal Entry. This comes from the 'Journal ID' in the header of the 'Home' tab on the Journal Entry Record View and is auto-assigned when a new Journal Entry is initially saved/created. This is never editable.

Database Field: ERPx_GLJournalHeader.JournalID

Journal Type

Insert excerptJournal TypeJournal Typenopaneltrue This is required and comes from the 'Journal Type' in the header of the 'Home' tab on the Journal Entry Record View and is auto-assigned based on the type of journal entry selected on New. This is never editable. Insert excerptDef - Journal TypeDef - Journal Typenopaneltrue The list of applicable Journal Types for this page include: Insert excerptDef - Journal Type - ManualDef - Journal Type - Manualnopaneltrue Insert excerptDef - Journal Type - Accrue & ReverseDef - Journal Type - Accrue & Reversenopaneltrue This is required and can be edited by changing the 'Date' field on the Home tab of the Journal Entry record view while in a Status of 'New'.

GL Year

Insert excerpt

	GL Year
	GL Year
nopanel	true

This is required and can be edited by changing the 'Date' field on the Home tab of the Journal Entry record view while in a Status of 'New'.

Journal Date

Insert excerpt

	GL Date
	GL Date
nopanel	true

This is required and can be edited by changing the 'Date' field on the Home tab of the Journal Entry record view while in a Status of 'New'.

Database Field: ERPx_GLJournalHeader.JournalDate

Journal ID

Insert excerpt

	Journal ID - LV
	Journal ID - LV
nopanel	true

Clicking on the link opens the Journal Entry Record View for the selected Journal Entry. This comes from the 'Journal ID' in the header of the 'Home' tab on the Journal Entry RV and is auto-assigned when a new Journal Entry is initially saved/created. This is never editable.

Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK JournalID

Last UpdatedJournal Type

Insert excerpt

Last UpdatedLast Updatednopaneltrue This is a required field.

Database Field: ERPx_GLJournalLine.LastUpdated

Last UserLast Updated By

	Journal Type
	Journal Type
nopanel	true

This is required and comes from the 'Journal Type' in the header of the 'Home' tab on the Journal Entry RV and is auto-assigned based on the type of journal entry selected on New. This is never editable.

Insert excerpt

Last Updated By

Def - Journal Type
	Def - Journal Type
nopanel	true

This is a required field.

Database Field: ERPx_GLJournalLine.LastUser

Line Comment

Displays the comment corresponding to the Journal line. This is not required and can be edited by changing the 'Line Comment' field on the Journal lines grid of the Journal Entry record view while in a Status of 'New'.

Database Field: ERPx_GLJournalLine.Comment

Note

Identifies the first 30 characters from the 'Internal' Transaction Note. This is note required and comes from the value entered in the Internal Note Type. This is always editable.

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

Posted

Identifies the Date & Time of the Journal was Posted. This is a system assigned value and is never editable by a user. This field is not required and is populated when journals are saved as "Ready to Post".

This field will only display when the outbound integration for 'Journal' Transaction Type is turned on and Journal Entry transactions are in a status of "Ready to Post".

Database Field: ERPx_GLJournalHeader.PostedDate

Posted By

Displays the name of the user that Posted the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. This field is not required and is populated when journals are saved as "Ready to Post".

This field will only display when the outbound integration for 'Journal' Transaction Type is turned on and Journal Entry transactions are in a status of "Ready to Post"

The list of applicable Journal Types for this page include:

Manual Journal Entry:

Insert excerpt

	Def - Journal Entry
	Def - Journal Entry
nopanel	true

Accrue & Reverse Journal Entry:

Insert excerpt

	Def - Journal Entry - Accrue & Reverse
	Def - Journal Entry - Accrue & Reverse
nopanel	true

Correct:

Insert excerpt

	Def - Journal Type - Reverse & Correct
	Def - Journal Type - Reverse & Correct
nopanel	true

Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK

Last Updated

Insert excerpt

	Last Updated
	Last Updated
nopanel	true

This is a required field.

Database Field: ERPx_

GLJournalHeader

GLJournalLine.

PostedBy

LastUpdated

ReferenceLast Updated ByReference

Insert excerpt

Reference

Last Updated By
	Last Updated By
nopanel	true

This comes from the 'Reference' in the header of the 'Home' tab on the Journal Entry Record View. This is not required and is always editable for 'Manual' journal entities and for 'Accrue & Reverse' journal entries while they are in a Status of 'New'

This is a required field.

Database Field: ERPx_

GLJournalHeader.ReferenceSource Module

Displays the name of the functional area in which the transaction resulting in the corresponding journal entry was created. This is required and never editableGLJournalLine.LastUser

Line Comment

Insert excerpt

	Comment
	Comment
nopanel	true

This is not required and can be edited by changing the 'Line Comment' field on the Journal lines grid of the Journal Entry record view while in a Status of 'New'.

Database Field: ERPx_

GLJournalHeader

GLJournalLine.

SourceModuleSK

Comment

Source Trans DateDisplays the date of the transaction that resulted in the corresponding journal entry, formatted from the users 'Date Format' preference. This is not required and never editableNote

Identifies the first 30 characters from the 'Internal' Transaction Note. This is note required and comes from the value entered in the Internal Note Type. This is always editable.

Database Field: ERPx_GLJournalHeaderNote.NoteHTML where ERPx_GLJournalHeaderNote.JournalHeaderSK = ERPx_GLJournalHeader.SourceTransactionDate

Source Trans ID

Displays the Journal ID for the transaction that resulted in the corresponding journal entry. Clicking the link opens Journal Entry Record View of the selected transaction. GLJournalLine.JournalHeaderSK

Reference

Insert excerpt

	Reference
	Reference
nopanel	true

This comes from the 'Reference' in the header of the 'Home' tab on the Journal Entry RV. This is not required and

never editable.

Database Field: ERPx_GLJournalLine.SourceTransactionID

Source Trans TypeDisplays the transaction type of the source Journal transaction that resulted in the corresponding journal entry. This is not required and never editable

is always editable for 'Manual' journal entities and for 'Accrue & Reverse' journal entries while they are in a Status of 'New'.

Database Field: ERPx_GLJournalHeader.

SourceTransactionTypeName

Reference

Status

Insert excerpt

	Status
	Status
nopanel	true

This comes from the 'Status' on the 'Home' tab on the Journal Entry Record ViewRV. This is only editable for Journal Entries in a Status of New or Approved.

The entry will be listed as either “New” , “Approved”, or “Ready to Post”. or “Approved”

Insert excerpt

	Def - Status
	Def - Status
nopanel	true

This page includes all the Manual and Accrue & Reverse journal entries in a the statuses of The Statuses that apply to transactions in this List View include:

Insert excerpt

	Def - Status - New
	Def - Status - New
nopanel	true

Insert excerpt

	Def - Status - Approved
	Def - Status - Approved
nopanel	true

Database Field: ERPx_GLJournalHeader.TransactionStatusSK

Version	Old Version 10	New Version Current
Changes made by	Tom Williams	Emma Greenwood
Saved on	Jun 26, 2020	Jan 02, 2024

Versions Compared

Key

Page Header

Page Header

Related Topics

Page Definitions

Technical Details

Page Comparison

Versions Compared

Key

Page Header

Page Header

Related Topics

Page Definitions

Technical Details