Insert excerpt |
---|
| Def - Journal Entry |
---|
| Def - Journal Entry |
---|
nopanel | true |
---|
|
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.
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
Toolbar Icons | Description |
---|
Column Filter Show/Hide | Insert excerpt |
---|
| Column Filter Show/Hide - Global |
---|
| Column Filter Show/Hide - Global |
---|
nopanel | true |
---|
|
|
Delete | Insert excerpt |
---|
| Delete - LV 3.0 |
---|
| Delete - LV 3.0 |
---|
nopanel | true |
---|
|
|
Edit | Insert excerpt |
---|
| Edit - LV 3.0 |
---|
| Edit - LV 3.0 |
---|
nopanel | true |
---|
|
|
Excel | Insert excerpt |
---|
| Excel - LV 3.0 |
---|
| Excel - LV 3.0 |
---|
nopanel | true |
---|
|
|
Favorites | Insert excerpt |
---|
| Favorites Add/Remove - Global |
---|
| Favorites Add/Remove - Global |
---|
nopanel | true |
---|
|
|
Group By Show/Hide | Insert excerpt |
---|
| Group By Show/Hide - Global |
---|
| Group By Show/Hide - Global |
---|
nopanel | true |
---|
|
|
Help | Insert excerpt |
---|
| Help - Global 3.0 |
---|
| Help - Global 3.0 |
---|
nopanel | true |
---|
|
|
More Actions | Insert excerpt |
---|
| More Actions - Global 3.0 |
---|
| More Actions - Global 3.0 |
---|
nopanel | true |
---|
|
- 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 |
---|
nopanel | true |
---|
| - Manual: Opens a blank journal entry record.
Insert excerpt |
---|
| Def - Journal Entry |
---|
| Def - Journal Entry |
---|
nopanel | true |
---|
|
- Accrue & Reverse: Opens a blank Accrue & Reverse journal entry record.
Insert excerpt |
---|
| Def - Journal Entry - Accrue & Reverse |
---|
| Def - Journal Entry - Accrue & Reverse |
---|
nopanel | true |
---|
|
- Unrealized Currency Gain/Loss: Opens a blank Unrealized Gain/Loss record.
Insert excerpt |
---|
| Def - Unrealized Gain/Loss |
---|
| Def - Unrealized Gain/Loss |
---|
nopanel | true |
---|
|
|
Print | Insert excerpt |
---|
| Print - LV 3.0 |
---|
| Print - LV 3.0 |
---|
nopanel | true |
---|
|
|
Quick Column Filter | Insert excerpt |
---|
| Quick Column Filter |
---|
| Quick Column Filter |
---|
nopanel | true |
---|
|
|
Saved Layouts | Insert excerpt |
---|
| Column Layouts for Framework 3.0 - Global |
---|
| Column Layouts for Framework 3.0 - Global |
---|
nopanel | true |
---|
|
|
Fields | Description |
Checkbox | Used to select one or more records for Mass Update or Delete. |
Account Description | Insert excerpt |
---|
| GL Account Description |
---|
| GL Account Description |
---|
nopanel | true |
---|
| 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 |
---|
nopanel | true |
---|
|
Database Field: ERPx_GLAccount.Description |
Account Number | Insert excerpt |
---|
| GL Account ID |
---|
| GL Account ID |
---|
nopanel | true |
---|
| 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 ID |
---|
| Def - GL Account ID |
---|
nopanel | true |
---|
|
Database Field: ERPx_GLAccount.AccountNumber |
Comment | Insert excerpt |
---|
| Comment |
---|
| Comment |
---|
nopanel | true |
---|
| 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_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 |
---|
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.MFDistributionAccountTypeEN |
GL Period | 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'.
|
GL Year | Insert excerpt |
---|
| GL Year |
---|
| GL Year |
---|
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'.
|
Journal Date | Insert excerpt |
---|
| GL Date |
---|
| GL Date |
---|
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_GLJournalHeader.JournalDate
|
Journal ID | Insert excerpt |
---|
| Journal ID - LV |
---|
| Journal ID - LV |
---|
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 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 |
---|
nopanel | true |
---|
| 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 |
---|
nopanel | true |
---|
| The list of applicable Journal Types for this page include:
Manual Journal Entry: Insert excerpt |
---|
| Def - Journal Entry |
---|
| Def - Journal Entry |
---|
nopanel | true |
---|
|
Accrue & Reverse Journal Entry: Insert excerpt |
---|
| Def - Journal Entry - Accrue & Reverse |
---|
| Def - Journal Entry - Accrue & Reverse |
---|
nopanel | true |
---|
|
Correct: Insert excerpt |
---|
| Def - Journal Type - Reverse & Correct |
---|
| Def - Journal Type - Reverse & Correct |
---|
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_GLJournalLine.LastUpdated |
Last Updated By | Insert excerpt |
---|
| Last Updated By |
---|
| Last Updated By |
---|
nopanel | true |
---|
| This is a required field.
Database Field: ERPx_GLJournalLine.LastUser |
Line Comment | Insert excerpt |
---|
| Comment |
---|
| Comment |
---|
nopanel | true |
---|
| 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 |
Reference | Insert excerpt |
---|
| Reference |
---|
| Reference |
---|
nopanel | true |
---|
| 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” or “Approved” Insert excerpt |
---|
| Def - Status |
---|
| Def - Status |
---|
nopanel | true |
---|
| The Statuses that apply to transactions in this List View include:
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 |
...