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

...

GLJournalLineGLJournalLine Vendor, Employee, or , for example Vendor type (Vendor, Fisherman, Tender, Fisherman & Tender, and Loan), Employee, or Project.
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 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

CheckboxUsed 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

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.

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

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

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

...