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.

 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.12.19 and newer

Page

...

Header

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 non-editable text box that displays the date that the journal entry will post to the GL, formatted from the users 'Date Format' preference. a Status of 'New'.

Database Field: ERPx_GLJournalHeaderGLJournalLine.JournalDate DebitAmount

Database Field: ERPx_GLJournalHeader.JournalID

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

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

Database Field: ERPx_

Displays the name of the functional area in which the transaction resulting in the corresponding journal entry was created. This is required and never editableGLJournalLine.LastUser

Displays the date of the transaction that resulted in the corresponding journal entry, formatted from the users 'Date Format' preferenceIdentifies the first 30 characters from the 'Internal' Transaction Note. This is not note required and never editablecomes from the value entered in the Internal Note Type. This is always editable.

Database Field: ERPx_GLJournalHeaderNote.NoteHTML where ERPx_GLJournalHeaderNote.JournalHeaderSK = 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. GLJournalLine.JournalHeaderSK

Database Field: ERPx_GLJournalLine.SourceTransactionID

Database Field: ERPx_GLJournalHeader.TransactionStatusSK