Insert excerpt Def - Unrealized Gain/Loss Def - Unrealized Gain/Loss nopanel true
Software Version: 2023.12.19 and newer
| Table of Contents | ||
|---|---|---|
|
...
| Fields | Description |
|---|---|
| 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". |
Page Details
| Toolbar Icons | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| 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 |
Database Field:
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: |
Database Field:
ERPx_MFFunctionalArea.FunctionalAreaName |
| Open Amount - Trans. Currency |
Database Field:
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 |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
| Expand | ||
|---|---|---|
| ||
Technical Details |