Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Automating the Positiv...
Microsoft Dynamics GP (Archived)

Automating the Positive Pay Process

(0) ShareShare
ReportReport
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

  • Community Member Profile Picture
    Community Member on at
    RE: Automating the Positive Pay Process

    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

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Automating the Positive Pay Process

    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

  • Suggested answer
    Mike Bufano Profile Picture
    Mike Bufano 1,482 on at
    RE: Automating the Positive Pay Process

    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.

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,006 User Group Leader on at
    RE: Automating the Positive Pay Process

    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

  • Verified answer
    26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: Automating the Positive Pay Process

    Hello AviatorAlex:

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

    Here are the steps required

    1.  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.
    2.  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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans