Blog

If you have had a requirement to track field service in Salesforce, up until recently, you had two options: create a custom solution, or implement an AppExchange solution such as ServiceMax. Now, with the recent Spring’16 release, Salesforce have added the beginnings of a field service solution.

The initial functionality is centered around Work Orders. Work Orders is the central object used to track repairs, perform maintenance activities and other types of service requests that require an on site visit. Work Orders and Work Order Items represent a task or series of tasks that are to be performed and related to an installed Asset. They can also be associated with Accounts, Cases, Contacts, Entitlements, Service Contracts and other Work Orders. Also custom relationships can be created with other custom or standard salesforce objects. With the Spring’16 Release Work Orders are available in all Salesforce Org and does not require any extra licensing.

work-order-settings

Once Work Orders has been enabled for the Org, the details like fields, page layouts, validation rules, triggers and other components are available just like any other Salesforce standard object. Work Order Line Items provide specific tasks that are required to be performed in order to complete a Work Order. There can be multiple Line Items for Work Orders and they can be completed one by one.

work-order

Viewing Work Orders

Work Orders can be associated with Accounts, Assets, Cases, Contacts, Entitlements, Service Contracts and other Work Orders. Apart from these standard objects, they can also be associated with custom objects. In order to associate Work Orders with standard or custom objects, the corresponding lookup field needs to be setup in the custom object and the related list needs to be added to the page layout.

work-orders-adding-to-related-lists

Creating Work Orders

Work Orders can be created by going to the “Work Orders” tab which would already be available in the tabs section for the organization. In order to be able to view the tab and create Work orders, “Read”, “Create”, “Edit”, “Delete” permissions would be required on the user profile.

basic-access

If the Work Orders tab has been set on the Console App then it can directly be accessed from the console as well. Similarly for “Work Order Line Items” also all the same permissions would be required in order to be able to create one. Just like any other object there are already standard fields available for the Work Orders Object and custom fields can be created and set on the page layout.

Creating Work Order Line Items

“Work Order Line Items” are an essential part of the Work Order, they are step by step tasks that are part of completing a Work Order. By default the Work order Line Items related list is already available on the Work Orders page layout and a Line Item can be created directly from there.

work-order-detail

In-Built RollUp Summaries

The Work Order object has 3 default roll-up summaries, which are:

  • Subtotal (SUM Work Order Line Item)
  • Total Price (SUM Work Order Line Item)
  • Line Items (COUNT Work Order Line Item)

These roll up summaries are based on the Work Order Line Items object, rolling up the fields unit price, quantity and discount.

Let us consider an example of Refrigerator needing service. A work order was created with the Work Order Line Items to represent the work required. One of the Line Items represents the servicing the Asset for which the Unit price was set as $30 and quantity 1. A discount of 5% was granted to the customer. The Sub-total field, which is a standard field, is calculated on the basis of unit price multiplied by quantity. Similarly there is a Total price standard field which is calculated on the basis of Subtotal with the discount applied.

work-order-line-item1

Using these fields the values of the roll-up summary fields are populated. For the Subtotal Roll Up summary field, it will be calculated on the basis of the sum of all the “Subtotal” fields in the Work Order Line Items for the Work Order. Similarly for the “Total Price” roll-up summary field, it will be a sum of all the “total price” fields of the Work Order Line Items under a Work Order. Also there is one more roll up summary field that provides a count for the no of Work Order Line Items available under the Work Order.

work-order-detail2

Incorporating Work Orders in the Support Process

There are several ways in which Work orders can be incorporated to your support process, here is an example. A customer has called, reporting that the refrigerator that was purchased only a few months ago, is not working at all. Here are the steps that could be followed to address this situation.

1. The agent creates a case for the customer to record the call and tries to troubleshoot over the phone. This was not successful so a field technician will need to visit the customer. The agent then creates a Work Order related to the case and adds the details from the case.

work-order5

2. The agent can create the work order Line Items that are part of a standard service call, including the service call fee, labor and parts. The agent assigns the work order to the appropriate technician.

work-order6

3. A technician is sent to repair the Asset. He can view and edit the work orders assigned on his phone using the Salesforce1 App. He works through the Work Order Line Items and starts performing the tasks. He marks them complete once they are complete by changing the status for the specific Work Order Line Item.

work-order7

4. Once all the “Work Order Line Items” are completed the Work Order is closed by the technician.

work-order-detail8

5. Finally, as the Work Order is closed the corresponding Case associated with the Asset is closed by the agent and the agent can check any additional information the technician has added to the work order that described the work done, for future reference.

work-order9

Have you already started using “Work Orders” and incorporating it within your Support Process?

What Certification are you studying for now?

Focus on Force currently provides practice exams and study guides for sixteen certifications

Work Orders in Salesforce (Spring’16 Release)

If you have had a requirement to track field service in Salesforce, up until recently, you had two options: create a custom solution, or implement an AppExchange solution such as ServiceMax. Now, with the recent Spring’16 release, Salesforce have added the beginnings of a field service solution. The initial functionality is centered around Work Orders. Work Orders is the central object used to track repairs, perform maintenance activities and other… Read More

Work Orders in Salesforce (Spring’16 Release)

Osler: From Idea to AppExchange

Interview with Steve Sacks, Founder/Director at Osler Technology Most of us using Salesforce use one or more AppExchange Apps to supplement and expand the functionality available to us. Apps range from small point solutions, such as address validation to the larger apps that address a need such as document generation (e.g. Conga) to Apps that sit on top of Salesforce that are focussed on the needs of a particular industry,… Read More

Osler: From Idea to AppExchange

VisualForce Reports

Salesforce Reports provide a variety of formats and options to enable us to build reports from our data. However, sometimes we cannot achieve exactly what we need either in terms of the way the data is presented, or having a requirement to report on data that is not related in a way that can be consolidated in a report. That is when we may consider a Visualforce report. A Visualforce… Read More

VisualForce Reports

Macros in Salesforce

Have you ever had to perform the same action on multiple records in Salesforce? Wished there was a better way to save time? You may have thought about the possibilities in Microsoft Word or Excel to use macros to perform repetitive actions and wished there was something similar in Salesforce. Well, there is! There is a macro capability and, it is available for all standard and custom feed based objects…. Read More

Macros in Salesforce

Target Reports using Custom Summary Formula Fields

Have you ever come across the need to do actual vs target reporting in Salesforce? It could be to report on if Salespeople are reaching their targets for the value of closed opportunities. It could be whether the number of orders has reached the goal for the month. Another example could be the number of qualified leads created. While it is easy to create reports that summarize actual data, how… Read More

Target Reports using Custom Summary Formula Fields

Passion + Non Stop Learning = Salesforce MVP in 2 Years

Salesforce has been in the market for 17 years now, and it has not only helped companies grow but it has also provided countless job opportunities to IT professionals. Vamsi Krishna is one of those who have benefited from the competitive advantage offered by Salesforce in terms of skills enhancement and professional development. He shares how he got started with Salesforce, his successes, learnings, challenges encountered, and his career journey… Read More

Passion + Non Stop Learning = Salesforce MVP in 2 Years

Merge Fields in Salesforce Tasks

Using Workflow to create followup tasks or reminders is a common use case. It is also simple to setup, just create a workflow rule with a rule trigger date a number of days in the future. Say we wanted to have a followup task generated 5 days before the Opportunity close date. This is easy, but standard workflow comes with a limitation, merge fields cannot be used for field values…. Read More

Merge Fields in Salesforce Tasks

Single vs Multiple Sales Processes in Salesforce

  How Many Salesforce Sales Processes Do You Need?Are you contemplating whether to have one or set up multiple sales processes in your Salesforce Org? Prior to determining whether you need a single Sales Process or multiple Sales Process it is worthwhile to look at the definition of a Sales Process without reference to Salesforce:“A defined set of repeatable, interrelated activities from market awareness through servicing customers that allows communication of progress… Read More

Single vs Multiple Sales Processes in Salesforce

Getting a Salesforce Job

Salesforce Jobs I recently sat down and had a chat with Stuart Smith and Bradley Bilinsky, two business managers at Talentforce, an Australian recruitment company that specialize in Software as a Service roles, including Salesforce. One point of difference that Talentforce has from other recruiters is that they also run the Sydney Salesforce User Group, so they are active in the community. Stuart and Brad shared their thoughts on the… Read More

Getting a Salesforce Job

Powering your Salesforce reports using the PARENTGROUPVAL function

  How to Use the PARENTGROUPVAL functionThe ParentGroupVal function is one of the lesser known features of Salesforce reporting. In this article you will learn how to create some key metrics for summary reports by using the PARENTGROUPVAL function within a summary, joined or a matrix report. The function obtains the summary value from a parent group, which is a grouping that is a level above the current grouping. The syntax… Read More

Powering your Salesforce reports using the PARENTGROUPVAL function

Salesforce Custom Related List using jQuery

In the previous article we created a custom account interface by using Visualforce, in this article we’ll extend the functionality by creating a fully custom Opportunity related list. The Opportunity related list will be replaced with a custom table, and it will support: ✓ Pagination ✓ Filtering ✓ Sorting ✓ Quick filtering open Opportunities In order to implement this we need four steps: STEP 1: Create an Apex controller extension… Read More

Salesforce Custom Related List using jQuery

Focus on People: Danielle Tonkin — From Admin to Consultant

Although most Salesforce Administrators are quite happy with their job, I’m sure there are a number who have an interest and aspiration to become a Salesforce consultant. Danielle Tonkin is one of those that made the transition from Admin to functional consultant. Here she shares with us what it is like to work as a Salesforce consultant, the challenges, successes and her tips for those interested in following her Salesforce… Read More

Focus on People: Danielle Tonkin — From Admin to Consultant

Visualforce Tabbed Interface

Using Visualforce to build a tabbed user interface In this example we will override a standard view with a few lines of Visualforce to build a tabbed interface. Use case: Customize the interface for the Account object using Visualforce tabs. The following tabs should be available: Detail – Display general information about record. Inline edit feature should be supported; Contacts – Related Contacts list should be displayed in this section;… Read More

Visualforce Tabbed Interface

Salesforce Global Picklists

Global Picklists One of the most voted ideas in the Salesforce IdeaExchange forum was to be able to create a picklist that can be shared across objects. Shared Picklist Idea Salesforce delivered the idea in pilot as of Winter ’16, and is now in Beta for Spring ’16. If you look at the release notes, you would find it by the name ‘Global Picklists”. It is also referred to as… Read More

Salesforce Global Picklists