Automating the Positive Pay Process

(0) Share

Report

Posted on by Community Member

Hello,

This is actually my first post on this forum. I have an inquiry about the positive pay file that is created in Dynamics GP. We have been manually creating this form and manually sending it to the bank through their website.

I have begun working with the bank to use an SFTP to send over these files automatically so we won't have to manually do it. I wanted to see if it is possible to make the file generation process within GP could be automated as well. The goal I am looking to achieve is to have the positive pay file automatically generated and automatically sent over to the bank.

Is it possible to have the positive pay file generation process in Dynamics GP on an automatic timer?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

26P2ER 1,775 on at

Like (1)

Report
Hello AviatorAlex:

I was able to automate a solution to a similar requirement, recently.

Here are the steps required

Reporting Services report in the bank prescribed format. By adding a subscription you can send the report to a shared folder on your network at a preset time of the day.

Build a console app to automate SFTP upload task. I used a third party solution named WinSCP. This is free and comes with easy to use c# code snippet (you literally can copy the code while testing the SFTP manually). A windows scheduler task can execute this SFTP upload task at a preset time of the day for you.

I will be glad to answer any questions offline.

Best of luck

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

AviatorAlex,

We have automate this for one of our client, so if you are interested in similar solution lets talk further at almas@evinciblesolutions.com

Was this reply helpful? Yes No
Suggested answer

Mike Bufano 1,484 on at

Like (0)

Report

KTL safepay is a product available for purchase.

https://www.ktlsolutions.com/wp-content/uploads/2017/06/Product-Packet_pricing.pdf

Works with FTP or SFTP. Completely automated.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

HI Alex,

I concur with Ven.. this is a 2-steps process.. First find a way to generate/automate the EFT file in GP. SSRS is actually an interesting approach.

Definitely the 2nd step requires some creativity, nothing that is not doable, but WinSCP would be my 1st choice too and to automate the whole process you can download the free System Scheduler for Windows from SplinterWare.. we use it to automate some scheduled unattended tasks for GP

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

26P2ER, I was able to use a console app to automate the SFTP upload task. I was also able to use the communication link in Dynamics GP to trigger the console app when the Pos Pay file is generated.

I'm still working on adding a subscription to send the report to a shared folder on my network.

Thanks for the info,

Alex

Was this reply helpful? Yes No