Realized Exchange Gain Loss

The Realized Exchange Gain Loss report gives you the gains and losses of the exchange rate. Tell me more.

Select the “Realized Exchange Gain Loss” link under the “Reports – Payables Management” business component.

The “Realized Exchange Gain Loss” page appears.

Enter the following fields in the “Search Criteria” group box:

Company Code	Use the drop-down list box to select the code identifying the company for which you want to view the realized exchange gain loss report. All the companies that are in the “Active” status and have been mapped to the login organization unit will be available for selection.
Finance Book	Use the drop-down list box to select the code identifying the finance book in which you want to view the realized exchange gain loss report. All the finance books that have been defined for the company will be available for selection.
Sort By
Supplier Group	Use the drop-down list box to select the supplier group for which you want to view the realized exchange gain loss report. All the supplier group codes that have been defined for the selected group type will be available for selection.
Supplier Code From	The starting code in the range of codes identifying the suppliers for whom you want to view the realized exchange gain loss report (Alphanumeric, 18).
Supplier Code To	The ending code in the range of codes identifying the suppliers for whom you want to view the realized exchange gain loss report (Alphanumeric, 18).
Currency Option	Use the drop-down list box to select the type of currency in which you want to view the realized exchange gain loss report. You can select from “All”, “Base” or “Parallel Base”. The system displays “All” by default on launch of the page.
Transaction Currency	Use the drop-down list box to select the code identifying the transaction currency in which you want to view the realized exchange gain loss report. All the currency codes that have been assigned to the login company will be available for selection. The system displays “All” by default on launch of the page.
Pay Currency
Date Option	Use the drop-down list box to select the time duration for which you want to view the realized exchange gain loss report. You can select from “Financial Year”, “Calendar Year” or “Date Range”. The system displays “Date Range” by default on launch of the page.
Financial Year	Use the drop-down list box to select the code identifying the financial year for which you want to view the realized exchange gain loss report. All the financial years defined for the finance books will be available for selection.

Note: A financial year must not be selected if “Date Range” is selected in the “Date Option” field.

Financial Period

Use the drop-down list box to select the financial period for which you want to view the realized exchange gain loss report. All the financial periods that have been defined for the selected year will be available for selection. The system displays the start date and the end date of the financial period along with the code identifying the financial period.

Note: A financial period must not be selected if “Date Range” is selected in the “Date Option” field.

Calendar Year

Use the drop-down list box to select the calendar year for which you want to view the realized exchange gain loss report. All the calendar years based on the defined financial years will be available for selection. For example if the financial year is from April 2001 to March 2002, the calendar year 2001 and 2002 will be available for selection.

Note: A calendar year must be selected only if “Calendar Year” is selected in the “Date Option” field.

Month

Use the drop-down list box to select the month for which you want to view the realized exchange gain loss report. All the twelve months of a calendar year will be available for selection. The system displays “Jan” by default on launch of the page.

Note: A month must be selected only if “Calendar Year” is selected in the “Date Option” field.

Date From

The starting date in the date range for which you want to view the realized exchange gain loss report (Date Format). The date entered in this field must be before the date entered in the “To” field.

Note: This field must be left blank if “Financial Year” is selected in the “Date Option” field.

To	The ending date in the date range for which you want to view the realized exchange gain loss report (Date Format). The system date is displayed by default on launch of the page.

Note: This field must be left blank if “Financial Year” is selected in the “Date Option” field.

Created At	Use the drop-down list box to select the organization unit in which the supplier documents have been created. All the organization units in which the “Payables Management” business components have been deployed will be available for selection.
Entry Point Page	Select the check box to print the entry point page details in the first page of the report.

Click the “View Exchange Gain Loss” pushbutton to view the report.

The system retrieves the realized exchange gain loss report based on the search criteria entered. This report can be printed.

The liability acknowledgement is done at the exchange rate prevalent on the date of invoice or the liability document. On the date of settlement, the exchange rate may be higher or lower than that at which they were originally recorded. This results in a gain or loss of exchange rate, as the case may be in both the base currency and the parallel base currency of the company. If a transaction is squared off or settled, it is possible to view the gains and losses exchange rate in this report.

You can search by selecting the company and the corresponding finance book for which you want to view the realized exchange gain loss report. You can also search by specifying the group and a range of codes identifying the suppliers for whom you want to view the realized exchange gain loss report. You can also select the currency option, the transaction currency and the pay currency in which you want to view the realized exchange gain loss report. You can also select a particular date option where you can select a specific financial year, financial period, calendar and month to view the report. You can also specify a range of dates identifying the date for which you want to view realized exchange gain loss report. The system retrieves the realized exchange gain loss report based on the search criteria entered.