Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Total amount Breakdown by products

Posted on by

Hi everyone!!!

I am working in company that has two family of products. For the same opportunity, the company sells the products interchangeably. But they want to view the total amount for each family. See the example

Product unit Price per unit Total line
Product 1 (family 1) 4 50 200
Product 2 (family 2) 5 25 125
Product 3 (family 1) 8 40 320
Product 4 (family 2) 9 45 405
Total family 1 520
Total family 2 530
Total Amount 1050

Does anyone have an idea?

*This post is locked for comments

  • JMdeSingular Profile Picture
    JMdeSingular on at
    RE: Total amount Breakdown by products

    Thank you very much for yours answer. I will try the solution of Aileen

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,522 on at
    RE: Total amount Breakdown by products

    Hi Jose,

    CRM does not provide the total amount each product family.

    If you really want you either create new custom entity with field product family name and total amount or you can just use custom report, so that you can always get new value.

    Hope this helps.

    Thanks.

  • Suggested answer
    anilambadan Profile Picture
    anilambadan 1,160 on at
    RE: Total amount Breakdown by products

    Hi

    Please try to create custom attributes for each family total on opportunity and try to write a plugin on opportunity line item level(create/update/delete) and update total fields on the opportunity.

    thanks

    Anil

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans