Category: ADM

Product Schedule in Salesforce

In Sales Cloud, when companies are dealing with Accounts, Contacts, Opportunities and Products, one thing is very obvious who the company will get the money back from the Contacts for the Products sold to them. Are the contact/account going to pay all together in one shot or are they going to pay over the period of times(Equal Installments)? Salesforce has the answer to these questions. In Salesforce you can configure how your customer will pay you the money. Based on that configuration, you can run your business reports to track your sales matrices. The way you can configure this in Salesforce is known as Product Schedule. Product Schedule are the payment or delivery cycles for the products which will be either paid over time or delivered over time. In Salesforce we have three different types of schedules. Quantity Schedule: Choose this schedule when you want your products to be delivered over the period of time. Example – Consider your customer bought subscription of one magazine from you for the next 2 years. Now you need to courier the monthly subscription to your customer every month. So in this scenario, you will go for Quantity Schedule.Revenue Schedule: Choose this schedule when you want your customer to be billed over the period of time. Example – Consider you are selling House Insurance to your customer. The total cost is USD 1200 for one year....

Read More

Relationship between Product, Price Book and PricebookEntry

In my previous post, I have explained the basic concepts about Products and PriceBooks. You can read the post here – Products and Price Books in Salesforce.Now in this post, I am going to explain the relationship between Product, Price Book and PricebookEntry. So let’s start with few basics.Basic:Products are represented by Standard Object – Product2.PriceBooks are represented by Standard Object – Pricebook2Each Pricebook can have zero or more entries. Each of these entries are stored inside the Standard Object – PricebookEntry. Each entry in PricebookEntry defines the cost of the products in a particular currency.These three objects – Product2, Pricebook2 and PricebookEntry will only be available if Product is enabled in the organization.Data Model:PricebookEntry is the junction object between Product and Price Book.OpportunityLineItem is the junction object between Opportunity and PricebookEntry.Below is the flow diagram depicting the process to load Products and setup PriceBook through API.I hope this post will help you to understand the relationships between these objects. Please provide your feedback....

Read More

Products and Price Books in Salesforce

Define your Product:A Product is a service or item that the company sells to the customers. Once you have added the Products, you can set the price of the product per unit based on your business. In Salesforce, Product is a Standard object having standard fields and tabs. You can add your custom fields to customize Product object as per your business requirement. Products can be added to the Opportunity allowing you to have an correct inventory and also make your forecasting accurate.What is Price Book:The Price Book will provide the list of products and their prices per unit. You can create multiple price books to maintain different prices for the same product based on your business needs. Salesforce will always provide your a Standard Price Book. The moment you add a Product into Salesforce and set the price of the Product, that Product will go into Standard Price Book. But you can create Custom Price Book as well.Use case of Custom Price Book:Let’s say, the company “Universal Company” is selling the product – “Desktop Mouse” globally. The company is running it’s business from Canada. But company is selling products globally. Now when this company is selling “Desktop Mouse” within Canada, the price is USD 12.00, but when it is selling the same product in Europe, the price is USD 19.00 (due to extra shipping cost), similarly then the...

Read More

Cleared ADM 201 – Guides to Pass Salesforce Certified Administrator

Last week, I have cleared Salesforce Certified Administrator certification. It is really a great feeling after passing the certification. In this post, I would like to share the few information so that you can also make yourself ready for the certification. First of all – go through the Study Guide @ This is very important and it will give you a very good idea about the certification.Then if you / your organisation is having partner portal access, then I think you are really lucky. Go through the below training from Salesforce partner portal.Administrative Essentials for New Admins (This is a must)Analyze Your Data Your Way with Reports + Summarize Your data with Highlights, Charts and Dashboards (This is another important one. Reports and Dashboard are having 13% weighting so you can expect good amount of questions from this section)Administrative Essentials for the Service Cloud (Understand Case Management – How to automate Case Management, Solution Management etc.)Configure Salesforce with Custom Fields (If you are already Dev 401 certified, then this section will be very easy for you. Otherwise keep your concentration tight when going through this training)Managing Users and Troubleshooting Login Issues (I highly recommend everyone to go through this training. It will be very short training, very interesting one. Surely you will get few questions from this section)Getting Started with Managing Data (Understand the difference between Data Loader and Import Wizard, When...

Read More

Types of Report in Salesforce

In Salesforce, we have four different types of report. I will explain each of them below -Tabular Report – This is the most basic report. It displays just the row of records in a table like format with grand total. Tabular reports cannot be used for generating dashboards. Below is a screenshot of Tabular Report on Opportunity object.Summary Report – This is the most commonly type of report. It allows grouping of rows of data. It supports sorting and displaying subtotals. Summary Report can be used to create Dashboard. For example in the below report on Opportunity object, report is grouped by type as shown below -Matrix Report – This is the most complex report format. Matrix report summarize information in a grid format. Matrix Report can be used to create Dashboard. Matrix reports allows records to be grouped by both columns and rows. Below is one example -Joined Report – A Joined Report can have data from multiple standard or custom report types. A joined report can have five report blocks where you can add summary fields, apply sorting, filter. Below is one example of Joined Report (All Opportunity vs Open Opportunity) –  [Note – Please refer Salesforce’s documentation on Joined Report. There you will get more examples and also the limitations of Joined Report. Here is the link – Joined...

Read More