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".

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	Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
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. 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.
Saved Layouts	Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. 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: Software Application Functional Areas: CO - Company SY - System Core Functional Areas: GL - General Ledger / Financial A/P - Accounts Payable & Purchase Order A/R - Accounts Receivable / Sales Order IN - Inventory Specialty Functional Areas: FA - Fisherman Accounting GA - Grower Accounting LM - Load Management PR - Payroll PT - Portal SP - Sales Programs (Brokerage, Rebate, Off Invoice) 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

Page Header

Related Topics

Page Definitions

Technical Details

Browser not supported