Blog

If you would like to know how to create a custom report for Price Book entries, we have broken down the steps for you in this article. Creating a custom report for Price Book entries makes product pricing easier to update and manage.

Product and pricing management is one of the top priorities of PuppyCat Global Inc., a rising superstar in the manufacturing industry of organic pet essentials. The sales managers typically create separate custom price books for each Account with opportunities.

In order to effectively close the deals, a comprehensive view of their price book entry data is vital. It will allow the managers to monitor the product list prices from a single panorama. As of Salesforce's Summer ‘20 release, it is now possible to create a custom report for Price Book entries, which makes it easier and more efficient to manage and update product pricing.

Create a Custom Report Type: Price Book Entry

At PuppyCat, a report is created for each sales manager, which gives them an overview of the price book entries from the custom price books related to the opportunities owned by their respective team members. Price book entry data can be obtained and displayed in a report by creating a custom report type. ‘Price Book Entries’ can be used as the primary object. For custom report types that have ‘product’ as the primary object, it can be added as the secondary object instead.

A custom report type can be created by navigating to Setup | Report Types. In the example below, ‘Price Book Entries’ is used as the primary object. Make sure that the report type will be stored in the appropriate category.

Deployment Status

  • Select ‘In Development’ status during creation and testing as well as editing. When in this status, the report type and its reports are hidden from all users except those with the ‘Manage Custom Report Types’ permission. Only users with this permission can create and run reports using report types in development.
  • Select ‘Deployed’ when it is ready to be accessed by all users.

Selecting the Price Book Entries object as the primary object in the report type will allow users to fetch all price book entry data in a report.

While it can be used as the secondary object, either to Price Book or Product, the Price Book Entries object does not have further relatable objects when it is set as the primary object (as shown in the screenshot below). After saving the second and last step, the custom report type is ready for use.

This screenshot shows the records set that will be returned in the results of the report that utilizes this report type.

New Report: Choose Report Type

The first step when creating a report is choosing the correct report type. The report type naming will matter during report creation. Make sure that you have named the report type in a way that will be easily distinguished.

From the previous section, we created a custom report type called ‘All Price Book Entries’. This report type must be selected when creating the Price Book Entry report.

In this example, report rows are grouped per Price Book Name. This way, the products are listed according to the price book they belong to. The sales manager would be able to view the list prices and determine which one needs an update.

This example report displays the products and their list prices grouped by Price Book Name.

This screenshot shows the available fields and filter options for the Price Book Entries report type.

As simple as that! For the last part of the Reports & Dashboards series, we will give you the remaining features that were brought to us by the Summer ‘20 release. Do you want us to feature a specific topic from the coming Winter ‘21 release? Drop a comment below and we will make sure to not miss it!

What Certification are you studying for now?

Focus on Force currently provide practice exams and study guides for nine certifications

Reports and Dashboard Part 3: Manage Product Pricing with a Custom Report

If you would like to know how to create a custom report for Price Book entries, we have broken down the steps for you in this article. Creating a custom report for Price Book entries makes product pricing easier to update and manage.Product and pricing management is one of the top priorities of PuppyCat Global Inc., a rising superstar in the manufacturing industry of organic pet essentials. The sales managers… Read More

Reports and Dashboard Part 3: Manage Product Pricing with a Custom Report

Focus on People: Elkin Cordoba – Turning Dreams into Reality

Elkin Cordoba was looking for a job where he can be creative. Since he has always found computer automation fascinating, a career in the software industry made perfect sense. His journey with Salesforce began when a cloud computing company hired him and now he has evolved from writing code to becoming a Salesforce Consultant handling complex technical and business issues. My name is Elkin Cordoba, and I’m a consultant, specifically… Read More

Focus on People: Elkin Cordoba – Turning Dreams into Reality

Reports and Dashboard Series: Attach CSV Files to Report Subscriptions

As promised, we will be highlighting feature updates and releases related to Reports and Dashboards through a blog series. For the second part of our installment, we discuss the ‘Attach .csv Files Report Subscription’ functionality.This feature release is pretty straightforward: reports can now be generated more efficiently via email without the hassle of printing each page, thus making the reporting process more digital and seamless. Sounds modern and techie, isn’t… Read More

Reports and Dashboard Series: Attach CSV Files to Report Subscriptions

Focus on People: David Scullion – Practice and Perseverance, Secrets to Passing Exams Every Time

David Scullion worked in an accounting software company when his boss encouraged him to learn Salesforce, as a way to productively pass the time. However, what David found was a platform that will change his career for the better. It’s been 10 years and he hasn’t looked back since.A decade into his journey with Salesforce, David managed to obtain several certifications and is working towards acquiring more. In his experience,… Read More

Focus on People: David Scullion – Practice and Perseverance, Secrets to Passing Exams Every Time

Focus on People: Yash Arora – Solidifying Salesforce Experience through Certification

Yash is a Sales Operations Manager who has optimized crucial organizational processes using Salesforce. In his pursuit to be a certified Salesforce Admin, he learned that his Salesforce experience is already an edge, and studying for the exam unraveled further Salesforce knowledge that strengthens his current expertise. In this article, he also shared stories of his industry tenure, study habits for the certification, and his future career goals. I am… Read More

Focus on People: Yash Arora – Solidifying Salesforce Experience through Certification

The Reports and Dashboards Series: Filtering Knowledge Reports by Category

The long wait is finally over. The Salesforce Summer ’20 feature releases and updates are now implemented! To give you insights on how those new features work, we will be featuring the recent updates related to Reports and Dashboards in this blog series. Do you think one of your upvoted ideas made the cut? Here’s an overview of some of the Summer ’20 report update features: ​REPORTS & DASHBOARDS ​Filter… Read More

The Reports and Dashboards Series: Filtering Knowledge Reports by Category

How to become a highly paid Salesforce Freelancer and Independent Consultant

*Disclosure: We only recommend products and services we would use and all opinions expressed here are our own. This post may contain affiliate links that at no additional cost to you, if you make a purchase we may earn a commission.Have you ever considered becoming a Salesforce Freelancer and using your skills to create a flexible highly paid income that allows you to work from anywhere in the world?Bradley Rice… Read More

How to become a highly paid Salesforce Freelancer and Independent Consultant

Focus on People: Cary Walkin – Making the Impossible Possible

​As an accountant, Cary primarily uses Excel. After taking a new role as a Financial Systems Manager, he was introduced to Salesforce to do the job more efficiently. This pushed him to take Salesforce certifications, making him an in-house expert of the platform. He also shared here his preparations for the exam, the challenges while learning the platform, and how he leveraged his certifications to establish stronger process alignments across… Read More

Focus on People: Cary Walkin – Making the Impossible Possible

Batch Apex in Salesforce

There are a lot of declarative automation tools and features introduced by Salesforce in the recent past, which has considerably reduced the need for Apex code. But, to process a large number of records, developers still use the humble Batch Apex.What is Batch Apex?Batch Apex is used for processing a large number of records. Since the code is run asynchronously, the records are processed within platform limits. Once the batch… Read More

Batch Apex in Salesforce

Focus on People: Mark van Voornveld – Taking the Big Shift: From Microsoft to Salesforce

Mark van Voornveld is an IT professional with a 30-year career built around Microsoft Azure Stack and Dynamics. While relatively new for him, he chose to transition to Salesforce, seeing it as a fresh path to take and a good addition to his expertise. Here, he shared his professional journey, reasons for this transition, and his adjustments to a new CRM and the essential, non-technical skills that make an IT… Read More

Focus on People: Mark van Voornveld – Taking the Big Shift: From Microsoft to Salesforce

Salesforce Einstein: 24/7 At Your Service!

​ Sugar, spice, and ‘everything nice’? Salesforce almost has it all now that Einstein, the smart CRM assistant, is already at our service. Einstein was first introduced as part of the Salesforce Spring ‘17 release and is now a component of Salesforce core cloud products. This innovation was built for the Customer Success Platform to break down the complexity of artificial intelligence technology, helping customers leverage AI capabilities. It must… Read More

Salesforce Einstein: 24/7 At Your Service!

Salesforce: How It Started and How You Can Be Part of the “Ohana”

How did an innovative cloud platform become one of the world’s best CRM solutions?Salesforce has been bringing companies and customers together for over two decades. It began as a Software as a Service (SaaS) company. Salesforce is now the fifth-largest software company in the world. They leverage cloud technology and build a variety of applications for businesses to help better give them key insights into their services through analytics and… Read More

Salesforce: How It Started and How You Can Be Part of the “Ohana”

Apparent Gender Bias Hampers Women’s Career Progression in the Salesforce Ecosystem

by Zoë Morris Flexible and home working are the most desired employment benefits among women working with Salesforce, but their entitlement to these benefits is actually lower than their male counterparts. This is having an adverse effect on gender representation in the Salesforce ecosystem.Mason Frank’s annual salary survey is the largest independent exploration of Salesforce culture. As well as being useful for benchmarking salaries and learning the best education and… Read More

Apparent Gender Bias Hampers Women’s Career Progression in the Salesforce Ecosystem

4 Salesforce Exam Writing Tips to Achieve Salesforce Certification Success

by Cary Walkin Do you have your eye on a Salesforce Certification to advance your career? Perhaps it’s your first certification. Maybe you’re challenging yourself with a difficult certification. I’m a 6x Salesforce Certified professional who has had a career full of exams, and the tips in this guide have helped me and my team pass all of the Salesforce Certification exams that we’ve written. I wrote this guide to… Read More

4 Salesforce Exam Writing Tips to Achieve Salesforce Certification Success