How to regenerate Accounts Payable ACH file in Sage 100

Summary

Use these steps when you have created an AP (A/P) file and need to regenerate it.

Resolution

CAUTION: 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.

If ACH file was never transmitted:

Expand Modules, Accounts Payable, Check Printing and Electronic Payment
Generate ACH File
Select, Bank Code
Enter, File Code
Select, Only Batches Never Transmitted
Click, Proceed

If ACH file was transmitted but, needs to be regenerated:

Expand Modules, Accounts Payable, Check Printing and Electronic Payment
Generate ACH File
Select, Bank Code
Enter, File Code
Select, Only Batches Previously Transmitted
Enter, Effective Date and/or Transmission Date
Click, Proceed

Expand Modules, Librabry Master , Utilities, Data File Display and Maintenance
Click OK to the Warning prompt
In the File Name type AP_ACHGenerationHeader and press Enter
Click the Key lookup to search and select the batch
Click the Edit button and select FileTransmitted$
In the Change field, change Y to N (must be uppercase)
Exit the Data File Display and Maintenance Window
Follow above instructions for ‘If ACH file was never transmitted’