Description: The Journal Entry record view is used to create or edit journal entries and contains all the details for each record shown in the Journal Entry list view. From this screen, users can edit information about the record, create new records, or delete them.
| Table of Contents | ||
|---|---|---|
|
Header Toolbar
...
Saves the changes made to the record.
In order to successfully save, the following criteria must be completed:
- Account Number
- Date
- Either a Debit or Credit Amount
- Source
- Status
The Save button is only activated when a change is detected on the page. When the Save button is active, a ‘ + ‘ character is displayed in the page border. Saving reloads the page.
Home Tab
...
This field is only editable when the Currency selected is other than the Company currency, the Exchange Table selected is Manual and the record status is New. This field allows users to enter an Exchange Rate, which is used to calculate the Home Debit and Home Credit amounts in the grid section. The field defaults to the Exchange Rate Type when an existing Exchange Table is selected.
The record must be saved first in order to edit the field.
...
This drop-down menu allows users to select an Exchange Table for the Journal Entry. The field is only enabled when the Currency selected is other than the company currency and the record status is New. The field defaults to the first exchange table with the selected currency, but can be changed to Manual to allow manual rate entry.
The record must be saved first in order to edit the field.
...
This field is only editable when the Currency selected is other than the Company currency, the Exchange Table selected is Manual and the record status is New. The field allows users to select a Rate Type from Multiply and Divide. The Rate Type determines how the Home Debit and Home Credit amounts are calculated in the grid section. The field defaults to the Exchange Table Rate Type when an existing Exchange Table is selected.
The record must be saved first in order to edit the field.
...
Identifies the current status of the journal entry. The entry will be listed as either “New”, “Approved”, or “Ready to Post”. Line items must be added in order to approve or post a journal entry.
Records with a Status of "New" can be fully edited, records with a Status of "Approved" will only allow edit of the Status, and records with a Status of "Ready to Post" cannot be edited.
Properties Tab
...
Journal Header SK
...
Grid Columns
...
Related Topics
Accrue & Reverse Journal Entry
Accrue & Reverse Journal Entry User Guide
Journal Entry - Reverse/Correct
Reverse & Correct User GuideThe 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.
This page is not used to view details from manual Journal Entries or journal entries that were imported.
| Table of Contents | ||
|---|---|---|
|
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 Icons | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Re-Display |
| ||||||||
| Grid Layout |
| ||||||||
| Columns | Description | ||||||||
| Display | A 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.
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.
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 |
Database Field: ERPx_GLJournalHeader.JournalDate | ||||||||
| Journal ID |
Database Field: ERPx_GLJournalHeader.JournalID | ||||||||
| GL Period |
| ||||||||
| GL Year |
| ||||||||
| 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".
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 |
Database Field: ERPx_GLJournalHeader.SourceTransactionDate | ||||||||
| Source Trans ID |
Database Field: ERPx_GLJournalHeader.SourceTransactionID | ||||||||
| Source Trans Type |
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.
| Columns | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| 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 |
Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_GLJournalLine.DistributionAccountSK | ||||||||
| Distributed Type |
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.
| Columns | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| 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 |
Database Field: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_GLJournalLineDetail.DistributionAccountSK | ||||||||
| Distributed Type |
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
| Expand | ||
|---|---|---|
| ||
Page Definitions |
...