Sage 100

Customer called asking how they can submit a list of voids for an ACH run. I do not think Sage creates such a file and you have to manually deal with the void when you are submitting ACH. Anyone have a different experience?

Do they mean a reversal?

Apparently they're in the process of submitting an ACH. Found an incorrect entry and voided it. Then recreated the ACH which apparently still includes the check entry and ignores the void.

Here's one Sage KB that I found on the recommended procedure. Looks as if Sage does not account for this. How to void or reverse Accounts Payable ACH Electronic Payments and remove them from the ACH file. Products Sage 100 ERP Description How to void or reverse Accounts Payable ACH Electronic Payments and remove them from the ACH file. Disclaimer Backup Warning Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage Business Partner, network administrator, or Sage Customer Support Analyst. Resolution Reverse the Electronic Payment in Manual Check Entry and update AP_ACHGenerationDetail in Data File Display and Maintenance (DFDM). Reverse the Electronic Payment Open Accounts Payable, Main, Manual Check Entry. In the Bank Code field, enter the bank code associated with the check to reverse. At the Payment Type field, click the drop down and select Electronic Payment Reversal. In the Check No field, enter the ACH check number that is being reversed. In response to the question to Do you want to recall invoices paid by this electronic payment? click Yes to reopen the original invoice or click No leave the original invoices closed. If No is selected, click the GL Distribution button to select the general ledger account from the Lines tab. If Yes is selected, the invoice amount will be displayed with a negative amount on the Lines tab. Click Accept to save and update the changes. Remove the Electronic Payment transaction from the ACH file. Delete the batch detail record from AP_ACHGenerationDetail. Open Library Master, Utilities, Data File Display and Maintenance (DFDM). Select ..\Mas90\Mas_xxx\Apxxx\AP_ACHGenerationDetail (xxx = company code) Click Key Scan to display the list of records. Note the following: The first six digits represent the batch number, which matches the batch number printed on the Direct Deposit Register. Records with exactly six digits in the key are the AP_ACHGenerationDetail batch header records. Records with more than six digits in the key are the detail records for that batch. Each detail record represents one check. Select the detail record to be removed, and click the Delete key. Perform either of the following, depending on whether the ACH file was already created: If the ACH file exists, change the Transmitted field to N for the batch header record in AP_ACHGenerationsHeader file Note: ""Transmitted"" indicates whether the batch has been used to create an ACH file. It does not mean that the ACH files were sent to the bank. Click Key Scan again, and select the batch header record of the detail record deleted above. Click Edit, and select the Transmitted field. In the Change field, replace Y with N. Close DFDM. Open Accounts Payable, Check Printing and Electronic Payment, Generate ACH File and create a file for Batches Never Transmitted. If the ACH file does not exist, open Generate ACH File and create the ACH file as usual After the electronic payment is reversed, you need to manually adjust the Deposited YTD amount in Vendor Electronic Payment window for the bank accounts affected by the reversal. (Access in Vendor Maintenance, click down arrow next to More button and select Electronic Payment)