Open Forum

 View Only

  • 1.  Safe Pay GP 2013 Full Vendor info

    SILVER CONTRIBUTOR
    Posted Nov 25, 2019 09:26 PM
    Good evening,

    we are using GP2013 SP1 where I have just installed the Safe Pay product. I created the confiutration file, however now my bank is requireing to have the full Vendor info on the file - which includes the address.

    Is this even possible? I have tried different field options with no decent result.
    If I can't is there another product I can use?

    Thanks so much!!
    Super desperate currently :)

    ------------------------------
    Angela Harris
    Territorial Financial Systems Administrator
    The Salvation Army-Central THQ
    Hoffman Estates
    ------------------------------


  • 2.  RE: Safe Pay GP 2013 Full Vendor info

    TOP CONTRIBUTOR
    Posted Nov 26, 2019 07:21 AM
    @Angela Harris, in all my years being involved with GP, both as a user and a consultant I have never hear of this. The native GP SafePay configuration does not have this capability. ​But hope is not lost!

    One thing you may consider is to create a smart list in the Purchasing >> Payables section that contains most of the information you need, in the correct order, and then export it into Excel.
    • Start with the prefabricated smart list already there called Today's Payments.
    • Add the vendor address lines into it (Address 1, City, State, Zip)
    • Restrict the query to just the one bank you need to send it to.
    • Save the smart list with a name like "Smartlist-Bank Name".  

    Export the results to excel. Then you have 2 choices.
    1) Add the other columns that ​​the bank requires to this file in the order your bank wants to see it, save it down to a CSV or Text Tab Delimited (whichever you bank will accept) and upload that file. OR
    2) Create the SafePay file from within GP and open it in excel, copy the address fields on to the associated lines, re-save it and send that file to the bank.

    My fingers are crossed that one of these options will work for you. Keep us posted as to what your ultimate solution was so we can all learn from it.


    ------------------------------
    Barbara Gavron
    Atlantic Beach / Jacksonville FL
    904-536-0129
    ------------------------------

    Original Message


  • 3.  RE: Safe Pay GP 2013 Full Vendor info

    Posted Nov 26, 2019 07:35 AM
    Hi Angela,

    We have had a number of requests from our clients where information is needed on either EFT or Safe Pay files that isn't compatible with GP's functionality.  In a number of cases, we have built automated routines that will export the day's check run(s) through either a SQL job, batch file, or Powershell script.  That also gives us the ability to automatically upload the file to the bank if they have that functionality available. 

    If you would like to discuss it further, please let me know. 

    Thank you.

    ------------------------------
    David Feenstra
    dfeenstra@manersolutions.com
    DIrector of Business Solutions and Technology
    Maner Technology Solutions
    Lansing, Mi
    ------------------------------

    Original Message


  • 4.  RE: Safe Pay GP 2013 Full Vendor info

    TOP CONTRIBUTOR
    Posted Nov 26, 2019 09:55 AM
    If you're interested, we just completed a similar project - automated ACH/checks in file to bank.  It's very possible to get the full address information.  I can give you the SQL scripts we use (check and ACH are different due to bank requirements) if you're interested.  These are SQL scripts and we use a little Excel workbook with a couple of buttons to make it easy for our accountants to verify the outgoing information.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise ID
    ------------------------------

    Original Message


If you've found this thread useful, dive deeper into User Group community content by role