Journal Details Record View

The Journal Details page show the details of journal entries that were created from one or more related transactions. The header grid shows one row for each applicable transaction journal entry (in most cases there will only be one record per transaction), and the detail grids are used to show the line items that make up the journal entry either in summary or in detail. This page is only used to view data, there is nothing that is edited from here.

(lightbulb) This page is not used to view details from manual Journal Entries or journal entries that were imported.

Software Version: 2023.08.31 and newer

Page Header

The header grid shows one row for each applicable transaction journal entry. This is informational only and nothing in the grid is editable

Toolbar IconsDescription
Grid LayoutOpens 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).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

HelpOpens the online WIKI help page for the current page. 

(lightbulb) This icon is only visible on pages that are documented in the online help.

Re-Display

Re-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria. 

(lightbulb)The contents of the grid will only change if the 'Display' checkbox is changed for one or more of Journal Entry rows in the header.

ColumnsDescription
DisplayA checkbox used to include/exclude the record from being included in the 'Journal Entry' and 'Journal Details' tabs below. This defaults to checked but can be unchecked/checked at any time. Selecting a row includes the details from the Journal Entry in the 'Journal Entry' and 'Journal Details' tabs. Unselecting a row removes the details from the tabs. 
Exchange Rate

A non-editable textbox that Identifies the 'Exchange Rate' used to convert a transaction from a foreign currency to the 'Home Currency'. This will always display as 1.00000 when the source transaction was created in the 'Home Currency', otherwise it will come from the 'Rate' on the 'Exchange Table' used at the time the transaction was posted.

(lightbulb) This is for foreign currency transactions.

Database Field: ERPx_GLJournalHeader.ExchangeRate

Exchange Table

A non-editable textbox that Identifies the 'Exchange Table' used to convert the transaction to the 'Home Currency'. This will always display as "Self" when the source transaction was created in the 'Home Currency', otherwise it will display the Exchange Table ID that was used at the time the transaction was posted.

(lightbulb) This is for foreign currency transactions.

Database Field: ERPx_GLJournalHeader.ExchangeSK

Host Journal ID

A non-editable textbox that Identifies the Journal ID from a third-party system. This defaults as blank and is only set if NorthScope Journal Entries are imported into a third-party system.

Database Field: ERPx_GLJournalHeader.HostJournalID

Journal Currency

A non-editable textbox that Identifies the 'Home Currency' that the source transaction was converted to. 

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_GLJournalHeader.CurrencySK

Journal Date

Identifies the date the transaction posted (or will post) to the general ledger. 

Database Field: ERPx_GLJournalHeader.JournalDate

Journal ID

Identifies the unique Journal ID (transaction ID) for the journal entry.

Database Field: ERPx_GLJournalHeader.JournalID

GL Period

Identifies the Fiscal Period based on the GL date on the source transaction or manual journal entry. This is a calculated field and not stored in the database.

GL Year

Identifies the Fiscal Year based on the GL date on the source transaction or manual journal entry. This is a calculated field and not stored in the database.

Integrates to Host GL

A Yes/No textbox to identify whether the Journal ID has been exported to a third-party system. This defaults to "No" and can only be set to "Yes" from an integration process.

Database Field: ERPx_GLJournalHeader.IntegrateToHost

Rate Type

A non-editable textbox that Identifies the 'Calculation Method' assigned to the 'Exchange Table' used to convert the transaction to the 'Home Currency'. This will always display as "Self" when the source transaction was created in the 'Home Currency', otherwise it will display as either "Divide" or "Multiply".

(lightbulb) This is for foreign currency transactions.

Database Fields: ERPx_MFCurrencyExchange.RateCalculationMethod, ERPx_GLJournalHeader.ExchangeSK

Source Module

A non-editable textbox that Identifies the Module that the source transaction was created in. Note: this is the Module Name, not the Functional Area Name.

Database Field: ERPx_MFModule.ModuleDescription, ERPx_GLJournalHeader.SourceModuleSK

Source Trans Currency

A non-editable textbox that Identifies the 'Currency' that the transaction was created in. 

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_GLJournalHeader.SourceTransactionCurrencySK

Source Trans Date

Identifies the GL Date of the Source Transaction that created the journal entry.

Database Field: ERPx_GLJournalHeader.SourceTransactionDate

Source Trans ID

Identifies the unique Transaction ID for each transaction.

Database Field: ERPx_GLJournalHeader.SourceTransactionID

Source Trans Type

Identifies the Transaction Type for each transaction.

Database Field: ERPx_GLJournalHeader.SourceTransactionTypeSK

Journal Entry Grid

The Journal Entry grid shows the summarized Debits/Credits by GL Account for all of the Journal Entries selected in the header grid. This is informational only and nothing in the grid is editable.

ColumnsDescription
Credit

A non-editable text box that identifies the credit amount, converted to the Home Currency, for each GL Account. 

Database Field: ERPx_GLJournalLine.CreditAmount

Debit

A non-editable text box that identifies the credit amount, converted to the Home Currency, for each GL Account. 

Database Field: ERPx_GLJournalLine.DebitAmount

Distributed To

Identifies the name of the Project, Employee, Fisherman, Tender or Loan the line item is distributed to.  

Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK

Distributed Type

Identifies the type of distribution based on the selected Distributed To field.  This contains the associated value in the MFDistributionType  Enumeration Class.

Database Fields: ERPx_GLJournalLine.MFDistributionAccountTypeEN

GL Account

A non-editable textbox that Identifies the GL Account being debited or credited. 

Database Field: ERPx_GLAccount.AccountNumber, ERPx_GLJournalLine.GLAccountSK

Trans Currency Credit

A non-editable text box that identifies the credit amount, in the transaction currency, for each GL Account. 

Database Field: ERPx_GLJournalLine.TransCurrencyCreditAmount

Trans Currency Debit

A non-editable text box that identifies the credit amount, in the transaction currency, for each GL Account. 

Database Field: ERPx_GLJournalLine.TransCurrencyCreditAmount

Journal Details Grid

The Journal Details grid shows the journal details for each transaction line from all the included source transactions. This grid is summarized to create the journal lines. For example, if an AR Invoice contained 2-line items, this grid would display all the Debits and Credits that each line item was responsible for. The purpose of this grid is to explain how the Journal Entry was constructed.

ColumnsDescription
Account Source

A non-editable text box that identities how the GL Account was assigned to the line item. This This contains the associated value in the AccountSourceDescription Enumeration Class.

Database Field: ERPx_GLJournalLineDetail.AccountSourceDescriptionEN

Credit

A non-editable text box that identifies the credit amount, converted to the Home Currency, for each combination of Line Item & Account Source.

Database Field: ERPx_GLJournalLineDetail.CreditAmount

Debit

A non-editable text box that identifies the debit amount, converted to the Home Currency, for each combination of Line Item & Account Source.

Database Field: ERPx_GLJournalLineDetail.DebitAmount

Description

A non-editable text box that identifies the Description for each combination of Line Item & Account Source.

Database Field: ERPx_GLJournalLineDetail.Description

Distributed To

Identifies the name of the Project, Employee, Fisherman, Tender or Loan the line item is distributed to. 

Database Field: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_GLJournalLineDetail.DistributionAccountSK

Distributed Type

Identifies the type of distribution based on the selected Distributed To field.  This contains the associated value in the MFDistributionType  Enumeration Class.

Database Field: ERPx_GLJournalLineDetail.MFDistributionAccountTypeEN

GL Account

A non-editable textbox that identifies the GL Account for each combination of Line Item & Account Source.

Database Field: ERPx_GLAccount.AccountNumber, ERPx_GLJournalLineDetail.GLAccountSK

Line Type

A non-editable textbox that identifies the Type of Journal Line Item.  

Database Fields: ERPx_GLJournalLineType.JournalLineTypeName, ERPx_GLJournalLineDetail.JournalLineTypeSK

Trans Currency Credit

A non-editable text box that identifies the credit amount, in the transaction currency, for each combination of Line Item & Account Source

Database Field: ERPx_GLJournalLineDetail.TransCurrencyCreditAmount

Trans Currency Debit

A non-editable text box that identifies the debit amount, in the transaction currency, for each combination of Line Item & Account Source

Database Field: ERPx_GLJournalLineDetail.TransCurrencyDebitAmount

Related Topics

 Page Definitions

Page Definitions

 Technical Details

Technical Details

Table Names:
dbo.ERPx_GLJournalHeader
dbo.ERPx_GLJournalLine
dbo.ERPx_GLJournalLineDetail
dbo.ERPx_GLJournalLineType
Stored Procedures:
SPx_GLSEL_JournalHeader
SPx_GLSEL_JournalHeaderProperties
SPx_GLSEL_JournalLine