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 systemA 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: 20192020.09xx.03 and xx and newer
| Table of Contents | ||
|---|---|---|
|
...
| 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 pageJournals record view and allows the user to either 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 line item account.Linked 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 account number of the line item distribution.Linked 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 | ||||||||||
| Checkbox | Used to select one or more records for Mass Update or Delete. | ||||||||||
| Comment | A non-editable text box that displays the comment entered for the journal entry. Linked 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 where | ||||||||||
| Created By |
Database Field: ERPx_GLJournalHeader.CreatedBy | ||||||||||
| Credit | Displays the amount credited from the Journal line item. This column is summed at the footer of the page. Database Field: ERPx_GLJournalLine.CreditAmount | ||||||||||
| Debit | Displays the amount debited from the Journal 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. Linked 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 Field: ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK | ||||||||||
| Distributed Type |
This text box contains the value in the MFDistributionType Enumeration Class where MFDistributionType = 2 . 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. Linked 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 |
Linked Database Field: ERPx_GLJournalLine.LastUpdated | ||||||||||
| Last User |
Linked Database Field: ERPx_GLJournalLine.LastUser | ||||||||||
| 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".
Linked Database Field: ERPx_GLJournalHeader.PostedDate | ||||||||||
| 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 |
Linked Database Field: ERPx_GLJournalHeader.Reference | ||||||||||
| 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 |
Linked 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"....