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

Insert excerpt

	Def - Journal Entry
	Def - Journal Entry
nopanel	true

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.

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

type	flat

Page Header

Linked

Displays the name of the line item account.

GLJournalLine

Displays the account number of the line item distribution.

Linked GLJournalLine line item.Linked line item.Linked Vendor, Employee, or Linked Database Field: Linked

Displays the type of distribution, for example Vendor type (Vendor, Fisherman, Tender, Fisherman & Tender, and Loan), Employee, or Project.

Linked Database Field: ERPx_GLJournalHeader.Reference

The entry will be listed as either “New”, “Approved”, or “Ready to Post”. Linked

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Delete

Insert excerpt

	Delete - LV 3.0
	Delete - LV 3.0
nopanel	true

Edit

Insert excerpt

	Edit - LV 3.0
	Edit - LV 3.0
nopanel	true

Excel

Insert excerpt

	Excel - LV 3.0
	Excel - LV 3.0
nopanel	true

Favorites

Insert excerpt

	Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

Grid LayoutGroup By Show/Hide

Insert excerpt

	Grid Layout Group By Show/Hide - GlobalGrid Layout
	Group By Show/Hide - Global
nopanel	true

Help

Insert excerpt

	Help - Global 3.0
	Help - Global 3.0
nopanel	true

More Actions

Opens a drop-down menu for the user to select Reverse/Correct, which opens

Insert excerpt

	More Actions - Global 3.0
	More Actions - Global 3.0
nopanel	true

Reverse/Correct: Opens the Reverse/Correct page and allows the user to either Reverse or Correct a journal entry.

New

Insert excerpt

	New - Multi-Select Trans Type - Global 3.0
	New - Multi-Select Trans Type - Global 3.0
nopanel	true

Manual: Opens a blank journal entry record.
Insert excerpt
Def - Journal Entry
Def - Journal Entry
nopanel true
Accrue & Reverse: Opens a blank Accrue & Reverse journal entry record.
Insert excerpt
Def - Journal Entry - Accrue & Reverse
Def - Journal Entry - Accrue & Reverse
nopanel true
Unrealized Currency Gain/Loss: Opens a blank Unrealized Gain/Loss record.
Insert excerpt
Def - Unrealized Gain/Loss
Def - Unrealized Gain/Loss
nopanel true

Print

Insert excerpt

	Print - LV 3.0
	Print - LV 3.0
nopanel	true

Quick Column Filter

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

Saved Layouts

Insert excerpt

	Column Layouts for Framework 3.0 - Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

Fields

Description

Checkbox

Used to select one or more records for Mass Update or Delete.

Account Description

Insert excerpt

	GL Account Description
	GL Account Description


nopanel	true

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

Insert excerpt

	Def - GL Account Description
	Def - GL Account Description
nopanel	true

Database Field: ERPx_

GLAccount.Description

Account Number

Insert excerpt

	GL Account ID
	GL Account ID
nopanel	true

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

Insert excerpt

	Def - GL Account ID
	Def - GL Account ID
nopanel	true

Database Field: ERPx_

GLAccount.

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

AccountNumber

Comment

Insert excerpt

	Comment
	Comment
nopanel	true

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

Insert excerpt

	Created (Date & Time) - List View/Inquiry
	Created (Date & Time) - List View/Inquiry
nopanel	true

This is a required field.

Linked Database Field: ERPx_GLJournalHeader.CreatedDate where

Created By

Insert excerpt

	Created By- List View / Inquiry
	Created By- List View / Inquiry
nopanel	true

This is a required field.

Linked Database Field: ERPx_GLJournalHeader.CreatedBy

Credit

Displays the amount credited from the

Journal line. This field is required and if no amount was entered, it will displays as "0.00". This can be edited from the 'Credit' field on the Journal lines grid of the Journal Entry record view while in a Status of 'New'.

Database Field: ERPx_GLJournalLine.CreditAmount

Debit

Displays the amount debited from the

Journal line. This field is required and if no amount was entered, it will displays as "0.00". This can be edited from the 'Debit' field on the Journal lines grid of the Journal Entry record view while in a Status of 'New'.

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

Insert excerpt

	Distributed To Type
	Distributed To Type


nopanel	true

This is not required and is not editable. Journal lines displayed from this list view will always be of type 'Project'.

Database Field: ERPx_GLJournalLine.MFDistributionAccountTypeEN

GL Period

Insert excerpt

	GL Period

- List View/Inquiry Field


	GL Period

- List View/Inquiry Field


nopanel	true

This 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'.

GL Year

Insert excerpt

	GL Year

- List View/Inquiry Field


	GL Year

- List View/Inquiry Field


nopanel	true

This 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'.

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

Insert excerpt

	GL Date
	GL Date
nopanel	true

This 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

Insert excerpt

	Journal ID - LV
	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

- LV
nopanel	true

Clicking on the link opens the Journal Entry Record View for the selected Journal Entry. This comes from the 'Journal ID' in the header of the 'Home' tab on the Journal Entry RV and is auto-assigned when a new Journal Entry is initially saved/created. This is never editable.

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

Insert excerpt

	Journal Type
	Journal Type
nopanel	true

This is required and comes from the 'Journal Type' in the header of the 'Home' tab on the Journal Entry RV and is auto-assigned based on the type of journal entry selected on New. This is never editable.

Insert excerpt

	Def - Journal Type
	Def - Journal Type
nopanel	true

The list of applicable Journal Types for this page include:

Manual Journal Entry:

Insert excerpt

	Def - Journal Entry
	Def - Journal Entry
nopanel	true

Accrue & Reverse Journal Entry:

Insert excerpt

	Def - Journal Entry - Accrue & Reverse
	Def - Journal Entry - Accrue & Reverse
nopanel	true

Correct:

Insert excerpt

	Def - Journal Type - Reverse & Correct
	Def - Journal Type - Reverse & Correct
nopanel	true

Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK

Last Updated

Insert excerpt

	Last Updated

(Date & Time) - List View/Inquiry


	Last Updated

(Date & Time) - List View/Inquiry


nopanel	true

This is a required field.

Linked

Database Field: ERPx_GLJournalLine.LastUpdated

Last UserUpdated By

Insert excerpt

	Last Updated By - List View/Inquiry
	Last Updated By - List View/Inquiry
nopanel	true

This is a required field.

Linked Database Field: ERPx_GLJournalLine.LastUser

Line Comment

A non-editable text box that displays the comment corresponding to the journal line item.

Linked

Insert excerpt

	Comment
	Comment
nopanel	true

This is not required and can be edited by changing the 'Line Comment' field on the Journal lines grid of the Journal Entry record view while in a Status of 'New'.

Database Field: ERPx_GLJournalLine.Comment

Note

A non-editable text box that displays the note applied to the journal entry.

Linked 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

PostedReference

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

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

Insert excerpt

	Reference
	Reference
nopanel	true

This comes from the 'Reference' in the header of the 'Home' tab on the Journal Entry RV. This is not required 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.

PostedDate

Reference

Posted ByStatus

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

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

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 - List View/Inquiry Field

nopanel

true

Insert excerpt

	Status
	Status
nopanel	true

This comes from the 'Status' on the 'Home' tab on the Journal Entry RV. This is only editable for Journal Entries in a Status of New or Approved.

The entry will be listed as either “New” or “Approved”

Insert excerpt

	Def - Status
	Def - Status
nopanel	true

The Statuses that apply to transactions in this List View include:

Insert excerpt

	Def - Status - New
	Def - Status - New
nopanel	true

Insert excerpt

	Def - Status - Approved
	Def - Status - Approved
nopanel	true

Database Field: ERPx_GLJournalHeader.TransactionStatusSK

Version	Old Version 4	New Version Current
Changes made by	Janice Dannenberg	Emma Greenwood
Saved on	Mar 19, 2020	Jan 02, 2024

Versions Compared

Key

Page Header

Related Topics

Page Definitions

Technical Details

Page Comparison

Versions Compared

Key

Page Header

Related Topics

Page Definitions

Technical Details