Versions Compared

Version Old Version 13 New Version Current
Changes made by

Janice Dannenberg

Emma Greenwood

Saved on

Key

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

Insert excerptDef - Journal EntryDef - Journal Entrynopaneltrue

Insert excerpt
Def - Journal Entry
Def - Journal Entry
nopaneltrue
 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. Reverse' journal entries. When these are posted, the General Ledger is updated. 

(lightbulb) 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: 20202023.xx12.xx 19 and newer

Table of Contents
typeflat

Page Header

Excel
Toolbar IconsDescriptionDelete
Insert excerpt
Delete - LVDelete - LV
nopaneltrue
Edit
Insert excerpt
Edit - LVEdit - LV
nopaneltrue
Description
Column Filter Show/Hide
Insert excerpt
Excel - LVExcel - LVColumn Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
FavoritesDelete
Insert excerpt
Favorites Add/Remove - GlobalFavorites Add/Remove - GlobalDelete - LV 3.0
Delete - LV 3.0
nopaneltrue
Grid LayoutEdit
Insert excerpt
Grid Layout - GlobalGrid Layout - GlobalEdit - LV 3.0
Edit - LV 3.0
nopaneltrue
HelpExcel
Insert excerpt
Help - GlobalHelp - GlobalExcel - LV 3.0
Excel - LV 3.0
nopaneltrue
More ActionsOpens 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.
NewFavorites
Insert excerpt
New - Multi-Select Trans Type
Favorites Add/Remove - Global
New - Multi-Select Trans Type -
Favorites Add/Remove - Global
nopaneltrue
  • Manual
  • Accrue & Reverse

Selecting a journal entry type opens a blank journal entry record.

FieldsDescription
CheckboxUsed to select one or more records for Mass Update or Delete.
Account DescriptionGroup By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
HelpGL Account Description
Insert excerpt
GL Account Description
Help - Global 3.0
Help - Global 3.0
nopaneltrue
 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'.More ActionsDef - GL Account Description

Insert excerpt

Def - GL Account Description

More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

Database Field: ERPx_GLAccount.Description

Account Number Insert excerptGL Account IDGL Account IDnopaneltrue 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'.
  • 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
nopaneltrue
 

  • Manual: Opens a blank journal entry record.  
    Insert excerpt
    Def -
GL Account ID
  • Journal Entry
    Def -
GL Account ID
  • Journal Entry
    nopaneltrue

Database Field: ERPx_GLAccount.AccountNumber

Comment Insert excerptCommentCommentnopaneltrue 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 excerptCreatedCreatednopaneltrue This is a required field.

Database Field: ERPx_GLJournalHeader.CreatedDate

Created By Insert excerptCreated ByCreated Bynopaneltrue This is a required field.

Database Field: ERPx_GLJournalHeader.CreatedBy

Credit 

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

Database Field: ERPx_GLJournalLine.CreditAmount

DebitDisplays 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
  • Accrue & Reverse: Opens a blank Accrue & Reverse journal entry record. 
    Insert excerpt
    Def - Journal Entry - Accrue & Reverse
    Def - Journal Entry - Accrue & Reverse
    nopaneltrue
  • Unrealized Currency Gain/Loss: Opens a blank Unrealized Gain/Loss record. 
    Insert excerpt
    Def - Unrealized Gain/Loss
    Def - Unrealized Gain/Loss
    nopaneltrue
Print
Insert excerpt
Print - LV 3.0
Print - LV 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescriptionCheckboxUsed to select one or more records for Mass Update or Delete.Account Description

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

Database Field: ERPx_

GLJournalLine.DebitAmount
Distributed ToDisplays the name of the Project the amount is distributed to. This is not required

GLAccount.Description

Account Number

Insert excerpt
GL Account ID
GL Account ID
nopaneltrue
 This is required to save a Journal line and can be edited from the '

Project

Account Number' field on the Journal lines grid of the Journal Entry record view while in a Status

of 'New'.
Database Fields

of 'New'.

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

Database Field: ERPx_

GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSKDistributed Type

GLAccount.AccountNumber

Comment

Distributed To Type

Insert excerpt
Distributed To Type
Comment
Comment
nopaneltrue
 This is not required and is not editable. Journal lines displayed from this list view will always be of type 'Projectcomes 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_GLJournalLineGLJournalHeader.MFDistributionAccountTypeENComment

GL PeriodCreated

Insert excerpt
GL Period
Created
GL Period
Created
nopaneltrue
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

a required field.

Database Field: ERPx_GLJournalHeader.CreatedDate

Created By

GL Year

Insert excerpt
GL Year
Created By
Created By
nopaneltrue
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 excerptGL DateGL Datenopaneltrue This is required and can be edited by changing the 'Date' field on the Home tab a required field.

Database Field: ERPx_GLJournalHeader.CreatedBy

Credit 

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

Database Field: ERPx

_GLJournalHeader.JournalDate
Journal ID Insert excerptJournal ID - LVJournal ID - LVnopaneltrue 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

_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 of the Journal Entry record view while in a Status of 'New'.

Database Field: ERPx_

GLJournalHeader

GLJournalLine.

JournalID

DebitAmount

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 & ReversenopaneltrueDistributed To

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 Fields: ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK

Distributed Type

Insert excerpt
Distributed To Type
Distributed To Type
nopaneltrue
This is not required and is not editable. Journal lines displayed from this list view will always be of type 'Project'.

Database Field: ERPx_GLJournalHeaderGLJournalLine.JournalTransactionTypeSK MFDistributionAccountTypeEN

Last UpdatedGL Period

Insert excerpt
Last UpdatedLast Updatednopaneltrue This is a required field.

Database Field: ERPx_GLJournalLine.LastUpdated

Last User

GL Period
GL Period
nopaneltrue
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 YearLast Updated By

Insert excerpt

Last Updated By

GL Year
GL Year
nopaneltrue
This is

a required field.

Database Field: ERPx_GLJournalLine.LastUser

Line Comment

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

Insert excerpt
Comment
GL Date
Comment
GL Date
nopaneltrue
 This is not required and can be edited by changing the 'Line CommentDate' field on the Journal lines grid Home tab of the Journal Entry record view while in a Status of 'New'.

Database Field: ERPx_GLJournalLine.Comment

Note

GLJournalHeader.JournalDate

Journal ID

Insert excerpt
Journal ID - LV
Journal ID - LV
nopaneltrue
 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_

GLJournalHeaderNote.NoteHTML where ERPx_GLJournalHeaderNote.JournalHeaderSK = ERPx_GLJournalLine.JournalHeaderSK Posted

GLJournalHeader.JournalID

Journal Type

Posted Date

Insert excerpt
Posted Date
Journal Type
Journal Type
nopaneltrue
 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".

(lightbulb) 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 Insert excerptPosted ByPosted Bynopaneltrue This field is not required and is populated when journals are saved as "Ready to Post". 

(lightbulb) 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 excerptReferenceReferencenopaneltrue 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 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
Def - Journal Type
Def - Journal Type
nopaneltrue
 The list of applicable Journal Types for this page include:

Manual Journal Entry: 

Insert excerpt
Def - Journal Entry
Def - Journal Entry
nopaneltrue

Accrue & Reverse Journal Entry: 

Insert excerpt
Def - Journal Entry - Accrue & Reverse
Def - Journal Entry - Accrue & Reverse
nopaneltrue

Correct: 

Insert excerpt
Def - Journal Type - Reverse & Correct
Def - Journal Type - Reverse & Correct
nopaneltrue

Database Field: ERPx_GLJournalHeader.ReferenceJournalTransactionTypeSK

Source ModuleLast Updated

Source Module

Insert excerpt
Source Module
Last Updated
Last Updated
nopaneltrue
 This is required for all journal entries that are linked to a transaction and is never editablea required field.

Database Field: ERPx_GLJournalHeaderGLJournalLine.SourceModuleSK

Source Trans Date

LastUpdated

Last Updated BySource Transaction Date

Insert excerpt

Source Transaction Date

Last Updated By
Last Updated By
nopaneltrue

 

This is

required for all journal entries that are linked to a transaction and is never editable

a required field.

Database Field: ERPx_

GLJournalHeader

GLJournalLine.

SourceTransactionDateSource Trans ID

LastUser

Line Comment

Source Transaction ID

Insert excerpt
Source Transaction ID
Comment
Comment
nopaneltrue
 Clicking the link opens Journal Entry Record View of the selected transaction. This is required for all journal entries that are linked to a transaction and is never editable
 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.

SourceTransactionID

JournalHeaderSK

Source Trans TypeReference

Source Transaction Type

Insert excerpt
Source Transaction Type
Reference
Reference
nopaneltrue
This comes from the 'Reference' in the header of the 'Home' tab on the Journal Entry RV. This is not required for all journal entries that are linked to a transaction and is never editableand 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.SourceTransactionTypeNameReference

Status

Insert excerpt
Status
Status
nopaneltrue
 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” or “Approved”

Insert excerpt
Def - Status
Def - Status
nopaneltrue
 The Statuses that apply to transactions in this List View include:

Insert excerpt
Def - Status - New
Def - Status - New
nopaneltrue

Insert excerpt
Def - Status - Approved
Def - Status - Approved
nopaneltrue

Database Field: ERPx_GLJournalHeader.TransactionStatusSK

Related Topics



Expand
titlePage Definitions

Page Definitions



Expand
titleTechnical Details

Technical Details