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

Table of Contents

type	flat

Page Header

...

Displays the name of the line item account.

Linked Database Field: ERPx_GLAccount.Description

...

Displays the account number of the line item distribution.

Linked Database Field: ERPx_GLAccount.AccountNumber

...

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

Linked Database Field: ERPx_GLJournalHeader.Comment

...

Linked Database Field: ERPx_GLJournalHeader.CreatedBy

...

Displays the amount credited from the line item.

Linked Database Field: ERPx_GLJournalLine.CreditAmount

...

Displays the amount debited from the line item.

Linked Database Field: ERPx_GLJournalLine.DebitAmount

...

Displays the name of the Project the amount is distributed to.

Linked Database Field: ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK

...

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

...

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

...

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

...

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

...

Linked Database Field: ERPx_GLJournalLine.LastUpdated

...

Linked Database Field: ERPx_GLJournalLine.LastUser

...

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

Linked Database Field: ERPx_GLJournalLine.Comment

...

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

...

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 Database Field: ERPx_GLJournalHeader.PostedDate

...

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

...

Linked Database Field: ERPx_GLJournalHeader.Reference

...

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

...

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

...

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

...

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

...

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

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

Group By Show/Hide

Insert excerpt

	Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Help

Insert excerpt

	Help - Global 3.0
	Help - Global 3.0
nopanel	true

More Actions

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.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
	Created
nopanel	true

This is a required field.

Database Field: ERPx_GLJournalHeader.CreatedDate

Created By

Insert excerpt

	Created By
	Created By
nopanel	true

This is a required field.

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
	GL Period
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
	GL Year
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

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

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
	Last Updated
nopanel	true

This is a required field.

Database Field: ERPx_GLJournalLine.LastUpdated

Last Updated By

Insert excerpt

	Last Updated By
	Last Updated By
nopanel	true

This is a required field.

Database Field: ERPx_GLJournalLine.LastUser

Line Comment

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

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

Reference

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

Status

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 5	New Version Current
Changes made by	Janice Dannenberg (Unlicensed)	Emma Greenwood
Saved on	Mar 24, 2020	Jan 02, 2024

Versions Compared

Key

Page Header

Page Header

Related Topics

Page Definitions

Technical Details

Page Comparison

Versions Compared

Key

Page Header

Page Header

Related Topics

Page Definitions

Technical Details