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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Cost price
Microsoft Dynamics CRM (Archived)

Cost price

(0) ShareShare
ReportReport
Posted on by Neeraj523

I am trying to implement cost price to calculate profitability on products sold. Is there any inbuilt functionality available for this.

I have multiple products and priced differently under various rice list belongs to various geographies. So i believe the best way to implement cost price is on Pricelistitem entity. I want it to be added as currency price or percentage or both.

*This post is locked for comments

I have the same question (0)
  • MSCRM Guru Profile Picture
    MSCRM Guru 600 on at

    Hi Neeraj,

    There is no built-in capability to calculate the cost price, and you will find the Price List and Price List Item aren't as extendable as most out-of-the-box entities.  It is possible to use different "Cost" Price List for different geographical location and use the Price List functionality for discounts from standard price.

    How will you need to use this data?  If you need it as reference for analysis in reports that might be enough, if you need it for anything smarter you will likely need to extend the CRM functionality.

    Good luck!

  • Neeraj523 Profile Picture
    Neeraj523 on at

    Sorry for the late response.

    Thank you for your response. I  need cost price just to calculate the operating profitability. No other purpose involved. I want to understand the inbuilt concept of List Price and Standard Cost in Dynamics 365. Is it not related to cost and selling price?

  • MSCRM Guru Profile Picture
    MSCRM Guru 600 on at

    Out of the box you can track the Product Cost as a single currency field.  You can't have the cost price calculated based on different parameters dynamically.

    List Prices allowed you to sell your products based on different criteria - for example a 20% markup of price in the USA.  There are a few ways you can use price lists to configure pricing.  You can get more details here: missdynamicscrm.blogspot.com.au/.../pricing-method-in-microsoft-dynamics-crm-product-catalog.html

    You could potentially set up pre-known Cost price lists for different geographical areas and compare to those in custom reports or screens.

    Good luck!

  • Neeraj523 Profile Picture
    Neeraj523 on at

    Is it a standard way if i add a custom entity with 1:1 relationship with pricelist products to capture product cost for each line item in pricelistproducts. Later, i can use this entity to present required reports.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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