Everyone knows it, if you want to quickly jump from the sales order in Dynamics 365 Sales to the sales order in Dynamics 365 Supply Chain Management, you need quite a few clicks.
With the following small low code / now code development we manage this in one click.
For this we use the link to the data set generated in Dynamics 365 Supply Chain Management.
To implement this, the following steps must be performed.
New field in Dataverse
First, we need an appropriate field in Dynamics 365 Sales where we can store the link from Dynamics 365 Supply Chain Management.
To do this, we create a new field of type “URL” in Dataverse in the table “Order”.
It is important to note that the maximum number of allowed characters must be increased, since the link consists of over 1000 characters.
Next, we need to make the field visible on the form so that we can use the link.
To do this, we change the corresponding form in the “Order” table and insert the URL field there and set it to “Read only” in the properties.
Alert rule in Dynamics 365 Supply Chain Management
Now, to populate this field, we create a warning rule on the Sales Order in Dynamics 365 Supply Chain Management that responds whenever a new sales order is created.
This warning rule is passed externally via the business events to Power Automaten, where we then set the appropriate steps to provide the dataset in the dataverse (=CE) with the FO link.
Create workflow
Now comes the final step, we create a workflow in Power Automate that updates the URL field on the Sales Order record in Dynamics 365 Sales whenever a new sales order is created.
For this purpose we use the automatic trigger “When an event occurs” of the connector “Dynamics 365 Fin & Ops” .
This workflow now responds to the business event “When an alert rule is triggered” and starts the workflow.
The next step is to make the content from the trigger more “readable” by converting the content into a JSON format.
Now we can use the data to perform the last step in Dataverse. To do this, we first search for the corresponding record in Dataverse, since we need the Dataverse Unique Id for the update step.
D To do this, we filter out from the Order table the records that have corresponding order number passed by the warning rule as “Key 1”.
Thus, we have the appropriate information to now update the “FO LINK” field on the record.
It is important to note here that “&pageType=Details&prt=initital” is appended to the end of the URL so that the detail view also opens.
That’s it now, we just need to make sure that the Changed based Alerts job in Dynamics 365 Supply Chain Management runs regularly. During testing, we set the job to run every minute.
Hope this helps you.
P.S.:
This is only exemplary and was tested in a test environment. For productive use, please revise and test accordingly.
Any damage is not taken from, as here is explicitly pointed out a possible solution idea.
