” Business Central : Convert Sales Quote to Sales order using Power Platform”

13 January 2023

” Business Central : Convert Sales Quote to Sales order using Power Platform”

Hello Readers,

Hope You Are Doing Well and Safe!

So, Today We Will Discuss How to Convert Sales Quotes to Sales Order Using Power Automate.

For This, we need to create an API page. And add some fields to that API page.

And we need to use some properties like APIGroup, APIPublisher, and APIVersion because these properties are used in power automate.

So, Let’s create an API page.

We are converting Sales quotes to Sales Orders. So, add the sales header as a Source Table.

We are adding this attribute to this page. [ServiceEnabled]

Now to convert quote to order we need to create one procedure. And in this procedure, We are using one code unit which is “Sales-Quote to Order”. So, Create one variable for that code unit. And add one more variable with the type WebServiceActionContext.

We need some properties from the Web service Action Context. Which are Set Object Type, Set Object Id, Set Result Code & Add Entity Key. So, Set these properties according to your requirement.

Now, publish your extension and open sales quotes, and check how many records are there.

as you can see, we have two records here on the sales quotes page. With quote no. 1004 & 1005.

Now, open power automates. Click on my flow. We are creating a new flow for converting quotes to orders. So, click on the new flow. And then select instant cloud flow from the given options. As you can see below image.

Now you get a new page. This page is for how to trigger this flow. So, select manually trigger flow from the given options. You can select a different flow as per your requirement. And then click on create. As per the below image.

When we click on create button, our flow is created, and you get a new page like this.

click on the new step to add another step to this flow. As per the below image.

you can also see our selected type to trigger our flow.

Now you get a few options here for doing the operation. So, search for business central. You can get two options for business central. The first is for the cloud and the second one is for on-premises. we are using the cloud version. So, select the first one.

You can use the on-premises version also if you have reequipment for that.

Now you get a few options for actions and Currently, we need action. So, we are selecting run action(V3) from the given actions. You can also select different actions or triggers according to your requirement.

Now you get a new page to add some details. Like…

Environment name,
Company name,
API category,
Action name,
Document Type,
No.

So, add datils to that page and click on the save button.

As you can see below’s image.

When you click on save, your action was saved, and you get a notification about it. Now it’s time to test our flow. So, click on test As you can see below’s image.

After clicking on test action, we get a new page with options for how to test flow. There are two options here first manually, and second Select the first option which is manually. As you can see below image.

You can also select automatically.

After selecting options. Click on the test button to test our flow.

When you click on test, the system checks our environment datils. And if all datils are matched with your given datils. The system sets your flow and shows a green check. It means we are ready to go. Select continue batten.