GL Period and Year

A numeric textbox to enter the GL Period and Year that is used to filter the transactions displayed in the grid. This should be entered in the following format "00-0000".  Any transactions that have not been fully settled and have a different currency exchange rate currently compared to when the transaction was posted will be displayed through the GL period and year entered. 

The unrealized gain or loss journal that is created will be dated the last day of the period entered.  For example, if the GL Period and Year entered is "12-2023" any gain/loss journals created will be dated "12/31/2023".

Column Filter Show/Hide

Excel

Group By Show/Hide

Process & Close

Processes the Unrealized Gain and Loss journals and closes the record. 

Quick Column Filter

Refresh

Saved Layouts

Fields

Description

Account Number

Unrealized Gain and Loss accounts can be setup on the Company Currencies List View. 

Database Field: ERPx_GLAccount.AccountNumber:Description

Credit Amount

Displays the amount to be credited from the transaction line.  This is a non-editable numeric textbox that displays the amount to be credited to the corresponding Account when the journal is processed.  If the Unrealized journal results in a gain this value will be credited to the Unrealized Gain Account setup in the system.  The amount is calculated as [Original Rate Open Amount] - [Current Rate Open Amount], if the Current Rate Open Amount is more than the Original Rate Open Amount this value will be displayed in the Credit Amount field for the currency Unrealized Gain Account and if it is less it will be displayed in the Credit Amount for the corresponding transaction's Account Receivable or Accounts Payable account as applicable. 

This is a calculated field that is not stored in the database.

Current Exchange Rate

Displays the most recent exchange rate based upon the GL Period and Year for the corresponding transaction.  This is a non-editable numeric textbox that is required.  This value comes from the most recent exchange rate for the GL period and year entered in the header that is saved to the exchange table which was used on the corresponding transaction. For example, if the GL Period and Year entered is 11-2023 and the exchange table is setup with rates from 11/01/2023 to 11/15/2023 and from 11/16/2023 to 11/30/2023, then the rate assigned to the '11/16/2023 to 11/30/2023' will be the rate displayed in this field. 

Database Field: ERPx_MFCurrencyExchangeRate.Rate

Current Rate Open Amount

Displays the amount that is still owed using the most recent exchange rate based upon the GL Period and Year entered.  This is a non-editable numeric textbox that is required. The amount is calculated as [Open Amount - Trans. Currency] multiplied or divided by [Current Exchange Rate].  It is multiplied or divided based upon the calculation method setup in the exchange table record. 

This is a calculated field that is not stored in the database.

Debit Amount

Displays the amount to be debited from the transaction line.  This is a non-editable numeric textbox that displays the amount to be debited to the corresponding Account when the journal is processed.  If the Unrealized journal results in a loss this value will be debited to the Unrealized Loss Account setup in the system.  The amount is calculated as [Original Rate Open Amount] - [Current Rate Open Amount], if the Current Rate Open Amount is less than the Original Rate Open Amount this value will be displayed in the Debit Amount field for the currency Unrealized Loss Account and if it is more it will be displayed in the Debit Amount for the corresponding transaction's Account Receivable or Accounts Payable account as applicable. 

This is a calculated field that is not stored in the database.

Functional Area

Identifies the Functional Area where the Transaction originated. This is a non-editable textbox that is required.  It defaults to the Functional Area the corresponding transaction was created in.  This is never editable. 

Database Field: ERPx_MFFunctionalArea.FunctionalAreaName

Open Amount - Trans. Currency

Displays the amount that is still owed in the transaction's currency.  This is a non-editable numeric textbox that is required.  It is the amount that was owed on the transaction less any payments that have been applied.  This is never editable. 

This is a calculated field that is not stored in the database.

Original Exchange Rate

Displays the exchange rate that was used on the corresponding transaction when it was created and posted.  This is a non-editable numeric textbox that is required.  

Database Field: ERPx_MFCurrencyExchangeRate.Rate

Original Rate Open Amount

Displays the amount that was owed using the exchange rate at the time the transaction was created and posted.  This is a non-editable numeric textbox that is required. The amount is calculated as [Open Amount - Trans. Currency] multiplied or divided by [Original Exchange Rate].  It is multiplied or divided based upon the calculation method setup in the exchange table record. 

This is a calculated field that is not stored in the database.

Transaction Currency

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_SOOrderHeader.CurrencySK, ERPx_ARTransactionHeader.CurrencySK, ERPx_APTransactionHeader.CurrencySK

Transaction ID

Database Fields: ERPx_SOOrderHeader.OrderID, ERPx_ARTransactionHeader.TransactionID, ERPx_APTransactionHeader,TransactionID

Transaction Type

Database Fields: ERPx_ARTransactionType.TransactionName, ERPx_APTransactionType.TransactionName