/
Journal Entry / Accrue & Reverse Record View

Journal Entry / Accrue & Reverse Record View

May 23, 2024

 The purpose of this page is to view, add, edit, remove, and post manually created Journal Entries, including Accrue & Reverse type transactions.  

 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: 2024.05.20 and newer

[ 1 Page Header ] [ 1.1 Header Toolbar ] [ 1.2 Home Tab ] [ 1.3 Properties Tab ] [ 1.4 Attributes Tab ] [ 2 Page Details ] [ 2.1 Related Topics ] [ 2.1.1 Page Definitions ] [ 2.1.2 Technical Details ]

Page Header

Header Toolbar

Toolbar Icons

Description

Toolbar Icons

Description

Delete

Help

New

The list contains the options 'Manual' and 'Accrue & Reverse'. 

Notes

Print

Save

Save & Close

Home Tab

Fields

Description

Fields

Description

Comment

 

This is text box that defaults as blank for manually entered transactions and is not required but If entered, it must be <=500 characters. This is always editable even after the transaction is posted.

Database Field: ERPx_GLJournalHeader.Comment

Currency

 This is a single select lookup that defaults to the home currency saved in the Company Preference ‘Home Currency’, and is required.  This is editable while the transaction is in a Status of "New". 

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_GLJournalHeader.CurrencySK

Date

 This is a date picker to assign/edit a date for the transaction. This defaults to the current date on New and is required to save the transaction. If missing, the message "Journal Date is required." will be displayed on Save. This is editable while the transaction is in a Status of "New". 

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. 

  The record must be saved first in order to edit the field.

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.

  The record must be saved first in order to edit the field.

Database Fields: ERPx_MFCurrencyExchange.ExchangeID, ERPx_GLJournalHeader.ExchangeSK

Journal ID

 This number is auto-assigned when a new Journal Entry is initially saved/created. This is never editable.

Database Field: ERPx_GLJournalHeader.JournalID

Journal Type

 This field is for informational use only and is never editable.

 The list of applicable Journal Types for this page include:

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.  

  The record must be saved first in order to edit the field.

Database Field: ERPx_GLJournalHeader.ExchangeRateCalculationMethodEN

Reference

This is text box that defaults to blank and is not required, but if entered, it must be <=100 characters. This is always editable even after the transaction is posted.

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.  

 This field is only displayed when the Journal Type is Accrue & Reverse.

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