You receive an error message in Microsoft Dynamics GP when you try to enter a checkbook transaction

This article provides a solution to an error that occurs when you enter a checkbook transaction.

Applies to:   Microsoft Dynamics GP
Original KB number:   874139

Note

Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

Symptoms

When you try to enter a checkbook transaction in Microsoft Dynamics GP, you receive one of the following error messages:

  • Error message 1

    The checkbook ID must have the functional currency ID assigned to it.

  • Error message 2

    You must register Multicurrency Management before selecting this checkbook.

  • Error message 3

    The currency on the transaction must be either the functional currency or the currency assigned to the selected checkbook.

  • Error message 4

    The currency on the transaction must be the same as the currency assigned to the selected checkbook.

Cause

This problem occurs if one of the following conditions is true:

  • You recently registered Multicurrency in Microsoft Dynamics GP in your Microsoft Dynamics GP company after you set up your current checkbooks.
  • You recently defined a functional currency in your Microsoft Dynamics GP company. However, you are currently not registered for Multicurrency.

Resolution

To resolve this problem, follow these steps:

  1. Verify your functional currency. To verify your functional currency, point to Setup on the Tools menu, point to Financial, and then click Multicurrency.

  2. Use SQL Query Analyzer to obtain your functional currency index. To do this, follow these steps:

    1. Start SQL Query Analyzer.

    2. In the database list, click your company database.

    3. Copy the following statement into the query pane.

      select FUNLCURR, FUNCRIDX from MC40000
      
    4. On the Query menu, click Execute.

  3. Verify your checkbook currency. To do this, follow these steps:

    1. On the Cards menu, point to Financial, and then click Checkbook.
    2. In the Checkbook ID box, type your checkbook ID.
  4. In the Currency ID box, type your functional currency ID.

  5. Run the Check Links procedure on the financial series so that all the current transactions are updated to contain the correct currency information. To do this, follow these steps:

    1. On the File menu, point to Maintenance, and then click Check Links.
    2. Click All.
    3. Click OK.
    4. In the Report Destination dialog box, click to select the Screen check box, and then click OK.

Disclaimer

Microsoft and/or its suppliers make no representations or warranties about the suitability, reliability or accuracy of the information contained in the documents and related graphics published on this website (the "materials") for any purpose. The materials may include technical inaccuracies or typographical errors and may be revised at any time without notice.

To the maximum extent permitted by applicable law, Microsoft and/or its suppliers disclaim and exclude all representations, warranties, and conditions whether express, implied or statutory, including but not limited to representations, warranties, or conditions of title, non infringement, satisfactory condition or quality, merchantability and fitness for a particular purpose, with respect to the materials.