How to remove and then delete an EFT batch that was voided in Microsoft Dynamics GP

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.

Microsoft Dynamics GP 10.0

To remove and then delete the EFT batch that was voided, you must remove the batch from the CM20202 and CM20203 tables by using SQL Query Analyzer. To do this, follow these steps:

1. 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.
   
2. In the Query pane, enter the following SELECT statements. Make a note of the numeric value of the DEX_ROW_ID column that is returned by the query.

   SELECT * FROM CM20202 
   SELECT * FROM CM20203 
   

   Note Verify that the returned results contain the batch ID of the batch that you want to delete.
3. Press F5 to run these statements.
4. Type the following DELETE statements.

   DELETE CM20203 where BACHNUMB = 'XXX'
   DELETE CM20202 where BACHNUMB = 'XXX'
   

   Note In these statements, replace nnn with the batch ID of the batch that you want to delete.

Microsoft Dynamics GP 9.0 and Microsoft Business Solutions - Great Plains 8.0

To remove and then delete the EFT batch that was voided, you must remove the batch from the ME234602 table and from the ME234603 table by using SQL Query Analyzer. To do this, follow these steps.

1. 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.
   
2. In the Query pane, enter the following SELECT statements. Make a note of the numeric value of the DEX_ROW_ID column that is returned by the query.

   SELECT DEX_ROW_ID, * FROM ME234602 WHERE BACHNUMB = ‘nnn’
   SELECT DEX_ROW_ID, * FROM ME234603 WHERE BACHNUMB = ‘nnn’

   Note In this statement, replace nnn with the batch ID of the batch that you want to delete.
3. Press F5 to run these statements.
4. Verify that the SELECT statements returned the appropriate batch.
5. Type the following DELETE statements.

   DELETE ME234602 WHERE DEX_ROW_ID = 'nn'
   DELETE ME234603 WHERE DEX_ROW_ID = 'nn'

   Note In these statements, replace nn with the numeric value of the DEX_ROW_ID column for the batch that you want to delete.
6. Press F5 to run these statements.

After you follow these steps, this batch is not available for file generation in the EFT for Payables Management module.