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
Page Header
| Toolbar Icons | Description |
|---|---|
| Delete | Deletes the selected record(s). When clicked, users will be prompted with: "Are you sure you want to delete the selected records?". Click "OK" to confirm, or "Cancel" to return without deleting. WARNING: Records cannot be recovered once they are deleted! |
| Edit | Opens the selected record for editing. If a record is not selected, the page will not open. |
| Excel | Export the contents of the list view to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view only the filtered contents will be exported. |
| Favorites |   Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline.
|
| Grid Layout | Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).
|
| Help | Opens the online WIKI help page for the current page.
|
| More Actions | Opens a drop-down menu for the user to select Reverse/Correct, which opens the Reverse/Correct page and allows the user to either Reverse or Correct a journal entry. |
| New | Opens a new blank record for data entry. |
| Fields | Description |
| Account Description | Displays the name of the line item account. Linked Database Field: ERPx_GLAccount.Description |
| Account Number | Displays the account number of the line item distribution. Linked 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 Database Field: ERPx_GLJournalHeader.Comment |
| Created | Error rendering macro 'excerpt-include' : No link could be created for 'Created (Date & Time) - List View/Inquiry'. Linked Database Field: ERPx_GLJournalHeader.CreatedDate where |
| Created By | Error rendering macro 'excerpt-include' : No link could be created for 'Created By- List View / Inquiry'. Linked Database Field: ERPx_GLJournalHeader.CreatedBy |
| Credit | Displays the amount credited from the line item. Linked Database Field: ERPx_GLJournalLine.CreditAmount |
| Debit | Displays the amount debited from the line item. Linked Database Field: ERPx_GLJournalLine.DebitAmount |
| Distributed To | Displays the name of the Project the amount is distributed to. Linked Database Field: ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK |
| Distributed Type | Displays the type of distribution. Journal lines displayed from this list view will be of type 'Project'. This text box contains the value in the MFDistributionType Enumeration Class where MFDistributionType = 2. Linked Database Field: ERPx_GLJournalLine.MFDistributionAccountTypeEN |
| GL Period | Error rendering macro 'excerpt-include' : No link could be created for 'GL Period - List View/Inquiry Field'. |
| GL Year | Error rendering macro 'excerpt-include' : No link could be created for 'GL Year - List View/Inquiry Field'. |
| 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 | Error rendering macro 'excerpt-include' : No link could be created for 'Last Updated (Date & Time) - List View/Inquiry'. Linked Database Field: ERPx_GLJournalLine.LastUpdated |
| Last User | Error rendering macro 'excerpt-include' : No link could be created for 'Last Updated By - List View/Inquiry'. 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 | Error rendering macro 'excerpt-include' : No link could be created for 'Reference - List View/Inquiry Field'. 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 | Error rendering macro 'excerpt-include' : No link could be created for 'Status - List View/Inquiry Field'. The entry will be listed as either “New”, “Approved”, or “Ready to Post”. Linked Database Field: ERPx_GLJournalHeader.TransactionStatusSK |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.