Sage 100

 View Only

  • 1.  Sage 100c ACH for Canada

    Posted 07-22-2019 11:10
    Client is opening a Canadian bank account for Canadian vendor payments.  Does the Sage ACH DD work the same for Canada?  Need some advice.

    TIA

    @Kevin Moyes​

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


  • 2.  RE: Sage 100c ACH for Canada

    Posted 07-22-2019 11:14
    NO IT IS NOT!!!!!!!!!!!!!!
    Got a quote from DSD for it once, but client didn't go through with it.

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



  • 3.  RE: Sage 100c ACH for Canada

    Posted 07-22-2019 11:19
    Wow, that was fast!!!!  Thanks

    In reading their fine print with my glasses on, it appears that they are asking about positive pay instead.  They dumped an 87 page RBC document last updated in 2015 on me as well.  Does anyone have the Cliff Note version of this?  Something like, here is the output spec all on one page???

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

    Original Message


  • 4.  RE: Sage 100c ACH for Canada

    Posted 07-22-2019 11:30
    Edited by alan niergarth 07-22-2019 14:55
    We have worked with a company for positive pay for their Canada operation.  It was not a simple as most US files.  I might add that we create the file and then their IT staff has automated the process to connect to the bank for upload.  Something like what @Robert White mentions may be needed.  

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------

    Original Message


  • 5.  RE: Sage 100c ACH for Canada

    Posted 07-22-2019 17:18
    We’ve done several banks for a client with a Toronto company.
    Contact Barbara Goldstein.

    ---------------------------------
    Bob Pfahnl
    General Manager - Silicon Valley Office
    DSD Business Systems
    CA
    408-641-0922
    ---------------------------------



    Original Message


  • 6.  RE: Sage 100c ACH for Canada

    Posted 07-23-2019 10:24
    As Robert mentioned, each of the major Canadian banks has their own EFT file format, and using Scheduler is a big help in formatting.
    Positive Pay... just read the bank's specification document and go through the Sage configuration wizard.  I've done that for TD, not RBC... but expect it should be possible without any external processing.  VC and a custom report are always an option too for PP.

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

    Original Message


  • 7.  RE: Sage 100c ACH for Canada

    Posted 07-22-2019 13:47
    We use a product from a company based in Vancouver area.  Export a file from Sage, import into The Scheduler, The Scheduler creates file that is uploaded to bank website.  It's called The Scheduler available at https://www.rbanderson.com/   Different Canadian banks have different formats, so you to order the bank specific version

    ------------------------------
    Robert White
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 8.  RE: Sage 100c ACH for Canada

    Posted 07-22-2019 13:53
    Love your profile pic, @Robert White​

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

    Original Message


  • 9.  RE: Sage 100c ACH for Canada

    Posted 07-22-2019 14:56
    It looks like The Scheduler software has an evaluation version.  You might be able to export data from Sage 100, import to The Scheduler and then see how the ACH (or whatever it is called) file is formatted.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 10.  RE: Sage 100c ACH for Canada

    Posted 07-22-2019 15:05
    @Jeff Schwenk,   @David Kilbourn and I created a Positive pay export  using Crystal reports and Visual cut.   ​​It automatically kicked out a file each day.

    ------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ------------------------------

    Original Message


Related Content