There are three exchange rates that Microsoft Dynamics NAV uses when consolidating the financial statements of business units if the financial statements are in a foreign currency. They are: Average Rate (Manual), Closing Rate and Last Closing Rate. Typically, Average Rate (Manual) is used for income statement accounts, and Closing Rate is used for balance sheet accounts. The chart of accounts in the business unit's company specifies which rate is used for which accounts.

If the Currency Exchange Rate Table field on the business unit card contains Local, you can change the exchange rate from the business unit card. The exchange rates are copied from the Currency Exchange Rate table, but you can change them before consolidating. Before you can enter the exchange rates, you must enter information about the relevant business unit.

For more information, see How to: Enter Basic Information for Consolidated Companies.

To specify exchange rates for consolidations

  1. In the Search box, enter Business Units, and then choose the related link.

  2. In the Business Unit List window, select the line with the relevant business unit. On the Navigate tab, in the Exch. Rates group, choose Average Rate (Manual).

  3. In the Change Exchange Rate window, the contents of the Relational Exch. Rate field have been copied from the Currency Exchange Rate table, but you can modify them. Close the window.

  4. In the Search box, enter Business Units, and then choose the related link.

  5. On the Navigate tab, in the Exch. Rates group, choose Closing Rate.

  6. Modify the contents of the Relational Exch. Rate field as appropriate.

Tip

See Also