| Insert excerpt | Def - Journal Entry | Def - Journal Entry | ||||
|---|---|---|---|---|---|---|
| nopanel | true | |||||
| Insert excerpt | ||||||
|
This record 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: 20232024.0805.11 20 and newer
| Table of Contents | ||
|---|---|---|
|
...
| Toolbar Icons | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Delete |
| ||||||||||||||||
| Help |
| ||||||||||||||||
| New |
The list contains the options 'Manual' and 'Accrue & Reverse'. | ||||||||||||||||
| Notes |
| ||||||||||||||||
| |||||||||||||||||
Save |
| ||||||||||||||||
| Save & Close |
|
Home Tab
Fields | Description | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Comment |
Database Field: ERPx_GLJournalHeader.Comment | ||||||||||||||||||||||||||||||||
| Currency |
Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_GLJournalHeader.CurrencySK | ||||||||||||||||||||||||||||||||
| Date |
Database Field: ERPx_GLJournalHeader.JournalDate | ||||||||||||||||||||||||||||||||
| Exch. Rate | Identifies the exchange rate associated with the Exchange Table and Journal Date assigned to the transaction. This is a numeric textbox that is only editable when the Currency selected is a value other than the home currency, the Exchange Table selected is Manual and the transaction 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. When a currency other than the home currency is saved, this defaults to the most recent rate on the selected Exchange Table that corresponds to the Journal Date on the transaction, else for the home currency it defaults to blank and is disabled.
Database Field: ERPx_GLJournalHeader.ExchangeRate | ||||||||||||||||||||||||||||||||
| Exch. Table | Identifies the Exchange Table used to calculate the exchange rate associated with the transaction. This is a single select lookup that allows users to select an Exchange Table for the Journal Entry. This is only enabled when the Currency selected is a value other than the home currency and the record status is New. The field defaults to the first exchange table with the selected currency, but can be changed to another table for that currency or Manual to allow manual rate entry.
Database Fields: ERPx_MFCurrencyExchange.ExchangeID, ERPx_GLJournalHeader.ExchangeSK | ||||||||||||||||||||||||||||||||
| Journal ID |
Database Field: ERPx_GLJournalHeader.JournalID | ||||||||||||||||||||||||||||||||
| Journal Type |
Manual Journal Entry: Accrue & Reverse Journal Entry: Database Field: ERPx_GLJournalHeader.JournalTransactionTypeSK | ||||||||||||||||||||||||||||||||
| Rate Type | Identifies the calculation method for the exchange rate. This field is only editable when the Currency selected is a value other than the home currency, the Exchange Table selected is Manual and the transaction status is New. This 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. This defaults to the Exchange Table Rate Type for the selected currency when an existing Exchange Table is selected. When the home currency is selected this defaults to 'Multiply' and is disabled.
Database Field: ERPx_GLJournalHeader.ExchangeRateCalculationMethodEN | ||||||||||||||||||||||||||||||||
| Reference |
Database Field: ERPx_GLJournalHeader.Reference | ||||||||||||||||||||||||||||||||
| Reversing Date | Identifies the date for the reversing journal entry. The date defaults to the current date and is required else the message "Reversing Date is required." will be displayed on Save. The date must be the same or later than the Date on the record, else the message "Reversing Date must be on or after the Journal Date." will be displayed on Save. This is only editable prior to the initial Save.
| ||||||||||||||||||||||||||||||||
| Source | Identifies the source of the journal entry and is either ‘GL-Manual’, ‘GL-Accrue & Reverse’, or 'GL-Correct'. This field is for informational use only and is never editable. Database Field: ERPx_GLTransactionType.TransTypeName | ||||||||||||||||||||||||||||||||
| Status | This is only editable for Journal Entries in a Status of New or Approved. The entry will be listed as either “New”, “Approved”, or “Ready to Post”.
This page includes all the Manual and Accrue & Reverse journal entries in a the statuses of:
Database Fields: ERPx_GLJournalHeader.TransactionStatusSK |
Properties Tab
Fields | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Group: All | |||||||||||||||||
Class |
Database Field: ERPx_GLJournalHeader.JournalTransactionClassSK | ||||||||||||||||
Journal Header SK | Identifies the SK value of the Transaction. This field is never editable and is for information only. Database Field: ERPx_GLJournalHeader.JournalHeaderSK | ||||||||||||||||
| Created |
Database Field: ERPx_GLJournalHeader.CreatedDate | ||||||||||||||||
| Created By |
Database Field: ERPx_GLJournalHeader.CreatedBy | ||||||||||||||||
| Posted |
Database Field: ERPx_GLJournalHeader.PostedDate | ||||||||||||||||
| Posted By |
Database Field: ERPx_GLJournalHeader.PostedBy | ||||||||||||||||
| Last Updated |
Database Field: ERPx_GLJournalHeader.LastUpdated | ||||||||||||||||
| Last Updated By |
Database Field: ERPx_GLJournalHeader.LastUpdatedBy | ||||||||||||||||
| Master Number | Displays the unique identifier from the database for the record. This field is never editable and is for information only. Database Field: ERPx_GLJournalHeader.MasterNumber | ||||||||||||||||
Attributes Tab
Fields | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Attributes |
| ||||||||
| Required | A non-editable text box that shows whether the Attribute Value is required or not. If the Attribute Value is required, it will display "Yes". If it is optional, it will display as blank. This value is only editable from the 'Assign Attribute Rules' page (Company → Setup → Attributes → Financial → Transactions hyperlink). | ||||||||
| Value |
|
Page Details
| Toolbar Icons | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column Filter Show/Hide |
| ||||||||||||||||
| Delete |
| ||||||||||||||||
| Excel |
| ||||||||||||||||
| Group By Show/Hide |
| ||||||||||||||||
| New |
| ||||||||||||||||
| Quick Column Filter |
| ||||||||||||||||
| Saved Layouts |
| ||||||||||||||||
| Fields | Description | ||||||||||||||||
| Checkbox |
| ||||||||||||||||
| Account | The unique identifier and name associated with Identifies the GL Account record. This is a single select lookup and Account Description for the line item. This is an editable textbox that is required, if other field values are entered and no Account is selected entered the line will not be saved. The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Accounts set to 'Use in GL' on the GL Accounts setup page and any 'Active' Statistical Accounts. It defaults to blank and is editable until the transaction is in a status of 'Approved', 'Ready To Post' or 'Posted'. The Account can be easily updated using the quick replacement feature, for information on how this works please see this FAQ. Note: Statistical Accounts are only available in manual Journal Entries and not Accrue & Reverse type transactions.
Database Fields: ERPx_GLAccount.AccountNumber - ERPx_GLAccount.Description, ERPx_GLJournalLine.GLAccountSK | ||||||||||||||||
| Credit | Identifies the credit amount for the line item. Each row in the grid must have a value entered for either the Debit Amount or Credit Amount. If there is a value in either the Debit or Credit Amount field, then the other field will be disabled. Database Field: ERPx_GLJournalLine.CreditAmount | ||||||||||||||||
| Debit | Identifies the debit amount for the line item. Each row in the grid must have a value entered for either the Debit Amount or Credit Amount. If there is a value in either the Debit or Credit Amount field, then the other field will be disabled. Database Field: ERPx_GLJournalLine.DebitAmount | ||||||||||||||||
| Home Credit | Displays the credit amount in the home currency. This is calculated by multiplying/dividing the Credit amount with the Exchange Rate as determined in the header section of the record. This field is for informational use only and is never editable. Database Field: ERPx_GLJournalLine.TransCurrencyCreditAmount | ||||||||||||||||
| Home Debit | Displays the debit amount in the home currency. This is calculated by multiplying/dividing the Debit amount with the Exchange Rate as determined in the header section of the record. This field is for informational use only and is never editable. | ||||||||||||||||
| Line Comment |
Database Field: ERPx_GLJournalLine.Comment | ||||||||||||||||
| Project | Identifies the Project associated with the line item. This is a single select lookup that defaults to blank and is not required. This is editable while the transaction is in a Status of "New". The lookup contains a blank value, the current assigned value, and a list of all the 'Active' projects that are within the open date range. Database Field: ERPx_GLJournalLine.DistributionAccountSK | ||||||||||||||||
| Seq. |
For example, if you had line items 10, 20, and 30 and you wanted the last one (Ln. 30) to be second, you could edit the value to any number between 10 and 20 (i.e., 15) and on save the lines would be sorted in the new sequence (10, 15, and 30) and then all Ln.'s would be re-set to base 10 numbers (10, 20, 30). |
...