Show TOC

Object documentationExchange Rate Differences - Selection Criteria Locate this document in the navigation structure


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.
Selection Criteria
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 Example

To display only customers, choose None in the Vendor Group field.

End of the example.

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

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.

Country-Specific Fields: CZ, HU, PL, RU, SK
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 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.