![server checkbook server checkbook](https://i.pinimg.com/originals/01/2b/4b/012b4bfa403a67a4e13adf8f0f5885a1.jpg)
Run the following statement against the company database: Select * from CM00100 to do this, select Start, point to All Programs, point to Microsoft SQL Server 2008, and then select SQL Server Management Studio.
![server checkbook server checkbook](https://i.ebayimg.com/images/g/l~QAAOSw5CNg2YcL/s-l225.jpg)
If you are using SQL Server 2008, start SQL Management Studio. To do this, select Start, point to All Programs, point to Microsoft SQL Server 2005, and then select SQL Server Management Studio.
![server checkbook server checkbook](https://images-na.ssl-images-amazon.com/images/I/91F5jmJbf9L._SL1500_.jpg)
If you are using SQL Server 2005, start SQL Server Management Studio. To do this, select Start, point to All Programs, point to Microsoft SQL Server, and then select Query Analyzer. If you are using SQL Server 2000, start SQL Query Analyzer. To do this, select Start, point to All Programs, point to Microsoft Administrator Console, and then select Support Administrator Console. If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, use one of the following methods depending on the program that you are using. Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio.
#SERVER CHECKBOOK UPDATE#
If the Currency ID field is unavailable, update the currency ID by using SQL scripts. I was shaking and had tears of happiness after what he left me. Verify that each checkbook ID has a currency ID assigned. When I was given the checkbook, I went to put in the tip & information to close the table and I couldn’t believe it. On the Cards menu, point to Financial, and then select Checkbook. To resolve this problem, follow these steps: If you are not registered for Multicurrency Management, then you must update the CURNCYID field by using a SQL script to update the Checkbook Setup (CM00100) table. To select a checkbook on the forecast ID, a currency ID must be mapped to the checkbook ID. This problem occurs because a currency ID is required in the Checkbook Maintenance window. This behavior occurs even though Multicurrency Management is not registered. You receive the following error message in Cash Flow Management in Microsoft Dynamics GP and Microsoft Business Solutions - Great Plains 8.0:Įxchange rate information must be entered before selecting a Checkbook ID. 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.Īpplies to: Microsoft Dynamics GP Original KB number: 970223 Symptoms