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. Insert excerpt Def - Journal Entry Def - Journal Entry nopanel true
Software Version: 2020.xx.xx and newer
...
| Toolbar Icons | Description | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Delete |
| ||||||||||||||||||||||||||||||||
| Edit |
| ||||||||||||||||||||||||||||||||
| Excel |
| ||||||||||||||||||||||||||||||||
| Favorites |
| ||||||||||||||||||||||||||||||||
| Grid Layout |
| ||||||||||||||||||||||||||||||||
| Help |
| ||||||||||||||||||||||||||||||||
| More Actions | Opens 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 |
Selecting a journal entry type opens a blank journal entry record. | ||||||||||||||||||||||||||||||||
| Fields | Description | ||||||||||||||||||||||||||||||||
| Checkbox | Used to select one or more records for Mass Update or Delete. | ||||||||||||||||||||||||||||||||
| Account Description |
Database Field: ERPx_GLAccount.Description | ||||||||||||||||||||||||||||||||
| Account Number |
Database Field: ERPx_GLAccount.AccountNumber | ||||||||||||||||||||||||||||||||
| Comment |
Database Field: ERPx_GLJournalHeader.Comment | ||||||||||||||||||||||||||||||||
| Created |
Database Field: ERPx_GLJournalHeader.CreatedDate | ||||||||||||||||||||||||||||||||
| Created By |
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 |
Database Field: ERPx_ | GLJournalLine.MFDistributionAccountTypeENGL Period GLJournalLine.MFDistributionAccountTypeEN | |||||||||||||||||||||||||||||||
| GL Period |
| ||||||||||||||||||||||||||||||||
| GL Year |
| Period
| Period
| ||||||||||||||||||||||||||||||
| Journal Date |
| Year
| Year
| Journal Date | Database Field: ERPx_GLJournalHeader.JournalDate | ||||||||||||||||||||||||||||
| Journal ID |
Database Field: ERPx_GLJournalHeader.JournalID | ||||||||||||||||||||||||||||||||
| Journal Type |
Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK | ||||||||||||||||||||||||||||||||
| Last Updated |
Database Field: ERPx_GLJournalLine.LastUpdated | ||||||||||||||||||||||||||||||||
| Last User |
Database Field: ERPx_GLJournalLine.LastUser | ||||||||||||||||||||||||||||||||
| Line Comment | corresponding to the Journal line.
| Displays the comment
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
| Journal Entry transactions are in a status of "Ready to Post".Journal Entry transactions are in a status of "Ready to Post". This column should be removed from this List View, but left in the Inquiry, as it is always blank for unposted transactions 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".
This column should be removed from this List View, but left in the Inquiry, as it is always blank for unposted transactions Database Field: ERPx_GLJournalHeader.PostedBy | ||||||||||||||||||||||||||||||||
| Reference |
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. This column should be removed from this List View, but left in the Inquiry, 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, but left in the Inquiry, 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. This column should be removed from this List View, but left in the Inquiry, 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, but left in the Inquiry, as it is always blank for manually created JE's Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName | ||||||||||||||||||||||||||||||||
| Status |
The entry will be listed as either “New” or “Approved”
Database Field: ERPx_GLJournalHeader.TransactionStatusSK |
...