We will not be accepting edits to this topic, because it is generated from a business process in Lifecycle Services.
This task walks you through running an average exchange rate calculation.
You can calculate the exchange rates for journal lines. For cash and bank transactions, you can use either the daily exchange rate or an average exchange rate. For petty cash and bank journal lines, the calculation of the average exchange rate uses the summarized amounts of the accounting currency and the foreign currency before the specified transaction date.
This task was created using the demo data company DEMF with the country/region of legal entity primary address updated to be Hungary. This procedure is for a feature that was added in Dynamics 365 for Operations version 1611.
- Go to General ledger > Journal entries > General journals.
- Click New.
- In the Name field, enter or select a value.
- Click Lines.
- In the Account type field, select 'Customer'.
- In the Account field, specify the desired values.
- In the Debit field, enter any amount.
- In the Offset account type field, select 'Bank'.
- In the Offset account field, specify the desired values.
- In the Currency field, enter or select a value.
- You may use value 'USD'.
- Click Functions.
- Click Exchange rate calculation.
- In the From date field, enter a date.
- Select a transaction date to specify a period. Ledger transactions are included in the calculation of the average exchange rate if the transaction dates are on or after the date that you enter in this field, and before the transaction date of the journal line. If you leave this field blank, the calculation includes all ledger transactions for which the transaction dates are before the transaction date of the journal line.
- Expand the Records to include section.
- Use ‘Records to include tab’ to set up selection criteria for the lines to include in the exchange rate calculation. If you do not set up selection criteria in the Filter form, the calculation method that you selected is used for all lines in the current journal.
- Click OK.