Sage 100

 View Only
Expand all | Collapse all

Sage Direct Deposit - has anyone created a script

Jim Woodhead

Jim Woodhead12-30-2013 08:35

Jim Woodhead

Jim Woodhead12-30-2013 08:54

  • 1.  Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 07:01
    Sage Direct Deposit - has anyone created a script that would take the DirectDeposit.ACH file and automatically send it to the bank's sftp site? Key Bank is required our client to set this up. A nice end of year surprise for a Jan 2014 Go Live...


  • 2.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 07:21
    Can they not copy and paste the file to the ftp site? I've seen scripts that backup and/or move a file - could you dump the file to a local location on the server (standard DD) and then have an external script that just moves the file? And if you can't do that due to security issues I'm just wondering how a script will get around those same issues.


  • 3.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 07:32
    Somewhat similar concern to Eric regarding security being an issue. Not sure if bank sites let you use keystroke simulators/scripting to login. Don't know but would be concerned about that particular area.


  • 4.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 07:36
    They have this process already in place with Real World (which we are replacing).


  • 5.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 07:38
    Eric, they CAN copy and paste into a secure site but the bank has asked them to NOT do it that way, they want the process to remain the same as they have in place now.


  • 6.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 07:44
    You could probably set up a script that fires off and moves the file immediately after they generate the DD file, or schedule an external script that does the same thing using windows scheduler. I'm not a scripting guru but I believe the copy/paste script is relatively simple - not sure if you have a partner you use for scripting or do it internally, but if you'd like some assistance I can see what type of availability our programmers have. The other option, changing the DD program to place it directly into the ftp site seems like a bigger job.


  • 7.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 07:46
    Looking for a partner that can help with this. We need to rename the file before moving, as well.


  • 8.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 07:53
    I'll check with my team - just realizing that with it being the payroll module (non-BusFramework) having the script fire off automatically from inside of Sage is probably not going to happen without custom programming, so you're probably looking at an external script that moves the file (either manually fired or with windows scheduler).


  • 9.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 07:58
    Did you check out this thread? https://90minds-com.socialcast.com/messages/15743632


  • 10.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 08:35
    You can use coreftp and script it to send.


  • 11.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 08:42
    Thanks Jim, that would resolve the sending piece, I still need to have a script written to rename the file and then move it after it is sent...so still looking for a partner on this.


  • 12.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 08:48
    I have a script that runs VI imports, renames the source files, and moves them to another location. You will need to modify it but it runs with Windows Task Scheduler. Happy to share.


  • 13.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 08:54
    I'll upload my script later today too


  • 14.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 08:57
    Also, I'm pretty sure this could all be done with KnowledgeSync. It can also send notices of it's completion, and reminders that it is coming up.


  • 15.  RE: Sage Direct Deposit - has anyone created a script

    Posted 12-30-2013 11:26
      |   view attached
    Here is my script I wrote... Note I use Visual Cut to create the file. @echo off Rem this routine copy the export files together, clean up of files rem a batch file call je_ftp runs every hour to transfer the file to the ftp site along with the latest validation file REM you can add a move command if necessary to setup the output.csv file REM SET LABEL REM new file copy with date and time yymmdd_hhmmss REM where yymmdd_hhmmss is a date_time stamp like 030902_134200 set hh=%time:~0,2% REM Since there is no leading zero for times before 10 am, have to put in REM a zero when this is run before 10 am. if ""%time:~0,1%""=="" "" set hh=0%hh:~1,1% set yymmdd_hhmmss=%date:~12,2%%date:~4,2%%date:~7,2%%hh%%time:~3,2%%time:~6,2% set mmddyyyy=%date:~4,2%%date:~7,2%%date:~10,4% set datetime=_%yymmdd_hhmmss% REM Blackline file to create current Validation table and to transfer the JE files Rem Validation creation with Visual cut ""C:\Program Files\Visual CUT 11\Visual CUT.exe"" -e ""\\appserver2003\Blackline\Reports\validation_file.rpt"" copy \\appserver2003\blackline\validation\*.txt /a \\appserver2003\blackline\validation\validation_%datetime% /b /y REM FTP transfer suspensesd. ""C:\Program Files\coreftp\coreftp.exe"" -O -site blackline -u \\appserver2003\blackline\validation\validation_%datetime% -p \prod\ -log v:\Blackline\log.log del /q \\appserver2003\blackline\validation\Validation*.* Rem Journal transfer ""C:\Program Files\coreftp\coreftp.exe"" -O -site blackline -u \\appserver2003\blackline\je\je_imported\journalstatus*. -p \prod\ -log v:\Blackline\log.log move \\appserver2003\blackline\je\je_imported\journalstatus*. \\appserver2003\blackline\je\je_processed\

    Attachment(s)

    zip
    File_upload_script.zip   875 B 1 version