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

Announcements

No record found.

News and Announcements icon
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans