web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Margin for quotes

(0) ShareShare
ReportReport
Posted on by 565

Hi,
I'd like to know how to get the margin for my sales quotes.
I have created cost price list and sales price list for the same product.

PS: it's not about quote based in work, but just for simple quotes.

Thanks .

*This post is locked for comments

I have the same question (0)
  • David Jennaway Profile Picture
    14,065 on at

    CRM doesn't provide much functionality around costs or margins, so you'll need to create some custom fields, and make some design decisions. One key decision is whether a product has a fixed cost, or whether it can vary (and if so, how). If the product has a fixed cost, then the simplest option is to use the currentcost field on the product.

    Then you'll need to calculate the margin. Unfortunately this is a little harder than it should be, as you can't directly update a quotedetail record via workflow (otherwise you could use a workflow to copy the cost onto the quotedetail record). So, there are 2 main options:

    1. If you only want to display the margin (and not filter or run workflows on it, or put it into a document), then you could create a report that calculates the margin, and you could run the report on one or more quotes
    2. Or, you could perform the calculation through code (client script, plugin or custom workflow activity). I think you'll need code (due to the limitation above re workflows), though you could use calculated or rollup fields for part of this

    I don't think using a price list for the costs will help much, as a quote can only have one associated price list

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans