Sage 100

 View Only
  • 1.  Accounts Payable ACH File Format

    Posted 04-23-2020 08:38
    The bank is asking if the Sage 100 ACH file format is ISO 20022, NACHA or delimited.  I believe I have eliminated delimited as a choice as there are no tabs, spaces, commas or other delimiters.  I believe it is NACHA but not positive and cannot find any documentation.  Can someone confirm the file format?

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------


  • 2.  RE: Accounts Payable ACH File Format

    Posted 04-23-2020 09:00
    NACHA

    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------



  • 3.  RE: Accounts Payable ACH File Format

    Posted 04-23-2020 09:01
    NACHA

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



  • 4.  RE: Accounts Payable ACH File Format

    Posted 04-23-2020 09:04
    Thank you @Beth Bowers and @Eric Lunceford ​​​​​​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 5.  RE: Accounts Payable ACH File Format

    Posted 04-23-2020 10:27
    Have fun finding someone at the bank to help you debug the set up.  If you are lucky, they will send you the NACHA spec.  Just went through the teeth pulling last week.  What an ordeal. Banks make you appreciate Sage tech support...........

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 6.  RE: Accounts Payable ACH File Format

    Posted 04-23-2020 10:35
    I already have a NACHA spec and I already sent  a test file and it was approved.  Last night I received the following email from a different person at the bank:  " I was hoping to pull the test file you had sent Cathy during the ACH implementation but I'm getting an error trying to open the file. Can you please confirm if the file format was ISO 20022, NACHA or delimited?"  

    Not sure what she means by "hoping to pull the test file".

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 7.  RE: Accounts Payable ACH File Format

    Posted 04-23-2020 11:03
    Sounds like the person doesn't understand that Notepad will open the file..

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------