A journal entry is a record of the business transactions in the accounting books of a business. A properly documented journal entryA journal entry is a record of the business transactions in the accounting books of a business. A properly documented journal entry consists of the correct date, amounts to be debited and credited, description of the transaction and a unique reference number. 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

...

entries. When these are posted, the General Ledger is updated.

Software Version: 2020.xx.xx and newer

Table of Contents

type	flat

Page Header

Displays the name of the GL Account Description associated with the Journal line. 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' This is a required fieldDistributed To This is a required field.

Database Field: ERPx_GLJournalHeader.CreatedBy

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

Toolbar Icons

Description

Delete

Insert excerpt

	Delete - LV
	Delete - LV
nopanel	true

Edit

Insert excerpt

	Edit - LV
	Edit - LV
nopanel	true

Excel

Insert excerpt

	Excel - LV
	Excel - LV
nopanel	true

Favorites

Insert excerpt

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

Grid Layout

Insert excerpt

	Grid Layout - Global
	Grid Layout - Global
nopanel	true

Help

Insert excerpt

	Help - Global
	Help - Global
nopanel	true

More Actions

Opens a drop-down menu for the user to select Reverse/Correct, which opens the Reverse/Correct Journals record view and allows the user to Reverse or Reverse & Correct a journal entry.

New

Insert excerpt

	New - Global
	New - Global
nopanel	true

Fields

Grid Layout

Insert excerpt

Grid Layout - Global

nopanel

true

Help

Insert excerpt

Help - Global

nopanel

true

More Actions

Opens a drop-down menu for the user to select Reverse/Correct, which opens the Reverse/Correct Journals record view and allows the user to Reverse or Reverse & Correct a journal entry.

New

Insert excerpt

New - Global

nopanel

true

Fields

Description

Checkbox

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

Account Description

Description

Checkbox

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

Account Description

Displays the name of the GL Account Description associated with the Journal line. 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'.

Database Field: ERPx_GLAccount.Description

Account Number

Displays the GL Account Number associated with the Journal line. 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'.

Database Field: ERPx_GLAccount.AccountNumber

Comment

Shows the Comment entered for the transaction. 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

Insert excerpt

	Created By
	Created By
nopanel	true

This is a required field.

Database Field: ERPx_

GLAccount

GLJournalHeader.

Description

CreatedBy

Account NumberCredit

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

Database Field: ERPx_GLAccountGLJournalLine.AccountNumberCreditAmount

CommentDebit

Shows the Comment entered for the transaction. 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

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

Database Field: ERPx_

GLJournalHeader

GLJournalLine.

Comment

DebitAmount

Created

Insert excerpt

Created

nopanel

true

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

Database Field: ERPx_

GLJournalHeader.CreatedDate
Created By

GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK

Distributed Type

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

nopanel

true

Credit

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

CreditAmount

Debit

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

MFDistributionAccountTypeEN

GL Period

Displays the name of the Project the amount is distributed to. This is not

Insert excerpt

	GL Period
	GL Period
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_GLJournalLine.DebitAmount

Distributed To

GL Year

Insert excerpt

	GL Year
	GL Year
nopanel	true

This is required and can be edited

from

by changing the '

Project

Date' field on the

Journal lines grid

Home tab of the Journal Entry record view while in a Status of 'New'.

Database Field: ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK

Distributed Type

Insert excerpt

Distributed To Type

nopanel

true

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.

Database Field: ERPx_

GLJournalLine

GLJournalHeader.

MFDistributionAccountTypeEN

JournalDate

GL Period

Journal ID

GL Period

Insert excerpt

GL Period

Journal ID - LV
	Journal ID - LV
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'.

GL Year

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

GL Year

Insert excerpt

GL Year

Journal Type
	Journal Type
nopanel	true

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

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.

Database Field: ERPx_GLJournalHeader.JournalDate

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 excerpt

	Def - Journal Type
	Def - Journal Type
nopanel	true

The list of applicable Journal Types for this page include:

Insert excerpt

	Def - Journal

ID

Type -

LV

Manual
	Def - Journal

ID

Type -

LV

Manual
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

Insert excerpt

	Def - Journal Type - Accrue & Reverse
	Def - Journal Type - Accrue & Reverse
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_GLJournalHeaderGLJournalLine.JournalID LastUpdated
Journal TypeA non-editable text box that displays the type of the corresponding journal entry. The options include "Manual" and "Accrue & Reverse"Last User
Insert excerpt
Last Updated By
Last Updated By
nopanel true
This is a required field.
Database Field: ERPx_
GLJournalHeader
GLJournalLine.
JournalTransactionTypeSK
LastUser
Last Updated Insert excerptLast UpdatedLast UpdatednopaneltrueLine 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.LastUpdatedComment
Last User Insert excerptLast Updated ByLast Updated BynopaneltrueDatabase Field: 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.LastUserJournalHeaderSK
Line Comment
A non-editable text box that displays the comment corresponding to the journal line item.
Database Field: ERPx_GLJournalLine.Comment
NoteA non-editable text box that displays the note applied to the journal entryPosted
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_GLJournalHeaderNote.NoteHTML where ERPx_GLJournalHeaderNote.JournalHeaderSK = ERPx_GLJournalLine.JournalHeaderSK GLJournalHeader.PostedDate
Posted A non-editable text box to identify the Date & Time of the Journal was PostedBy
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 populated when journals are saved as 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".
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.PostedBy
Reference
Insert excerpt
Reference
Reference
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'.
Database Field: ERPx_GLJournalHeader.
PostedDate
Reference
Posted ByA non-editable text box that displays the Source Module
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 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"functional area in which the transaction resulting in the corresponding journal entry was created. This is required and never editable.
Database Field: ERPx_GLJournalHeader.SourceModuleSK
Source Trans DateReferenceReferencenopaneltrue
Database Field: ERPx_GLJournalHeader.Reference
Source Module
Displays 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 editable.
Database Field: ERPx_GLJournalHeader.PostedBy
Reference Insert excerpt
A non-editable text box that displays the name of the functional area in which the transaction resulting in the line item's corresponding journal entry was createdSourceTransactionDate
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. This is not required and never editable.
Database Field: ERPx_GLJournalHeaderGLJournalLine.SourceModuleSKSourceTransactionID
Source Trans DateA non-editable text box that displays the date of the TypeStatus
Displays the transaction type of the source Journal transaction that resulted in the corresponding line item's journal entry, formatted from the users 'Date Format' preference. journal entry. This is not required and never editable.
Database Field: ERPx_GLJournalHeader.SourceTransactionDate
Source Trans ID
A hyperlink that displays the Journal ID for the transaction that resulted in the line item's corresponding journal entry. When clicked, the Journal Entry record view of the clicked transaction will open.
Database Field: ERPx_GLJournalLine.SourceTransactionID
Source Trans Type
A non-editable text box that displays the type of transaction that resulted in the line item's corresponding journal entry.
Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName
Insert excerptStatusStatusnopaneltrue The entry will be listed as either “New”, “Approved”, or “Ready to Post”. SourceTransactionTypeName
Status
Insert excerpt
Status
Status
nopanel true
This comes from the 'Status' on the 'Home' tab on the Journal Entry Record View. 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”.
Insert excerpt
Def - Status
Def - Status
nopanel true

This page includes all the Manual and Accrue & Reverse journal entries in a the statuses of:
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 7	New Version 8
Changes made by	Janice Dannenberg (Unlicensed)	Janice Dannenberg (Unlicensed)
Saved on	Jun 12, 2020	Jun 12, 2020

Versions Compared

Key

Page Header

Page Header

Related Topics

Page Definitions

Page Comparison

Versions Compared

Key

Page Header

Page Header

Related Topics

Page Definitions