Journal Entries created in NorthScope are designed to push to the host system when their Status is set to "Ready to Post". Journal Entries created in NorthScope will integrate as a Source Document of "General Journal" in the host system, allowing users to create and manage Manual and Accrue & Reverse type journal entries within NorthScope. The list view contains all manual Journal Entries that have not yet been posted in the host system.Software Version: 2019.09.03 and
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
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
| Table of Contents | ||
|---|---|---|
|
Page Header
| Toolbar Icons | Description | |||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column Filter Show/Hide |
| |||||||||||||||||||||||||||||||||||||||||
| Delete |
| |||||||||||||||||||||||||||||||||||||||||
| Edit |
| |||||||||||||||||||||||||||||||||||||||||
| Excel |
| |||||||||||||||||||||||||||||||||||||||||
| Favorites |
| |||||||||||||||||||||||||||||||||||||||||
| Grid LayoutGroup By Show/Hide |
| |||||||||||||||||||||||||||||||||||||||||
| Help |
| |||||||||||||||||||||||||||||||||||||||||
| Mass UpdateMore Actions |
| |||||||||||||||||||||||||||||||||||||||||
| New | Checkbox |
| Print - LV |
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
A non-editable text box that displays the comment entered for the journal entry.
Linked Database Field: ERPx_GLJournalHeader.Comment
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Insert excerpt |
|---|
|
Linked Database Field: ERPx_GLJournalHeader.CreatedDate
| Insert excerpt |
|---|
|
Linked Database Field: ERPx_GLJournalHeader.CreatedBy
GL PeriodInsert 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
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.
LinkedDef - 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
A non-editable text box that displays the type of the corresponding journal entry. The options include "Manual" and "Accrue & Reverse".
Linked
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'.Insert excerpt Comment Comment nopanel true
Database Field: ERPx_GLJournalHeader.
Comment
Linked This is a required field.Insert excerpt Last Updated (Date & Time) - List View/Inquiry Last Updated (Date & Time) - List View/InquiryCreated Created nopanel true
Database Field: ERPx_GLJournalHeader.LastUpdatedCreatedDate
Insert excerpt
This is a required field.Created By Created By nopanel true
Database Field: ERPx_GLJournalHeader.
CreatedBy
A non-editable text box that displays the note applied to the journal entry.
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_
A non-editable text box to identify the Date & Time of the Journal was Posted. This is a system assigned value and is never editable by a user. This field 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".
Linked Database Field: ERPx_GLJournalHeader.PostedDate
A non-editable text box that 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 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".
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
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 Date GL Date nopanel true
Database Field: ERPx_GLJournalHeader.
JournalDate
Insert excerpt
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.Journal ID - LV Journal ID - LV nopanel true
Database Field: ERPx_GLJournalHeader.
JournalID
A non-editable text box that displays the name of the functional area in which the transaction resulting in the corresponding journal entry was created.
Linked Database Field: ERPx_GLJournalHeader.SourceModuleSK
A non-editable text box that displays the date of the transaction that resulted in the corresponding journal entry, formatted from the users 'Date Format' preference.
Linked Database Field: ERPx_GLJournalHeader.SourceTransactionDate
A hyperlink that displays the Journal ID for the transaction that resulted in the corresponding journal entry. When clicked, the Journal Entry record view of the clicked transaction will open.
Linked Database Field: ERPx_GLJournalHeader.SourceTransactionSK
A non-editable text box that displays the transaction type of the transaction that resulted in the corresponding journal entry.
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 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
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
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
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'.Insert excerpt Comment Comment nopanel true
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
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'.Insert excerpt Reference Reference nopanel true
Database Field: ERPx_GLJournalHeader.
Reference
Insert excerpt Status
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.nopanel true
The entry will be listed as either “New”
or “Approved”
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
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
| Expand | ||
|---|---|---|
| ||
Technical Details |