Line Item Discount by Percentage for Quotes

(1) Share

Report

Posted on by Patrian

It seems the default for discounting in quotes is fixed dollar amount versus percent discount... I really don't understand this as Microsoft is trying to compete with SF.com and the others who all allow percent discount by line by default. When we resell products, it is all based on discount percentages... not dollar amounts... I am not even sure what kind of business would work that way but certainly not integrators, VARS, and resellers. Worse... it doesn't seem there is an easy way to fix this. Any ideas?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

jlattimer 24,562 on at

Like (1)

Report
Here is an idea (it make need a little effort to make it fully work) - *Note this won't work with the editable product grid functionality

On your line item records, create a new decimal field (allows 0 -100) for the line's discount percent.

Add it to the form, make the existing Manual Discount field read-only but keep it on the form.

Add some JavaScript on the OnChange event of the new Discount Percent field to figure discount amount automatically and place the result in the manual discount field. Once the record it saved the built in calculations should still work as expected.

JavaScript would be similar to this:

function DiscountPercent_OnChange() { var discPer = Xrm.Page.getAttribute("new_discountpercent").getValue(); if (discPer === null || discPer === undefined) { Xrm.Page.getAttribute("manualdiscountamount").setValue(0); } else { var manDisc = (Xrm.Page.getAttribute("priceperunit").getValue() * Xrm.Page.getAttribute("quantity").getValue()) * (discPer / 100); Xrm.Page.getAttribute("manualdiscountamount").setValue(manDisc); } Xrm.Page.getAttribute("manualdiscountamount").setSubmitMode("always"); }

Was this reply helpful? Yes No
Zazen 185 on at

Like (0)

Report

Works like a treat ...thanks. Shame about the product grid functionality

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is great, thank you!

Was this reply helpful? Yes No
Fasil Muhammed 55 on at

Like (0)

Report

Can you please help on below error for the same subject

@192.168.0.11:5555/.../ClientApiWrapper.aspx line 157 > eval:1:1
RunHandlerInternal@192.168.0.11:5555/.../ClientApiWrapper.aspx
RunHandlers@192.168.0.11:5555/.../ClientApiWrapper.aspx
OnScriptTagLoaded@192.168.0.11:5555/.../ClientApiWrapper.aspx
AppendScriptTag/scriptTag.onload/<@192.168.0.11:5555/.../ClientApiWrapper.aspx

Was this reply helpful? Yes No
Ayadh Shakoor 5 on at

Like (0)

Report

Hi Jason,

which library do we need to add first before adding OnChange event?

Thanks,

Ayadh

Was this reply helpful? Yes No