Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Export Vendor Payment ...
Finance | Project Operations, Human Resources, ...
Answered

Export Vendor Payment file to SFTP

(1) ShareShare
ReportReport
Posted on by Community member
Hi all
 
Is it possible to automate the export of Vendor Payments file from D365 Finance SAAS to a local SFTP? 
 
I would like to have this action be automated once a user presses on Generate Payment from Vendor Payment journal window. 
 
Has anyone managed to export either the vendor payment file, or any other file, to an SFTP location? 
 
Many thanks 
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 12,189 Super User 2024 Season 2 on at
    Export Vendor Payment file to SFTP
    Hi Naweed,
    There is not a standard function in D365FO for sending payment file directly from D365FO to SFTP. In order to send file into SFTP you need to create a automatic for this sending and this can be done by several approaches like:
    - Using logic apps
    - Creating customization in D365FO to send file SFTP from Electronic reporting jobs
    - Archive the payment file in SharePoint and then create an automate to send files from SharePoint to SFTP + Evaluating to use PowerAutomate 
  • bankk Profile Picture
    bankk 6,603 on at
    Export Vendor Payment file to SFTP
    I'm looking for a similar solution without ER.
     
    @Kevin Xia
    I'm not clear on how your recommendations would work in this instance. Can you describe further?
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Export Vendor Payment file to SFTP
    Hi,
    I found these two old threads for you: Automate excel Import/export to /from SFTP server (dynamics.com), Send text file to SFTP location from D365 (dynamics.com). Both of them mention two methods, one is to create a Logic App that will use a data management API to export data to a file and then it'll push this file to the SFTP server; the other is code customization, it describes that how to transfer some payment files to SFTP location using customized code in dynamics 365 finance & operation. The reference link is below: axmriganka.wordpress.com.
    Best regards,
    Kevin

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans