Checks are not printed in Payables Management in Microsoft Dynamics GP

a.

Follow the steps in the following Knowledge Base article:

850289A batch is held in the Posting, Receiving, Busy, Marked, Locked, or Edited status in Microsoft Dynamics GP

An Automated Solution script may be available to perform this task. For more information about batches that are held in the Posting, Receiving, Busy, Marked, Locked, or Edited status, visit the following Microsoft Dynamics Web site:

https://mbs.microsoft.com/customersource/support/selfsupport/AutomatedSolutions.htm

b.

On the Transactions menu, point to Purchasing , and then click Batches .

c.

In the Payables Batch Entry window, click the appropriate batch in the Batch ID list, and then click Delete . When you are prompted to delete the batch, click Delete .

d.

On the Transactions menu, point to Purchasing , and then click Select Checks .

e.

In the Select Payables Checks window, create a new batch ID, and then process the check batch. If the checks are not printed, go to step 2.

a.

Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.

Method 1: For SQL Server Desktop Engine If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, click Start , point to All Programs , point to Microsoft Administrator Console , and then click Support Administrator Console .

Method 2: For SQL Server 2000 If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start , point to All Programs , point to Microsoft SQL Server , and then click Query Analyzer .

Method 3: For SQL Server 2005 If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start , point to All Programs , point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio .

b.

Run the following script against the company database. Select * from PM00400 where CNTRLNUM in (select PMNTNMBR from PM10300 where BACHNUMB = ‘<X>’) and DOCTYPE = 6 Note Replace the placeholder

c.

Verify that the results display only the records for the checks that you want to print. If the results do not display only the records for the checks that you want to print, contact your partner or technical support for more information. To contact Microsoft Dynamics Technical Support, visit the following Web site:

https://mbs.microsoft.com/support/newstart.aspx

You can also contact Microsoft Dynamics Technical Support by telephone at 888-477-7877.

d.

If the results display only the records for the checks that you want to print, run the following script against the company database. Delete PM00400 where CNTRLNUM in (select PMNTNMBR from PM10300 where BACHNUMB = ‘<X>’) and DOCTYPE = 6 Note Replace the placeholder

e.

Follow the appropriate step:

• 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 .

f.

Click Purchasing in the Series list, click Payables Transaction Logical File in the Logical Tables list, click Insert , and then click OK . When you are prompted to print the Error Log report, select a destination.