Acute Data Systems

How to regenerate Sage 100 ACH files

Summary

How to regenerate an Accounts Payable (AP) ACH file in Sage 100. Follow these steps if you need to recreate an ACH file that you never transmitted or one that you already transmitted.

Resolution

ACH file not transmitted

  1. Expand Modules, Accounts Payable, Check Printing and Electronic Payment.
  2. Click Generate ACH File.
  3. Select the appropriate Bank Code.
  4. Enter the File Code.
  5. Select Only Batches Never Transmitted.
  6. Click Proceed.

ACH file transmitted but needs regenerated

  1. Expand Modules, Accounts Payable, Check Printing and Electronic Payment.
  2. Click Generate ACH File.
  3. Select the appropriate Bank Code.
  4. Enter the File Code.
  5. Select Only Batches Previously Transmitted.
  6. Enter the Effective Date and/or Transmission Date.
  7. Click Proceed.

OR

  1. Expand Modules, Library Master, Utilities, Data File Display and Maintenance.
  2. Click OK to the warning prompt.
  3. In the File Name field, type AP_ACHGenerationHeader and press Enter.
  4. Click the Key lookup to search and select the batch.
  5. Click the Edit button and select FileTransmitted$.
  6. In the Change field, change Y to N (must be uppercase).
  7. Exit the Data File Display and Maintenance window.
  8. Follow the instructions above If ACH file was never transmitted.
Sage 100
Request Support