A colleague wants a list of all products in his area and their prices. I can list the products but cannot seem to create a report that includes the prices listed / the price book. Is there no Price book product report or a way I can say

Product A is listed for price $, £, Euro and is active.

Really do not even know where to start with coding so looking for an easy way out if possible? enter image description here

2 Answers 2


Some reports were hidden - See below image to resolve. Tick "Select Report Types to Hide" - If there is an X next to the report it is hidden, click it to show and then have access to the report.

Hidden Report Types


Go to Reports > Create New Report > Price Books, Products and Assets, Price Book with Products. From there, you can see the Product, its cost per currency, and the Price Book it's in.

  • I thought that would be the case as well, I do not have the Price book with products report on my list... -- Added a screen shot above Sep 1, 2016 at 7:32
  • @PaulRogers That's interesting. Are you a system administrator? There may be certain permissions you're lacking. I've never thought too hard about this, because I'm usually the admin wherever I am (comes with being popular, I guess?), but I'd imagine you have to have something like Manage Price Books or perhaps Modify All Data. Unlike most other features in salesforce, it's never quite clear which permissions you need to run a specific report. If you're not an admin, try asking your friendly admin for a report. Other than that, you might need to contact support.
    – sfdcfox
    Sep 1, 2016 at 7:37
  • Hey, Figured it out - some one had hidden the report type - i've just taken over as a Salesforce Admin for a company - Previous to me they had another admin who was self taught and worked here for 8 years but left without giving a hand over so things are all over the show. Thanks for your advice. Very impressed with your profile as well - 11 Years !! High 5 my man. Sep 1, 2016 at 7:39
  • @PaulRogers It's a great platform, constantly evolving, and always a new challenge. It's been the most enjoyable decade of my life so far, and definitely rewarding. Hopefully, you'll feel the same way. I wouldn't trade the last decade of what I've done for anything.
    – sfdcfox
    Sep 1, 2016 at 7:44
  • Love to hear your passion - I was introduced to Salesforce about 2 years ago as a user in a customer service team - Absolutely fell in love with how open and customizable it is and now just about to sit my ADM201 exam. -- Side question for you if you dont mind - Can I add the Product ID to the products with pricebook report? Kind of a pointless report if I cannot mass change with the data loader. Sep 1, 2016 at 7:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .