Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Line Item Discount by ...
Microsoft Dynamics CRM (Archived)

Line Item Discount by Percentage for Quotes

(1) ShareShare
ReportReport
Posted on by Patrian 57
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

  • Ayadh Shakoor Profile Picture
    Ayadh Shakoor 5 on at
    RE: Line Item Discount by Percentage for Quotes

    Hi Jason,

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

    Thanks,

    Ayadh

  • Fasil Muhammed Profile Picture
    Fasil Muhammed 55 on at
    RE: Line Item Discount by Percentage for Quotes

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Line Item Discount by Percentage for Quotes

    This is great, thank you!

  • Zazen Profile Picture
    Zazen 185 on at
    RE: Line Item Discount by Percentage for Quotes

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

  • Suggested answer
    jlattimer Profile Picture
    jlattimer 24,558 on at
    RE: Line Item Discount by Percentage for Quotes

    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");
}

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans