locked
Report on sales of products RRS feed

  • Question

  • I have CRM 2011 on premise and I am administrator of it. I am told all CUs have been applied

    We currently use opportunities with just an estimated revenue field and no products. I can happily produce all sorts of reports on Est and Actual revenue by any field in the Opportunity using advanced find - or export to excel and pivoting.

    We now want to add products to an opportunity. An opportunity may have several products.

    How do I create a report that includes product sales. I want to run a monthly report that shows how much revenue is generated per product.

    I understand that as a single opportunity has several products I cannot do it using advanced find and adding the product column. But how do I do this? I would like each opportunity to have multiple lines for each product sold


    Trying to stop the swap to Salesforce - but the errors keep a coming

    Tuesday, December 3, 2013 9:34 AM

Answers

All replies

  • Nudging this as I am out of ideas.

    If products are used: how do you report on product sales per month? If I attach products to an opportunity then win it; what report will show products sold and the opportunity they come from.

    This seems so simple but is proving so difficult


    Trying to stop the swap to Salesforce - but the errors keep a coming

    Wednesday, December 4, 2013 3:10 PM
  • I got the answer here: mainly me being an idiot: you can choose the entity in advanced find no matter where you pull up advanced find from. And since the entity you need is Opportunity products and that's not in the UI...

    https://community.dynamics.com/crm/f/117/p/116767/240736.aspx?WT.mc_id=ForumPost#240736


    Trying to stop the swap to Salesforce - but the errors keep a coming

    Wednesday, December 4, 2013 5:58 PM