Fix Sage ACH File Generation Error After Migration or Upgrade

Fixing ACH File Generation Errors After Sage Migration

Resolving Sage Locked Access After Migration

When undergoing a migration or upgrade within your Sage platform, it's possible to encounter issues that disrupt standard operations. One such issue emerges when attempting to generate ACH (Automated Clearing House) files within the Accounts Payable module. This article addresses a specific error and provides actionable steps to rectify the problem.

Encountering ACH File Generation Errors

Issue Description

After a migration, users attempting to execute the Accounts Payable > Check Printing and Electronic Payment > Generate ACH File command may face an error that prevents the creation of an ACH file. This is an option which is set at each company code level.

Solution

The root of this issue often lies in outdated file path references within the Sage application. Specifically, the path for ACH Electronic Payments may not have been updated during your system's migration or upgrade.

To resolve this, follow the steps below:

  1. Navigate to Accounts Payable Options:

    • Open the Accounts Payable module.
    • Go to Accounts Payable > Setup > Accounts Payable Options.
  2. Update ACH Path Details:

    • Click on the ACH (tab) in the Accounts Payable Options.
    • Locate the ACH Electronic Payments Folder field.

    • Update the path from the existing value to \\localhost\profile$\group\ACH.
    • Click Accept to save changes.
  3. Notes
    If your Sage hosted server is running 2 or more servers, the path will be different, in which case, you will need the hostname of your Sage application server. Please contact support for assistance with this.
  4. Apply Across All Relevant Company Codes:

    • Ensure that you repeat the same update for any other company codes that use this feature to avoid encountering the same problem with different accounts.

Final Steps and Testing

Once the path has been updated, attempt to generate the ACH file again. This change should resolve the error by directing the ACH file output to the newly specified and accessible directory. If the error persists, or if issues arise for additional company codes, further assistance may be required.