The purpose of the Journal Entries List View is to show (open/unposted) 'Manual' and 'Accrue & Reverse' journal entries 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

[ 1 Page Header ] [ 1.1 Related Topics ] [ 1.1.1 Page Definitions ] [ 1.1.2 Technical Details ]

Page Header

Toolbar Icons	Description

Toolbar Icons	Description
Column Filter Show/Hide
Delete
Edit
Excel
Favorites
Group By Show/Hide
Help
Mass Update	Status: A single-select lookup that defaults to "(No Change)", but also has options for "New", "Approved" and "Ready to Post". Assigns the selected Status to selected/filtered transactions when the 'Apply' icon is clicked.
More Actions	Reverse/Correct: Opens the Reverse/Correct page and allows the user to either Reverse or Correct a journal entry.
New	Manual: Opens a blank journal entry record. Accrue & Reverse: Opens a blank Accrue & Reverse journal entry record. Unrealized Currency Gain/Loss: Opens a blank Unrealized Gain/Loss record.
Notes
Print
Quick Column Filter
Saved Layouts
Fields	Description
Checkbox
Comment	This is not required and comes from the 'Comment' in the header of the Home tab on the Journal Entry RV. 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	This is a required field. Database Field: ERPx_GLJournalHeader.CreatedDate
Created By	This is a required field. Database Field: ERPx_GLJournalHeader.CreatedBy
GL Period	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	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	This comes from the 'Date' in the header of the 'Home' tab on the Journal Entry RV. This defaults to the current date and is only editable for journal entries in a Status of 'New'. Database Field: ERPx_GLJournalHeader.JournalDate
Journal ID	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.JournalID
Journal Type	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. The list of applicable Journal Types for this page include: Manual Journal Entry: Accrue & Reverse Journal Entry: Correct: Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK
Last Updated	This is a required field. Database Field: ERPx_GLJournalHeader.LastUpdated
Last Updated By	This is a required field. Database Field: ERPx_GLJournalHeader.LastUser
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_GLJournalHeader.JournalHeaderSK
Reference	This comes from the 'Reference' in the header of the 'Home' tab on the Journal Entry RV. 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.Reference
Status	This comes from the 'Status' on the 'Home' tab on the Journal Entry RV. 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”. This page includes all the Manual and Accrue & Reverse journal entries in a the statuses of: Database Field: ERPx_GLJournalHeader.TransactionStatusSK