Sage 100

 View Only

  • 1.  ACH file missing lines

    Posted 01-23-2025 11:48

    I pity my clients. One of them gets something weird happening and then I apparently spread it and then everyone is having it happen.

    So this began with someone who was creating a PR ACH file, but now I've also seen it with an AP ACH file.  The file is created, no error message, but if you look at it, only part of the records are there.  With the PR client, it was missing employees and then all the total records at the bottom.  The AP client happened to only be paying 1 vendor, but their bank required multiples of 10 lines, and they didn't have enough 99999999 lines to make their 10.

    In both cases (and this has happened multiple times now for both), if you just regenerated the ACH file, it came out find the second time.

    Has anyone else had this happen? I suppose I'll open a case, but it will leave us both cranky, since Sage will want me to recreate on demand and I can't.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------


  • 2.  RE: ACH file missing lines

    Posted 01-23-2025 11:56

    Beth,

    Amazing – I just had the exact same thing happen at a client today. I don't usually help this particular client so I asked a coworker about it and she confirmed that it does happen from time to time she said the first time the ACH generates, it's an incomplete file.  She usually goes and finds the Batch via DFDM and set the "Processed" flag back to NO and re-runs it.

     

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    260.399.8655 Direct

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

    A black background with white text Description automatically generated

     






  • 3.  RE: ACH file missing lines

    Posted 01-23-2025 11:59

    Yay, I'm not alone!  But I've never had to DFDM - I just rerun Generate ACH file and choose to do Batches Already Processed and use the date and it reruns it just fine.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


  • 4.  RE: ACH file missing lines

    Posted 01-23-2025 12:27

    When she said that I wondered if she knew that reprinting previously processed was an option, but didn't ask. I should probably follow up with her on that.

     

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    260.399.8655 Direct

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

    A black background with white text Description automatically generated

     




    Original Message


  • 5.  RE: ACH file missing lines

    Posted 01-23-2025 14:03

    Is this for the manually created ACH files ( as opposed to the ACH service that automates much of this)?



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 6.  RE: ACH file missing lines

    Posted 01-23-2025 14:24

    @Wayne Schulz - yes, that's the kind



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


  • 7.  RE: ACH file missing lines

    Posted 01-23-2025 14:25

    I had this happen recently too, although I don't recall if if was for PR or AP.



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


  • 8.  RE: ACH file missing lines

    Posted 01-23-2025 14:37

    Excellent! (You know what I mean) I posted to Sage City - will see if anyone else posts.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


Related Content