You are currently offline, waiting for your internet to reconnect

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

INTRODUCTION
This article describes how to perform the following tasks before you generate an Electronic Funds Transfer (EFT) file:
  • How to remove an EFT batch that was voided in the Payables Management module in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains.
  • How to delete the EFT batch that was voided from the EFT Payables Management tables in Microsoft SQL Server.
More information
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.
Properties

Article ID: 894693 - Last Review: 04/25/2016 15:52:00 - Revision: 5.0

Microsoft Dynamics GP 2010, Electronic Funds Transfer for Payables Management, Payables Management

  • kbnosurvey kbexpertiseinter kbexpertisebeginner kbmbsmigrate kbhowto KB894693
Feedback
>y>