sales order unlock price update from Plugin

(0) Share

Report

Posted on by Samantha73

3,255

Hi All

When a sales order is created from a quote , on the salesorder entity ispricelocked field set to true preventing updating lines. Can we create a plugin that trigger on salesorderdetail update message that unlocks header ispricelocked (false) on preoperation? or is there other solution than user manually setting header field on button. the problem is qty update doesnt calculate total and price as entity locked. Use CalculatePrice message and disabled system pricing

Categories:

Microsoft Dynamics CRM

Dynamics 365 Sales

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Muhammad Shahzad Sh... 2,373 Most Valuable Professional on at

Like (0)

Report
Plugin on “SalesOrderDetail” Update (Pre-Operation)
Yes, you can create a plugin registered on the “Update” message of “SalesOrderDetail” (Pre-Operation stage) that:
1. Checks if “IsPriceLocked = true” on the parent “SalesOrder”.
2. Sets “IsPriceLocked = false” on the header if needed.
3. Recalculates pricing (if required) using “CalculatePrice” after unlocking.
public void Execute(IServiceProvider serviceProvider) { var context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext)); var serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory)); var service = serviceFactory.CreateOrganizationService(context.UserId); if (context.InputParameters.Contains("Target") && context.InputParameters["Target"] is Entity target) { var salesOrderDetail = service.Retrieve("salesorderdetail", target.Id, new ColumnSet("salesorderid")); var salesOrderId = salesOrderDetail.GetAttributeValue<EntityReference>("salesorderid"); // Get the Sales Order header var salesOrder = service.Retrieve("salesorder", salesOrderId.Id, new ColumnSet("ispricelocked")); bool isPriceLocked = salesOrder.GetAttributeValue<bool>("ispricelocked"); if (isPriceLocked) { // Unlock the Sales Order Entity updateOrder = new Entity("salesorder", salesOrderId.Id); updateOrder["ispricelocked"] = false; service.Update(updateOrder); // Optionally trigger CalculatePrice if needed // var request = new CalculatePriceRequest() { Target = new EntityReference("salesorder", salesOrderId.Id) }; // service.Execute(request); } } }

Was this reply helpful? Yes No