Exchange rate differences for account receivables/payables are calculated by "AR/AP Exchange Rate Difference Calculations" option located in Operations menu of Finance section. As the calculation results can be collected in a single exchange rate difference slip belongs to calculation date, also they can generate slips that include separate exchange rate differences for all bank account transaction dates by "Generating Consecutive Exchange Rate Differences" facility of program.
The AR/AP Exch. Rate Diff. Calculation window is used to specify the filter conditions to be applied to exchange rate difference calculations. The filters are:
Calculation Date: Indicates the date of which the daily exchange rate will be used for the calculation. The exchange rate value is read from the foreign currency file.
AR/AP Code: Used to filter the AR/AP or account(s) to which the exchange rate difference calculation will be applied. If the exchange rate difference calculation will be performed only for specific accounts, conditions are set by defining groups or ranges.
AR/AP Type: Indicates the type of the AR/AP to which the exchange rate difference calculation will be applied.
AR/AP Aux. Code: Accounts receivable/payable for which the difference will be calculated can also be filtered by AR/AP aux. code. The filter is applied by making a group or range definition.
Trading Group: Used to filter the trading groups to which the exchange rate difference calculation will be applied. The filter is applied by making a group or range definition.
Division: This filter line is used to specify the transactions performed by which division(s) will be processed for the calculation. Only the transactions performed through the divisions specified on this field are scanned for each account, and the rate difference is calculated only for these transactions.
Department: This filter line is used to specify the transactions performed by which department(s) will be processed for the calculation. Only the transactions performed through the departments specified on this field are scanned for each account, and the rate difference is calculated only for these transactions.
F. Currency Type: This filter line is used to specify the transactions performed in which currency will be processed for the calculation. More than one currency type can be selected on this field. In such cases, exchange rate difference is calculated separately for each currency type.
Exch. Rate Difference Limit: This line is used to specify a limit in order to prevent the exchange rate difference to be reflected on the remittance slip to be generated when the exchange rate calculated in the currency type selected for the calculation is under a specific limit. If the calculated exchange rate difference is smaller than the amount entered on this field, the resulting exchange rate difference is not processed.
Description: The information required to be included in the line description of the exchange rate difference slip is entered into this filter line as default.
Exchange Rate Difference Type: This filter line is used to specify the transactions to be processed in exchange rate difference calculations. The exchange rate difference can be calculated only for accounts receivable/payable with only debit or only credit balances, or can contain both.
Exchange Rate Type: This filter line is used to specify the exchange rate type to be processed in exchange rate difference calculations
Exchange Rate Difference Control: Used to determine whether the Exchange Rate Difference will be done or not. Includes "Will be done" and "Will not be done" options. Used to record exchange rate difference slip in user control generated at the end of the calculation.
When "Will be done" is selected, each exchange rate difference slip comes to screen before it is saved and user saves it.
If "Will not be done" is selected, at the end of the exchange rate difference calculations, the slips are generated and saved automatically.
Generate Consecutive Exchange Rate Differences: Used to generate separate exchange rate difference slips for each day when transactions done in f. currency. The option contains Yes and No options.
If "Yes" is selected, for each day (when f. currency transactions belong to accounts (receivable/payable)), between specified date in "exchange rate different beginning date" filter line and calculation date, a separate slip is generated.
If "No" is selected, considering the calculation date, a single exchange rate difference slip is generated for transactions in f. currency.
Calculation Start Date: Used in consecutive exchange rate difference calculations. In the event of approving "Generate Consecutive Exchange Rate Differences" filter, it indicates the starting date of the calculation.
Include Uncollected Checks in Calculation: When calculating exchange rate difference for an account (receivable/payable), whether or not uncollected checks will be included in calculation is determined with this filter line. Contains Yes and No options.
Show Transactions With Exchange Rate Diff. On Log Screen: This filter line is used to report exchange rate differences incurring from the exchange rate difference transactions. It has two options: "Yes" and "No". If "Yes" is selected, Log window opens automatically after exchange rate difference calculation is started. This window lists all transactions incurred the exchange rate differences that are calculated by the method specified in the filter lines.
Once the conditions are set for the exchange rate difference calculation, clicking "Ok" button starts the transaction. Calculated exchange rate differences are inserted into the Remittance Slip generated by the application. The date of the Remittance Slip is the date specified on the Exchange Rate Difference Slip window.
Calculated exchange rates are recorded under the AR/AP for which the calculation is performed, or the exchange rate difference account specified on the calculation record. Transactions of each calculated account are displayed on a separate line on the Remittance Slip.
In the LOGO application, exchange rate difference can be grouped under a single account, or a different exchange rate difference account can be opened for each account.
When the exchange rate value of a given date cannot be read from the exchange rate table during the calculation, "Continue the operation skipping this currency type" warning message is displayed. When accounts (receivable/payable) are not processed through the specified f. currency type, the application displays "No account found with exchange rate difference" warning message.
Likewise, exchange rate difference calculations cannot be performed when a date different than the working days specified on "Company Parameters" is entered. Exchange rate difference is calculated by processing the exchange rate value specified on Automatic Usage option of F. Currency Usage Parameters located in the Definitions menu of the Administration section. F. currency type should be specified on Automatic Usage field of F. Currency Usage Parameters in order to calculate the exchange rate difference with the required f. currency type.
Example for Consecutive Exchange Rate Differences:
There are 3 separate transactions belong to AR/AP in three separate days and at the beginning of new day, exchange rate difference calculation is run. At 09.09, if "Consecutive Exchange Rate Difference" filter is approved and calculated start date is specified as 06 .06:
Slip No |
|
Date |
|
Debit |
|
Credit |
|
F. Currency Balance |
|
Local Currency Balance |
|
F. Currency Exchange Rate |
|
Exchange Rate Difference Transaction |
|
Local Currency Balance after Exchange Rate Difference Transaction |
|
|
06.08 |
|
|
|
150 USD |
|
150 (A) |
|
300 (A) |
|
2 |
|
|
|
|
|
|
001 |
|
|
|
|
|
|
|
|
|
|
|
|
150 * (3 – 2) = 150 (A) |
|
|
|
|
|
07.08 |
|
|
|
10 USD |
|
160 (A) |
|
300 + 30 = 330 (A) |
|
3 |
|
|
|
150 + 330 = 480 (A) |
|
|
002 |
|
|
|
|
|
|
|
|
|
|
|
|
160 * (2 – 3) = 160 (B) |
|
|
|
|
|
08.08 |
|
15 USD |
|
|
|
145 (B) |
|
480 – 30 = 450 (A) |
|
2 |
|
|
|
– 160 + 450 = 290 (A) |
|
|
003 |
|
|
|
|
|
|
|
|
|
|
|
|
145 * (4 – 2) = 290 (A) |
|
|
|
|
|
09.09 |
|
|
|
|
|
145 (B) |
|
300 (B) |
|
4 |
|
|
|
290 + 290 = 580 (A) |
|
Example2: Two different account's AR/AP transactions are as below:
AR/AP Code |
Date |
Debit in F. Currency |
Credit in F. Currency |
LC Debit |
LC Credit |
F. Currency Exch. Rate |
AR/AP.001 |
14.10 |
|
150$ |
|
300 |
2 |
AR/AP.001 |
17.10 |
|
10$ |
|
30 |
3 |
AR/AP.001 |
19.10 |
15$ |
|
|
|
2 |
AR/AP.002 |
17.10 |
|
100$ |
|
|
3 |
AR/AP.002 |
20.10 |
|
200$ |
|
|
4 |
In this case, the exchange rate difference slips will be as:
Exch. Rate Diff. Slip No |
AR/AP Code |
Date |
|
LC Debit |
LC Credit |
F.Currency Exch. Rate |
001 |
Cari.001 |
17.10 |
|
|
150 |
2 |
002 |
Cari.001 |
19.10 |
|
160 |
|
3 |
003 |
Cari.002 |
20.10 |
|
|
100 |
4 |
As in the example, although both of the accounts have transaction at date of 10, because following transaction dates are different and although AR/AP001's 17.10 dated transaction is calculated considering 19.10 dated exchange rate, 17.10 dated transaction of AR/AP.002, is evaluated by 20.10 dated exchange rate.