Versions Compared

Key

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

Insert excerptDef - Journal EntryDef - Journal Entrynopaneltrue The purpose

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. 

Software Version: 2020.xx.xx and newer

...

true

Toolbar IconsDescription
Delete
Insert excerpt
Delete - LV
Delete - LV
nopaneltrue
Edit
Insert excerpt
Edit - LV
Edit - LV
nopaneltrue
Excel
Insert excerpt
Excel - LV
Excel - LV
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
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.
New

Insert excerpt
New - Multi-Select Trans Type - Global
New - Multi-Select Trans Type - Global

nopanel
nopaneltrue

  • Manual
  • Accrue & Reverse

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

FieldsDescriptionCheckboxUsed 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

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

while in a Status of 'New'.

Insert excerpt
Def - GL Account Description
Def - GL Account Description
nopaneltrue

Database Field: ERPx_GLAccount.Description

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

Insert excerpt
GL Account ID
GL Account ID
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'.

while in a Status of 'New'.

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

Database Field: ERPx_GLAccount.AccountNumber

Comment

Insert excerpt
Comment
Shows the Comment entered for the transaction.  This
Comment
nopaneltrue
 
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
nopaneltrue
This is a required field.

Database Field: ERPx_GLJournalHeader.CreatedDate

Created By

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

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

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

GL Period

Insert excerpt
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 Year

Insert excerpt
GL Year
GL Year
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

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

Insert excerpt
Def - Journal Type - Manual
Def - Journal Type - Manual
nopaneltrue

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

Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK

Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue
This is a required field.

Database Field: ERPx_GLJournalLine.LastUpdated

Last User

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue
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".

(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

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

(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 excerpt
Reference
Reference
nopaneltrue
This comes from the 'Reference' in the header of the 'Home' tab on the Journal Entry Record ViewThis 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.Reference

Source 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 editable.

journal entry was created. This is required and never editable.

This column should be removed from this List View as it is always "Financial" for manually created JE's

Database Field: ERPx_GLJournalHeader.SourceModuleSK

Source Trans Date

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.

This column should be removed from this List View as it is always blank for manually created JE's

Database Field: 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. This is not required and

never editable.

never editable.

This column should be removed from this List View as it is always blank for manually created JE's

Database Field: ERPx_GLJournalLine.SourceTransactionID

Source Trans Type

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

This column should be removed from this List View as it is always blank for manually created JE's

Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName

Status

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

Insert excerpt
Def - Status
Def - Status
nopaneltrue
 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
nopaneltrue

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

Database Field: ERPx_GLJournalHeader.TransactionStatusSK

...