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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Sales order creation t...
Finance | Project Operations, Human Resources, ...
Suggested answer

Sales order creation through Logic apps in D365FO

(0) ShareShare
ReportReport
Posted on by CU05031448-0 1,133
Dear team,
 
I need some basic idea before implementing the same...
 
As I need to create a Sales order in D365FO through Logic app.
 
So, I think we need entities SalesOrderHeaderV2 entity and SalesOrderLineV2 entity for this requirement.
 
The third party application going to send us the file in JSON below format like 
 
For example -
 
Header -
Sales Id- 'ES0001'
Customer account etc...
 
Lines -
Item id - 'I001'
Qty - 10 etc...
 
Header -
Sales Id- 'ES0002'
Customer account etc...
 
Lines -
Item id - 'I002'
Qty - 10 etc...
 
So on ...
 
***My question is pls guide me the below things
 
1. How will I call the entities SalesOrderHeaderV2 entity and SalesOrderLineV2 entity in Logic app. I am looking for the trigger.
 
2. How will I loop to create header+line in D365FO for each combination from Logic app.
 
3. If suppose any records failed to import in D365FO for any reason, is it skiped automatically and go to the next record?
 
4. Can I get the logs in Execution history?
 
Kindly advise me pointwise pls.
 
I will implement the same accordingly.
 
Thanks in advance 
 
 
 
 
Categories:
Dynamics 365 Finance
I have the same question (0)
  • Suggested answer
    Sagar121 Profile Picture
    Sagar121 712 on at
    Sales order creation through Logic apps in D365FO
    1. How do I call the entities SalesOrderHeaderV2 and SalesOrderLineV2 in a Logic App?
    You can use the Finance and Operations connector in Logic Apps. Simply type 'Fin&'  and you will see all triggers(Only business event) and actions related to F&O.
    To create records you can use create record F&O connector.
    2. How do I loop to create header and line in D365FO for each combination from Logic App?
    It depends on the input( One SO or multiple SO) You will need to know exact format.( For this learn about Object and Arrays) in LA. 
    3. If any records fail to import in D365FO for any reason, are they skipped automatically and does it move to the next record?
    Yes assume you have 5 lines in SO. If line2 fails it will get skip and LA will run for others. For better error handling, you can write custom logic in the data entity. behind the screen data entity code runs when you use LA connectors for F&O
    4. Can I get the logs in Execution History?
    Yes. Logic Apps provides Execution History where you can view details of each run. In LA you will need to use Scope learn about this topic as in LA you don't have direct try and catch.
     
  • CU05031448-0 Profile Picture
    CU05031448-0 1,133 on at
    Sales order creation through Logic apps in D365FO
    Thanks Sagar for the response.
     
    2. As you said 'It depends on the input( One SO or multiple SO) You will need to know exact format.( For this learn about Object and Arrays) in LA. '
     
    Actually as per our discussion, they going to send TEN SO per day. 
    So, please let me know where I can store it? Kindly tell me the best approach.
    As I need to do Recurrence integration. So, it will pick automatically JSON file from there.
     
    Kindly let me know the best approach pls.
     
    You mentioned 'LA'. What is LA?
     
    3. As you suggested me to write the custom Logic in Data Entity. Pls let me know which method is good to write the logic 
     
    How the method will called in Logic app?
     
    Kindly elaborate pls.
     
    Thanks in advance.
     
     

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 588 Most Valuable Professional

#3
Sumit Singh Profile Picture

Sumit Singh 544

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans