Create SalesOrderDetail in Plugin No Populate Amount

(0) Share

Report

Posted on by Jose Abad

Hi Guys,

If anyone can help me with this, really appreciatte, i write a plugin that create a Sales Order Detail for Order, but whn i created the amount not bring back automatically from Price list, buen when i added manually it does, my code:

  var orderProduct = new Entity
                    {
                        LogicalName = "salesorderdetail"
                    };

                    orderProduct.Attributes.Add("salesorderid", new EntityReference("salesorder", id_pedido));
                    orderProduct.Attributes.Add("productid", new EntityReference(producto.LogicalName, producto.Id));
                    orderProduct.Attributes.Add("quantity", Convert.ToDecimal(1));
                    orderProduct.Attributes.Add("uomid", new EntityReference("uom", producto.GetAttributeValue<EntityReference>("defaultuomid").Id));
                    service.Create(orderProduct);

And no calculate amount and totals, but the product is in the PreceList with amount.

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (2)

Sort by

Suggested answer

Yadnyesh Kuvalekar 4,102 on at

Like (0)

Report
Copy link

Link copied!

Hi Jose,

Add below line in your code to Set Pricing field as Use Default on order detail record.

orderProduct.Attributes.Add("ispriceoverridden",false);

This should resolve your problem.

Kindly tick verify answer if this resolves your query.

Was this reply helpful? Yes No
Jose Abad 40 on at

Like (0)

Report
Copy link

Link copied!
hi Yadnyesh,

Thank you for you response, No the change that you me suggested, not work. my code is:

var orderProduct = new Entity { LogicalName = "salesorderdetail" }; orderProduct.Attributes.Add("salesorderid", new EntityReference("salesorder", id_pedido)); orderProduct.Attributes.Add("productid", new EntityReference(producto.LogicalName, producto.Id)); orderProduct.Attributes.Add("quantity", Convert.ToDecimal(1)); orderProduct.Attributes.Add("uomid", new EntityReference("uom", producto.GetAttributeValue<EntityReference>("defaultuomid").Id)); orderProduct.Attributes.Add("ispriceoverridden", false); service.Create(orderProduct);

The result is the same thing. the amount of product not automatically load.

Was this reply helpful? Yes No
Verified answer

Yadnyesh Kuvalekar 4,102 on at

Like (0)

Report
Copy link

Link copied!

Can you check below setting on your environment?

Go to Settings > Administration > System Settings.

Go to Sales Tab and check value of 'Set Pricing Calculation preference'. It should be yes in your case.

Was this reply helpful? Yes No
Jose Abad 40 on at

Like (0)

Report
Copy link

Link copied!

Thans fro response, Yad

Yes, it does, the setting are ok:

But are face still the same problem..

Was this reply helpful? Yes No
Verified answer

Yadnyesh Kuvalekar 4,102 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the Screenshot. Can you also provide screenshot of the price list item you are selecting in order detail and screenshot of the order detail record created through code?

Also, can you check if 'Select Product (isproductoverridden)' is set to Existing on order detail record. Try adding below line in the code.

orderProduct.Attributes.Add("isproductoverridden", 0);

Was this reply helpful? Yes No
Jose Abad 40 on at

Like (0)

Report
Copy link

Link copied!

Yes, Yad, sure, let me screen the images:

price list element:

Product order detail:

Let me test the code setting in '0' of isproductoverridden for this, and i comment you.

Was this reply helpful? Yes No
Jose Abad 40 on at

Like (0)

Report
Copy link

Link copied!

Yad,

No, the code orderProduct.Attributes.Add("isproductoverridden", 0); doesnt work, because its accept only Bool values.

Was this reply helpful? Yes No
Jose Abad 40 on at

Like (0)

Report
Copy link

Link copied!
Yad,

I think i found the problem:

The Order, that is created by Workflow its state code is blocked or something, an then yo can add product but no has recalculation and other details.

I dont know why the order created "sent" read only, but i test with another Order Open, and the code was right!

If you can tell me how change this "state code" in workflow or moment that happen would be apprecite.

Thnks!!

Was this reply helpful? Yes No
Yadnyesh Kuvalekar 4,102 on at

Like (0)

Report
Copy link

Link copied!

Hi Jose,

I didn't get it. Can you please help me with an example and also the workflow screenshots?

Was this reply helpful? Yes No
Suggested answer

Jose Abad 40 on at

Like (1)

Report
Copy link

Link copied!

Hi Yadnyesh,

My solution was, add the products and later update the record de sales order, and thats it, its work!! thanks for your support

Was this reply helpful? Yes No