Unrealized Gain/Loss Record View
- Emma Greenwood
An Unrealized Gain or Loss occurs when the invoice/transaction amount owed has not been paid by the end of the accounting period and the outstanding balance of the invoice / transaction is revalued using a new exchange rate. An unrealized loss results in a Debit to the Unrealized Loss Account and an unrealized gain results in a Credit to the Unrealized Gain Account.
Software Version: 2023.12.19 and newer
Page Header
| 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 |  Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
| Excel |  Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. |
| Group By Show/Hide |  Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
| Process & Close | Processes the Unrealized Gain and Loss journals and closes the record. |
| Quick Column Filter |
|
| Refresh |  Re-queries the contents of the grid/page based on the Search Options or the default values for grids that do not support Search Options.
|
| Saved Layouts |
Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
| Fields | Description |
| Account Number | Identifies the GL Account ID of the GL Account assigned to a transaction line, journal entry line, or master file record. This is a non-editable numeric textbox that is required to process an Unrealized gain/loss journal, else the message "An Account Number is required." will be displayed when Process & Close is clicked. 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. Functional Areas represent the collection of Transactions, Master Files, Inquires, and Reports that pertain to unique areas of operations within the software. The Functional Areas include:
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 | Identifies the Currency assigned to the transaction. This is a non-editable textbox that is required. It defaults to the currency assigned to the corresponding transaction. This is never editable. The Currency identifies the kind of money used for transactions. For example, if a Customer or Vendor is setup with a Currency of "USD" then all transactions for them are stated in terms of US Dollars and all payments received or made must be in US Dollars. Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_SOOrderHeader.CurrencySK, ERPx_ARTransactionHeader.CurrencySK, ERPx_APTransactionHeader.CurrencySK |
| Transaction ID | Identifies the unique Transaction ID for each transaction. This is a non-editable textbox that is required. Transaction numbers are system assigned IDs to differentiate unique transactions. Transaction ID's are unique by the unique combination of 'Transaction Type' + 'Transaction Class'. Database Fields: ERPx_SOOrderHeader.OrderID, ERPx_ARTransactionHeader.TransactionID, ERPx_APTransactionHeader,TransactionID |
| Transaction Type | Identifies the Transaction Type for each transaction. This is a non-editable textbox that is required. Transaction Types are used to differentiate unique types transactions within the system. Transactions with the same Transaction Type share the same record view pages and business rules. Transaction Types can be further classified using Transaction Classes. Every transaction in the system is assigned a Transaction Type. Database Fields: ERPx_ARTransactionType.TransactionName, ERPx_APTransactionType.TransactionName |
This ONLY re-queries the contents of columns that are currently visible, if you add a new column the contents will be empty until you click 'Refresh' again.