Finance | Project Operations, Human Resources, ...

creating sales order using d365 fo conector in logic apps???

(0) Share

Report

Posted on by Community Member

can any one please guide me how to create sales orderheader and lines using d365 fo connector in logic apps???

I have the same question (0)

All responses (9)

Answers (0)

Sort by

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

You must first create the header using Sales order header entity and then lines using Sales order lines entity.

Not sure what kind of information do you need. Can you perhaps explain a bit more about your scenario, as well as what you already achieved and where you have difficulties?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,The scenario is when the file is created in one drive , parse json, and then create record in d365F&O

{"customer account":"US-005","Customer name":"Contoso Retail Seattle","Invoice Account":"US-005",
"Currency":"INR","data area id":"USMF","warehouse":"11",
"site":"1","sales order":"002345",
"items":[{
"Item number":"M0007"

}]
}

the above is the format of json wt i hv parsed

and i hv selected entity name sales order header v2 which is already existed

am getting the below error

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Ok, so far your problem doesn't seem to be related to D365FO at all, instead there's something wrong with your JSON.

What is this "c2FsZXM5..." text in your screenshot? Where is it coming from? At least that's not JSON.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I have no idea about it , am new to logic apps, I don't know the exact procedure how to create sales order using d365 fo connector in logic apps just by looking out some content online I had tried.

Could You please help me out with the exact procedure??

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

The "content" field should get the JSON from your previous step. When defining this "Parse JSON" step you are prompted to select how the content is initizalized. Please try to pay attention to that step.

At this point your question concerns only LogicApps. Have you tried searching help in LogicApps documentation and communities? They are the correct place, and you will reach much more LogicApps experts than on this forum.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

can you send me that link

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Well I don't know all those communities but with a quick web search (search term "logic apps community" in case you want to try it :) ) and here's one: social.msdn.microsoft.com/.../home

Then of course here's the official documentation: docs.microsoft.com/.../

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,046 on at

Like (0)

Report
Copy link

Link copied!

see if this helps

community.dynamics.com/.../logic-apps-with-microsoft-dynamics-365-finance-and-operations

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

am trying to do with this scenario

when file is created in onedrive with the json format

-> parse json in logic app designer

-> create sales order in d365fo using their respective connectors and actions

here can u please guide me what will be the json format for adding those fields and what entity to select ??

Was this reply helpful? Yes No