Exchange Rate Differences - Selection Criteria

Use this window to specify selection criteria for the Exchange Rate Differences report.

To open the window, choose Financials Exchange Rate Differences .

After defining the report, you can view it in the Exchange Rate Differences window.

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.

Business Partner
Calculates exchange rate differences for business partners. If not selected, other fields pertaining to business partner selection criteria are not displayed.

Customer Group, Vendor Group
Specify whether to display business partners from a specific group, separated into customers and vendors. Example To display only customers, choose `None` in the Vendor Group field. End of the example.

Properties
Opens the Properties window where you can specify required properties. Your choices appear in the field next to the Properties button.

G/L Accounts
Calculates exchange rate differences for G/L accounts. If not selected, all fields related to G/L accounts selection criteria are not displayed. The Account column displays the codes and the names of the accounts. In column `X`, specify which account or title to include by clicking the appropriate row.

Show Level
Choose the account level to display in the table. Level 1 displays the highest level titles for the accounts. When selecting a title in the table, you select all the accounts that appear under this title.

Exclude Gains with Due Date After
Define a date after which you want to exclude the calculation of net realized gains.

Due Date From...To...
Define a due date range for open items.

Execution Date
Specify the cut-off date for calculating exchange rate differences. This is usually the end of the year or quarter.

Consider Recon. Date
Reflects the reconciliation status of the transactions for the selected date. Example If a transaction is reconciled now but was not reconciled on the execution date, the exchange rate differences are calculated as if the transaction has not been reconciled. End of the example.

Currency
Specify the currency for which you want to calculate the exchange rate differences.

Exch. Rate Gain Acct(A/R), Exch. Rate Gain Acct(A/P), Exch. Rate Gain Acct(G/L), Exch. Rate Loss Acct(A/R), Exch. Rate Loss Acct(A/P), Exch. Rate Loss Acct(G/L)
Specify which of the exchange rate differences accounts should be applied when the automatic journal transaction is executed. The accounts are divided into gain and loss accounts and used accordingly. You can define different or identical accounts for customers, vendors, and accounts.

Data Side
Specify whether to calculate the exchange rate differences for the gain side, loss side or both sides.

Previous Report
Opens the latest saved recommendation report.

Revaluate Only Closed Documents
Revaluates only documents that are already closed (fully paid or reconciled), but for which the accumulated exchange rate differences must be revaluated. Example You ran the Exchange Rate Differences for an open item, and then the open item was fully paid. During the payment, the system revaluated the open item again and calculated exchange rate differences again. In this case, the balances on G/L exchange rate differences gain/loss accounts might not be accurate to the payment date and must be adjusted accordingly. End of the example.