Error message when you post the receipt of bank deposits in Microsoft Dynamics GP 9.0/GP 10.0: "One or more exchange tables cannot be found"

Applies to: Dynamics SL Bank ReconciliationDynamics SL Bank Reconciliation

SYMPTOMS


When you post the receipt of bank deposits in the Bank Deposit Entry window in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains, you receive the following error message:

One or more exchange tables cannot be found.

The receipt came from the Cash Receipts Entry window.

CAUSE


This problem occurs for one of the following reasons:

• The expiration date format is incorrect in the Multicurrency Exchange Rate Maintenance window.
• The exchange rate information is damaged.

    RESOLUTION


    Prerequisites

    Before you resolve this problem, you must first verify the expiration date of the exchange rate. To do this, follow these steps:
    1.

    Use the appropriate step:

    • In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Setup , point to System , and then click Exchange Table .
    • In Microsoft Dynamics GP 9.0 or in Microsoft Business Solutions - Great Plains 8.0, point to Set on the Tools menu, point to System , and then click Exchange Table .



       
    2. Click Rates .
    3. In the Exchange Table ID field, select the exchange table ID that you want to verify.
    4. Verify the expiration date of the exchange rate that is used by the transaction.
    If the exchange rate is expired, use Method 1 to resolve this problem. However, if the exchange rate is not expired, use Method 2 to resolve this problem.

    Method 1

    1. Delete the exchange rate. To do this, follow these steps:
    a. In the Exchange Rate field, click the exchange rate that has the expired date. The exchange rate information is automatically selected when you click it.
    b. Click Remove . When you are prompted to delete the exchange rate, click Delete .
    2. Enter a new exchange rate that has a correct expiration date. To do this, follow these steps:
    a. In the Exchange Rate field, enter an exchange rate.
    b. In the Expiration Date field, enter an expiration date. The expiration date should be after the document date of the document that uses the exchange rate. You cannot use the exchange rate after the date that you enter here.
    c. In the Date field, enter a date when the exchange rate will be used.
    d. Click Insert .
    e. Click Save .
    3. Run the Check Links procedure against the following tables: • Multicurrency Setup
    • Multicurrency Account Master
    • Multicurrency Revaluation
    • CM Transaction
    • CM Setup
    • Multicurrency System Setup
    • Multicurrency Access


       
    If you run the Check Links procedure, any damaged data is restored, and the data integrity is ensured. To run the Check Links procedure, follow these steps:
    a.

    Use the appropriate method:

    • In Microsoft Dynamics GP 10.0, point to Maintenance on the Microsoft Dynamics GP menu, and then click Check Links .
    • In Microsoft Dynamics GP 9.0 or in Microsoft Business Solutions - Great Plains 8.0, point to Maintenance on the File menu, and then click Check Links .



       
    b. In the Series list, select Financial .
    c. In the Logical Tables section, click the Multicurrency Setup table, and then click Insert to insert this table into the Selected Tables section.
    d. Repeat step c to insert the following tables into the Selected Tables section: • Multicurrency Account Master
    • Multicurrency Revaluation
    • CM Transaction
    • CM Setup


       
    e. Click OK .
    f. Open the Check Links window again.
    g. In the Series list, select System .
    h. In the Logical Tables section, click the Multicurrency System Setup table, and then click Insert to insert this table into the Selected Tables section.
    i. In the Logical Tables section, click the Multicurrency Access table, and then click Insert to insert this table into the Selected Tables section.
    j. Click OK .
    4. Try to post the deposit again.

    Method 2

    If this problem still occurs, the transaction may already be damaged. To resolve this problem, void the transaction, and then reenter the transaction. To do this, follow these steps:
    1. Void the original receipt that came from Receivables Management in Microsoft Dynamics GP. To do this, follow these steps:
    a. On the Transactions menu, point to Sales , and then click Posted Transactions .
    b. In the Customer ID field, select the customer ID.
    c. In the Document Type field, select Payment .
    d. In the Number field, select the original document number or the original receipt number.
    e. In the Void Date field, enter the original transaction date.
    f. In the Posting Date field, enter the original posting date.

    Note If you enter the original posting date, the original transaction that is created in General Ledger may be removed. Make sure that you post the void batch in General Ledger.
    g. Click Void .

    Note If you void the document receipt number in the Receivables Posted Transaction Maintenance window, the receipt in the Bank Deposit Entry window is automatically removed.
    2. Reenter the receipt in the Cash Receipt Entry window.
    3. On the Transactions menu, point to Financials , and then click Bank Deposit .
    4. In the Bank Deposit Entry window, click the checkbook ID that is used.
    5. Click the receipt that came from the Cash Receipts Entry window.
    6. Click Post .

    MORE INFORMATION


    If you are registered for Multicurrency Management in Microsoft Dynamics GP, transactions that have currency IDs are created. The system always looks for a valid exchange rate for the transaction. By default, the system looks for a valid exchange rate that has the same date as the document. If there is no valid exchange rate for that date, the system refers to the Transaction Rate Default settings that are specified in the Multicurrency Exchange Rate Table Setup window.

    Valid values for the Transaction Rate Default settings

    Exact Date
    Select this option if you want to use an exchange rate that has an exchange rate date that is the same as the transaction date.
    Previous Date
    If you select this option, and if there is no exchange rate for the transaction date in the assigned table, an exchange rate that is valid on the closest date before the transaction date is displayed. If there is no valid exchange rate within the dates that are searched before the transaction date, the most recent valid exchange rate after the transaction date is displayed.
    Next Date
    If you select this option, and if there is no exchange rate for the transaction date in the assigned table, an exchange rate that is valid on the closest date after the transaction date is used. If there is no exchange rate that is valid after the transaction date, the most recent valid exchange rate before the transaction date is displayed. To view the exchange rate information, click Rates .


       

    Information about exchange rates in the Multicurrency Exchange Rate Maintenance window

    Expiration Date
    Enter an expiration date for the specified exchange rate. You cannot use the exchange rate after the date that you enter here. The default expiration date is calculated based on the frequency that you select for the exchange rate table ID in the Multicurrency Exchange Rate Table Setup window.
    Exchange Rate
    Enter an exchange rate for the specified currency ID and for the specified exchange table. The exchange rate is stored together with the table until you clear the information. The rate is valid from the rate date to the expiration date.