Open Forum

Expand all | Collapse all

Safepay Automation

  • 1.  Safepay Automation

    Posted Oct 23, 2019 08:46 AM
    Hello,

    We have a requirement to automate the Safepay process.  I've read a few old posts on how to do this but was wondering if there are any new ways of doing this.  Here's what I've setup so far.

    I use Windows Task Scheduler to kick off a batch file at a specific time of day.  The Batch file opens GP and starts a GP macro.  The macro logs into GP then navigates to the Safepay window and enters in the necessary parameters and click the Load Transaction button.  The macro then closes GP.

    Couple of bugs with this:
     1.  Macro fails if there are no check runs for that day which means that GP stays open all night long.
     2.  Users name and password are now saved in the GP Macro file leaving a security risk.
     3.  I need to figure out a way to loop this to run for more than one Bank ID.
     4.  Safepay doesn't use any sort of timestamps in the file naming convention.  If the process needs to be run more than once a day the file will be overwritten.

    For the first bug, I could possibly have another Batch file that force closes GP after the first batch finishes.
    For the looping process I could have separate Batches and GP Macros to run successively for each Bank ID.

    So, my question is this:  Is there a more elegant solution?  We're on GP 2016 and it seems like all the posts on automating SafePay is older.



    ------------------------------
    Brenda Rogers
    Financial Systems Business Applications Analyst
    Falls of Neuse Management, LLC
    Raleigh NC
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Safepay Automation

    GPUG ALL STAR
    Posted Oct 23, 2019 04:51 PM
    Hi @Brenda Rogers

    Can you let us know why you need a Macro to run these?  Seems like this is something that should be kicked off and monitored by a user.

    If it needs to run behind the scenes you could use the ME123504 table AFTER the upload has run for an excel refreshable that could then be saved as a tab or comma delimited file.

    Let us know more about the requirements and we may be able to help with a more elegant solution.​

    ------------------------------

    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Safepay Automation

    Posted Oct 24, 2019 09:06 AM

    Thank you for responding Jo.  Our Payables Dept has requested this automation.  The process used to be run manually by someone in our Banking Dept.  We weren't using SafePay and the user was running an SSRS report to upload to the Bank.  When we implemented SafePay, the process was moved to the AP department.  The requirement is to setup a process to automatically generate the SafePay file at 4PM on weekdays, then transmit it to the bank.   We setup a process using Boomi to grab the SafePay file from a shared directory and securely transmit it to our banks recently which works great.  We would like to take it a step further by automating the file generation.  For us, it seems to make sense that if check runs are done during the day that you want to ensure that the Positive Pay file is transmitted in a timely fashion.  Eliminating the need for a person to login and generate the file reduces the risk of that not happening.



    ------------------------------
    Brenda Rogers
    Financial Systems Business Applications Analyst
    Falls of Neuse Management, LLC
    Raleigh NC
    ------------------------------

    Academy - Online Interactive Learning from Experts


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