A journal entry is a record of the business transactions in the accounting books of a business. A properly documented journal entry consists of the correct date, amounts to be debited and credited, description of the transaction and a unique reference number. 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
...
| 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 |
| ||||||||||||||||||||||||||||||||
| Fields | Description | ||||||||||||||||||||||||||||||||
| Checkbox | Used to select one or more records for Mass Update or Delete. | ||||||||||||||||||||||||||||||||
| Account Description | Displays the name of the GL Account Description associated with the Journal line. 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'. Database Field: ERPx_GLAccount.Description | ||||||||||||||||||||||||||||||||
| Account Number | Displays the GL Account Number associated with the Journal line. 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'. Database Field: ERPx_GLAccount.AccountNumber | ||||||||||||||||||||||||||||||||
| Comment | Shows the Comment entered for the transaction. 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 |
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 FieldFields: ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK | ||||||||||||||||||||||||||||||||
| Distributed Type |
Database Field: ERPx_GLJournalLine.MFDistributionAccountTypeEN | ||||||||||||||||||||||||||||||||
| GL Period |
| ||||||||||||||||||||||||||||||||
| GL Year |
| ||||||||||||||||||||||||||||||||
| 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 |
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 | 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".
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".
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. 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. 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. 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. Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName | ||||||||||||||||||||||||||||||||
| Status |
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 |
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"....