Our Certified Salesforce Administrator and Sales Cloud consultant gathered requirements, developed a solution in Sandbox, and then implemented and tested the solution into the live environment.
SmartAcre led several work sessions to identify and review the client’s requirements. During these work sessions, we reviewed the process in place for calculating quotes. The client was using an Excel spreadsheet, which used multiple formulas.
The two most important calculations being used were Annual Contract Value (ACV) and Total Contract Value (TCV). These calculations are an integral part of the client’s sales reporting and forecasting reports, and it was essential that these calculations took into account the length of contract (term) and the quantity of products quoted.
In order to avoid any disruption to the sales team during the build out of the quoting functionality in Salesforce, we created a Sandbox environment, which allowed us to build and test the solution.
Once the sandbox was set up, we enabled the quoting feature in Salesforce and created new custom fields, and customized layouts. A critical aspect of this project was making sure that all the custom formula fields calculated correctly, and we were able to do extensive testing in the sandbox environment to ensure that this was executed properly.
One of the limitations of Salesforce default quoting is that custom fields are not synced between opportunity products and quote line items. Keeping this data in sync was essential, since several important fields such as TCV, ACV, term, start date, and end date were at risk of not syncing properly, since they are custom fields. To address this issue, we found a Salesforce AppExchange App that gives us the ability to keep quote custom fields in sync. We installed, setup, and tested this app functionality in the Sandbox environment to ensure it worked properly before launching.
Once the Sandbox instance was tested and approved, we were given a launch date to push the changes live. We were able to quickly deploy most of the changes through a changeset. However, you can not deploy AppExchange Apps via a sandbox, so we reinstalled and configured the app on the live environment, using the same settings we tested in the sandbox.
We then worked with our client to perform user acceptance testing based on their requirements to ensure everything was working properly. Once the quoting functionality testing was complete and determined to be accurate, we imported and activated their new price book into Salesforce using Dataloader. This saved hours of manually re-creating the excel version of their pricebook into Salesforce.
One of the main goals of the project was to make sure the quoting system made things easy for the sales reps. Based on the feedback we gathered, we determined it was necessary to create a new custom workflow to ensure consistency across data, and require less data entry. We accomplished this by setting up the workflow to automatically calculate term length and discount based on end value.
We also had to fix the recurring issue that was occurring when Sales Reps manually entered data and it was not calculating correctly. We added validation rules to make sure that the start date, end date, and length of contract all matched when sales reps manually entered all three of these fields.
Customized Fields when Adding an Opportunity Product
Product Line Items and Quote Summary on the Opportunity Layout
The custom salesforce solution we created reduced the time needed to create quotes and established consistency across the quote to customer process.