Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Displays the username of the user that created the Journal. This field populates when the record is created and does not update after that. A journal record can be created from a transaction; when clicking journal details for the first time from a record view of a transaction or when approving or posting a transaction without first clicking the journal details button. (lightbulb) This list view is intended to only show unposted manual journal entries.Displays E.g. Manual or Displays Displays the date and time the Journal was posted.  manual journals or transaction or Posted (lightbulb) This list view is intended to only show unposted manual journal entries.Displays the name of the module corresponding - i.e. Delivery Ticket.Displays the status of the line item's corresponding journal entry.
Toolbar IconsDescription
Delete
Insert excerpt
Delete - LV
Delete - LV
nopaneltrue
Edit
Insert excerpt
Edit - LV
Edit - LV
nopaneltrue
Excel
Insert excerpt
Excel - LV
Excel - LV
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
More ActionsOpens 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
Insert excerpt
New - Global
New - Global
nopaneltrue
FieldsDescription
Account DescriptionDisplays the name of the line item account.
Account NumberDisplays the account number of the line item distribution.
CheckboxUsed to select one or more records for Mass Update or Delete.
CommentDisplays the journal comment of the line item's corresponding journal entry.
CreatedDisplays the date and time the Journal was created.  This field populates when the record is created and does not update after that. A journal record can be created from a transaction; when clicking journal details for the first time from a record view of a transaction or when approving or posting a transaction without first clicking the journal details button.  (lightbulb) This list view is intended to only show unposted manual journal entries.
Created By

A non-editable text box that displays the comment entered for the journal entry. 

Linked Database Field: ERPx_GLJournalHeader.Comment

Created

Insert excerpt
Created (Date & Time) - List View/Inquiry
Created (Date & Time) - List View/Inquiry
nopaneltrue

Linked Database Field: ERPx_GLJournalHeader.CreatedDate where 

Created By

Insert excerpt
Created By- List View / Inquiry
Created By- List View / Inquiry
nopaneltrue

Linked Database Field: ERPx_GLJournalHeader.CreatedBy

Credit Displays the amount credited from the line item.
DebitDisplays the amount debited from the line item.
Distributed ToDisplays the name of the Vendor, Employee, or Project the amount is distributed to.
Distributed TypeDisplays the type of distribution, for example Vendor type (Vendor, Fisherman, Tender, Fisherman & Tender, and Loan), Employee, or Project.
GL PeriodDisplays the GL period in which the line item's corresponding journal entry resides.
GL YearDisplays the GL year in which the line item's corresponding journal entry resides.
Journal DateDisplays the date of the line item's corresponding journal entry.
Journal IDDisplays the journal ID of the line item's corresponding journal entry.
Journal Type
Insert excerpt
GL Period - List View/Inquiry Field
GL Period - List View/Inquiry Field
nopaneltrue
GL Year
Insert excerpt
GL Year - List View/Inquiry Field
GL Year - List View/Inquiry Field
nopaneltrue
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". This can be others???

Linked Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK

Last Updated

Insert excerpt
Last Updated (Date & Time) - List View/Inquiry
Last Updated

Displays the date and time the Journal was most recently updated.
Last UserDisplays the username of the user who updated the Journal most recently.
Line Comment

(Date & Time) - List View/Inquiry
nopaneltrue

Linked Database Field: ERPx_GLJournalLine.LastUpdated

Last User

Insert excerpt
Last Updated By - List View/Inquiry
Last Updated By - List View/Inquiry
nopaneltrue

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

NotePosted

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

".

Posted ByDisplays the username of the user that posted the Journal.  This field is populated when manual journals or transaction journals are saved as Ready to Post or Posted.  (lightbulb) This list view is intended to only show unposted manual journal entries.
ReferenceDisplays the reference entered for the journal entry. 
SelectDisplays a checkbox for the user to select line item(s) for deletion or edits.
Source Module


(lightbulb) 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

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

(lightbulb) 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.PostedBy

Reference

Insert excerpt
Reference - List View/Inquiry Field
Reference - List View/Inquiry Field
nopaneltrue

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 DateDisplays

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 IDDisplays the transaction ID of

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 TypeDisplays

A non-editable text box that displays the type of transaction that resulted in the line item's corresponding journal entry

Source Trans VersionDisplays the version of the transaction that resulted in the line item's corresponding journal entry.
Status

.

Linked Database Field: ERPx_GLJournalHeader.SourceTransactionTypeName

Status

Insert excerpt
Status - List View/Inquiry Field
Status - List View/Inquiry Field
nopaneltrue
The entry will be listed as either “New”, “Approved”, or “Ready to Post”.  

Linked Database Field: ERPx_GLJournalHeader.TransactionStatusSK

Related Topics



Expand
titlePage Definitions

Page Definitions


...