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 the journal lines from manual Journal Entries that have not yet been posted in the host system.
Software Version: 2019.09.03 and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
...
Displays the name of the line item account.
Linked Database Field: ERPx_GLAccount.Description
...
Displays the account number of the line item distribution.
Linked Database Field: ERPx_GLAccount.AccountNumber
...
A non-editable text box that displays the comment entered for the journal entry.
...
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 |
| ||||||||||||||||||||||||||||||||||||
| Group By Show/Hide |
| ||||||||||||||||||||||||||||||||||||
| Help |
| ||||||||||||||||||||||||||||||||||||
| More Actions |
| ||||||||||||||||||||||||||||||||||||
| New |
| ||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||
| Quick Column Filter |
| ||||||||||||||||||||||||||||||||||||
| Saved Layouts |
| ||||||||||||||||||||||||||||||||||||
| 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 where | ||||||||||||||||||||||||||||||||||||
| Created By |
Linked Database Field: ERPx_GLJournalHeader.CreatedBy | ||||||||||||||||||||||||||||||||||||
| Credit | Displays the amount credited from the line item. This column is summed at the footer of the page. Database Field: ERPx_GLJournalLine.CreditAmount | ||||||||||||||||||||||||||||||||||||
| Debit | Displays the amount debited from the line item. This column is summed at the footer of the page. 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 the amount is distributed to.Linked Database Field' 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 | Displays the type of distribution
This text box contains the value in the MFDistributionType Enumeration Class where MFDistributionType = 2 Project'. Database Field: ERPx_GLJournalLine.MFDistributionAccountTypeEN | ||||||||||||||||||||||||||||||||||||
| GL Period |
| ||||||||||||||||||||||||||||||||||||
| GL Year |
| ||||||||||||||||||||||||||||||||||||
| Journal Date |
| 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. LinkedThis 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'. Database Field: ERPx_GLJournalHeader. JournalDate | ||||||||||||||||||||||||||||||||||
| Journal ID |
A hyperlink that displays the system assigned Journal ID. This number is automatically generated by the system and cannot be edited. When the journal entry integrates with the host system, it will inherit the next journal ID from the host system. When clicked, the Journal Entry record view of the clicked transaction will open. Linked
Database Field: ERPx_GLJournalHeader .JournalID | ||||||||||||||||||||||||||||||||||||
| Journal Type |
| A non-editable text box that displays the type of the corresponding journal entry. The options include "Manual" and "Accrue & Reverse". Linked Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK | Last Updated | ||||||||||||||||||||||||||||||||||
| Insert excerpt | Last Updated | Last Updated | |||||||||||||||||||||||||||||||||||
| nopanel | true | Last User | |||||||||||||||||||||||||||||||||||
| Insert excerpt | Last Updated By | Last Updated By | |||||||||||||||||||||||||||||||||||
| nopanel | true | ||||||||||||||||||||||||||||||||||||
| Line Comment | A non-editable text box that displays the comment corresponding to the journal line item. Linked Database Field: ERPx_GLJournalLine.Comment | ||||||||||||||||||||||||||||||||||||
| Note | A non-editable text box that displays the note applied to the journal entry. Linked Database Field: ERPx_GLJournalHeaderNote.NoteHTML where ERPx_GLJournalHeaderNote.JournalHeaderSK = ERPx_GLJournalLine.JournalHeaderSK | ||||||||||||||||||||||||||||||||||||
| Posted | 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".
Manual Journal Entry: Accrue & Reverse Journal Entry: Correct: Database Field: ERPx_GLJournalHeader. JournalTransactionTypeSK | ||||||||||||||||||||||||||||||||||||
| Posted By | 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".
Linked Database Field: ERPx_GLJournalHeader.PostedBy | Reference | |||||||||||||||||||||||||||||||||||
| Insert excerpt | Reference - LV | Reference - LV | |||||||||||||||||||||||||||||||||||
| nopanel | true | ||||||||||||||||||||||||||||||||||||
| Source Module | A non-editable text box that displays the name of the functional area in which the transaction resulting in the line item's corresponding journal entry was created. Linked Database Field: ERPx_GLJournalHeader.SourceModuleSK | ||||||||||||||||||||||||||||||||||||
| Source Trans Date | A non-editable text box that displays the date of the transaction that resulted in the corresponding line item's journal entry, formatted from the users 'Date Format' preference. Linked Database Field: ERPx_GLJournalHeader.SourceTransactionDate | ||||||||||||||||||||||||||||||||||||
| Source Trans ID | A hyperlink that displays the Journal ID for the transaction that resulted in the line item's corresponding journal entry. When clicked, the Journal Entry record view of the clicked transaction will open. Linked Database Field: ERPx_GLJournalLine.SourceTransactionID | ||||||||||||||||||||||||||||||||||||
| Source Trans Type | A non-editable text box that displays the type of transaction that resulted in the line item's corresponding journal entry. Linked Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName | ||||||||||||||||||||||||||||||||||||
| Status | | Insert excerpt | | Status | Status | |||||||||||||||||||||||||||||||||
| nopanel | true |
Database Field: ERPx_GLJournalLine.LastUpdated | |||||||||||||||||||||||||||||||||||
| Last Updated By |
Database Field: ERPx_GLJournalLine.LastUser | ||||||||||||||||||||||||||||||||||||
| Line 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 | ||||||||||||||||||||||||||||||||||||
| Reference |
Database Field: ERPx_GLJournalHeader.Reference | ||||||||||||||||||||||||||||||||||||
| Status |
The entry will be listed as either “New” or “Approved”
Database Field: ERPx_GLJournalHeader.TransactionStatusSK |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
| Expand | ||
|---|---|---|
| ||
Technical Details |