Sage 100

 View Only
Back to discussions
Expand all | Collapse all

AP ACH file - v4.5 - need help with ACH config options

  • 1.  AP ACH file - v4.5 - need help with ACH config options

    Posted 08-27-2021 20:11
      |   view attached

    Test file generated on 6/24 "looks good" when opened in Notepad and was accepted by bank, although there was only 1 payment.

    Live file generated yesterday, 8/26, was rejected by the bank (BMO Harris) with this note: "Your consultant would need to correct the settings in your software for each line to end at position 94 and ensure the file is generated as a text (.txt) file".  Of course, Sage can't generate a .txt file, but the user renamed the extension to .txt before uploading.

     The file does not "ook "good" in Notepad or Notepad++.  There are multiple vendor payments in the file.  I have copied the file to my local workstation.  When opened, it looks the same as when opened in their environment.

     I replicated their settings in my local 4.5.  When I generate a file and view it in Notepad or Notepad++, the file looks "good".  However, when I copy it to their system and open it in Notepad, it changes.  I've turned WordWrap on and off and it still doesn't look right.

     Here's a comparison of the file generated on my system:

     

    Relevant settings (at least the ones I think are relevant: 

    File Control Record:  Pad File to Block Size enabled – Block Size to 10

    Add CR/LF After Each Record = Yes.

     The NACHA spec they provided calls for Block Size 10.  I have experimented with all 5 options for CR/LF.  In their system, I can't get a file that looks good.  On my system, in NotePad++, the files with Yes, CR only and LF all view the same, but I'm guessing are structurally different.

     I have 2 problems to solve:
    1. Does renaming the extension to .TXT make the file unrecognizable to them?

    2. What config changes are necessary?  I don't know how, in Sage, to correct the setting per the bank's comment - "Your consultant would need to correct the settings in your software for each line to end at position 94"

     Any ideas?



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Attachment(s)

    pdf
    ACH Config.pdf   68 KB 1 version


  • 2.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-27-2021 20:32
    Did they open it and resave it with the TXT extension instead of just renaming the file from Windows Explorer?

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------



  • 3.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-27-2021 22:28
    Not sure.  Do  you think they should just rename instead of opening and saving as?  That seems to make sense to me.  I'll check.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


  • 4.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-28-2021 08:39
    Do you have this ACH file edit tool ? I find that is sometimes helpful in these situations

    https://sourceforge.net/projects/achviewer/

    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------





  • 5.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-28-2021 08:52
    @Wayne Schulz - that utility is a *bleep*ing lifesaver.  Can't tell you how many times I've been a hero with that.​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------

    Original Message


  • 6.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-28-2021 09:41
    I downloaded my copy of ACHViewer based on @Beth Bowers recommendation many moons ago.  It should be in every consultants tool box.  VERY helpful.
    ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 7.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-28-2021 09:55
    Barb
    I have a customer that I have to open their ACH in WordPad for them to 'look good'.  
    I would agree with Beth on the open/save or rename.
    N

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------

    Original Message


  • 8.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-28-2021 11:21
    Open the ACH file in Notepad++.  Click View, Show Symbol, Show All Characters. There should be CR|LF beginning at position 95 for every record.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 9.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-29-2021 18:03
    @Doug Higgs, thanks for the tip with Notepad++!  So it looks like there are too many CR/LFs!  Is there something wrong with the config? 
    ​

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


  • 10.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-30-2021 08:12
    If the same setup works on your office test system but doesn't work on your customer's system then it most likely isn't a configuration issue.  The issue is most likely related to data corruption during the file creation process or when the file is being renamed. You might consider contacting Sage.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 11.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-30-2021 13:41
    Those extra CRLF may be part of the data, copied from Excel into Sage.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 12.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-29-2021 10:24
    You shouldn't have to rename the file to "txt".  The file is already a text file although it has an ACH extension.  make sure Notepad is associated with the ACH file type.  Right click on the file, then click "Open with..", Make sure the "Always use this app to open .ACH files" is checked, then choose Notepad.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 13.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-29-2021 10:49
    @Doug Higgs - I actually have at least one bank that will not accept the extension ACH and requires TXT.  Same format, but they want what they want and there you go.​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------

    Original Message


  • 14.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 08-29-2021 12:11
    @Beth Bowers. I've set up a lot of ACH and never encountered that before but maybe the customer does the rename and I don't know about it.  I'm going to see if I have anyone using BMO and if they have to rename.​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 15.  RE: AP ACH file - v4.5 - need help with ACH config options

    Posted 09-02-2021 18:14
    RESOLVED!  They didn't confirm, but I'm guessing they did copy/paste bank info from Excel.  Steps to resolve: 
    1. Replace field data in AP_VendorElectronicPayment - had them blank out and hand key, but also needed to DFDM the file to remove the funky characters.
    2. Fix data in AP_ACHGeneration Detail, which I learned doesn't get re-written when you regenerate ACH files.

    Thanks everyone!  


    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


Related Content