Versions Compared

Key

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

Insert excerpt
Def - Journal Entry
Def - Journal Entry
nopaneltrue
 

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. 

(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: 2023.0812.11 19 and newer

Table of Contents
typeflat

Page Header

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Delete
Insert excerpt
Delete - LV 3.0
Delete - LV 3.0
nopaneltrue
Edit
Insert excerpt
Edit - LV 3.0
Edit - LV 3.0
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
Mass Update

Insert excerpt
Mass Update - Global 3.0
Mass Update - Global 3.0
nopaneltrue

  • StatusA 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

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue
 

  • 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 - Journal Entry
    Def - Journal Entry
    nopaneltrue
  • 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
Notes
Insert excerpt
Notes - Global 3.0
Notes - Global 3.0
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
FieldsDescription
Checkbox

Insert excerpt
Checkbox
Checkbox
nopaneltrue
 

Comment

Insert excerpt
Comment
Comment
nopaneltrue
 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

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

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

Insert excerpt
GL Date
GL Date
nopaneltrue
 This comes from the 'Date' in the header of the 'Home' tab on the Journal Entry RVThis defaults to the current date and is only editable for journal entries in a Status of 'New'.

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

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

Last Updated

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

Database Field: ERPx_GLJournalHeader.LastUpdated

Last Updated By

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

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

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

Insert excerpt
Def - Status
Def - Status
nopaneltrue
 

This page includes all the Manual and Accrue & Reverse journal entries in a the statuses of:

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

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

Database Field: ERPx_GLJournalHeader.TransactionStatusSK

...