web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Read CSV File From FTP, Import Data, Automate Post Journals

(0) ShareShare
ReportReport
Posted on by 1,214

Hi,

we have a requirement where customer wants to integrates data between their existing DMS and D365 F&O. The data flow cycle will be as following:

1. Data from DMS exported to FTP server as CSV files.

2. D365 read the CSV files from FTP server and import the data using data entities.

3. Journals like PO Product Receipt, PO Invoice, SO Packing Slip, SO Invoice will be automatically posted once the data import completed.

4. Export the posted journals to FTP server as CSV files.

This whole cycle need to run in schedule every day. Every step also need to run in sequence, automatically.

Does these requirements make sense?

How generally do we achieve this?

Is it possible to make sure data import finished successfully first before running the codes to post those SO & PO journals?

Thank you.

I have the same question (0)
  • WillWU Profile Picture
    22,361 on at

    Hi HAIRUL HAZRI ,

    You could use Logic Apps to achieve your goal. It contains connectors for D365FO and ftp.

    docs.microsoft.com/.../connectors-create-api-ftp

    Check this blog: www.linkedin.com/.../file-based-integration-dynamics-365-finance-operation-nitish-dikshit

  • HAIRUL HAZRI Profile Picture
    1,214 on at

    Thank you Will for the insight.

    While that should solve the read file and import part, how do I trigger my posting jobs once the import is complete?

    Let's say I write X++ job in D365. This job will find new sales orders for example, and perform invoice postings on them.

    Is it possible to expose this X++ job to Logic Apps or Power Automate flow and run it from there?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans