Insert excerpt
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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 |
| nopanel | true
|
- Manual
- Accrue & Reverse
Selecting a journal entry type opens a blank journal entry record.
Insert excerpt GL Account Description
GL Account Description
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 nopanel true
while in a Status of 'New'.
Insert excerpt Def - GL Account Description Def - GL Account Description nopanel true
Database Field: ERPx_GLAccount.Description
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 Insert excerpt GL Account ID GL Account ID nopanel true
while in a Status of 'New'.
Insert excerpt Def - GL Account ID Def - GL Account ID nopanel true
Database Field: ERPx_GLAccount.AccountNumber
Shows the Comment entered for the transaction. This Insert excerpt Comment
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'.Comment nopanel true
Database Field: ERPx_GLJournalHeader.Comment
This is a required field. Insert excerpt Created Created nopanel true
Database Field: ERPx_GLJournalHeader.CreatedDate
This is a required field. Insert excerpt Created By Created By nopanel true
Database Field: ERPx_GLJournalHeader.CreatedBy
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
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
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
This is not required and is not editable. Journal lines displayed from this list view will always be of type 'Project'. Insert excerpt Distributed To Type Distributed To Type nopanel true
Database Field: ERPx_GLJournalLine.MFDistributionAccountTypeEN
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'. 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'. Insert excerpt GL Year GL Year nopanel true
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
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 Record View and is auto-assigned when a new Journal Entry is initially saved/created. This is never editable. Insert excerpt Journal ID - LV Journal ID - LV nopanel true
Database Field: ERPx_GLJournalHeader.JournalID
This is required and comes from the 'Journal Type' in the header of the 'Home' tab on the Journal Entry Record View and is auto-assigned based on the type of journal entry selected on New. This is never editable. Insert excerpt Journal Type Journal Type nopanel true
The list of applicable Journal Types for this page include: Insert excerpt Def - Journal Type Def - Journal Type nopanel true
Insert excerpt Def - Journal Type - Manual Def - Journal Type - Manual nopanel true
Insert excerpt Def - Journal Type - Accrue & Reverse Def - Journal Type - Accrue & Reverse nopanel true
Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK
This is a required field. Insert excerpt Last Updated Last Updated nopanel true
Database Field: ERPx_GLJournalLine.LastUpdated
This is a required field. Insert excerpt Last Updated By Last Updated By nopanel true
Database Field: ERPx_GLJournalLine.LastUser
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
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
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".
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".
Database Field: ERPx_GLJournalHeader.PostedDate
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 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".
Database Field: ERPx_GLJournalHeader.PostedBy
This comes from the 'Reference' in the header of the 'Home' tab on the Journal Entry Record View. 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'. Insert excerpt Reference Reference nopanel true
Database Field: ERPx_GLJournalHeader.Reference
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 as it is always "Financial" for manually created JE's
Database Field: ERPx_GLJournalHeader.SourceModuleSK
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 as it is always blank for manually created JE's
Database Field: ERPx_GLJournalHeader.SourceTransactionDate
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 as it is always blank for manually created JE's
Database Field: ERPx_GLJournalLine.SourceTransactionID
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 as it is always blank for manually created JE's
Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName
This comes from the 'Status' on the 'Home' tab on the Journal Entry Record View. This is only editable for Journal Entries in a Status of New or Approved. Insert excerpt Status Status nopanel true
The entry will be listed as either “New” , “Approved”, or “Ready to Post”. or “Approved”
This page includes all the Manual and Accrue & Reverse journal entries in a the statuses of The Statuses that apply to transactions in this List View include: Insert excerpt Def - Status Def - Status nopanel true
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
...