CRM with a Standard Sales Process, Customer 360 and Quotes
Industrial polymers producer
In short
How can a B2B manufacturer move customer data from spreadsheets into one CRM?
Customer data at the client lived in personal notes and spreadsheets, prospects were validated by hand, and every salesperson worked slightly differently. Management could not make decisions from data that did not exist in one place. We built a CRM with one sales process, a Customer 360 view and a semi-automated quotation process.
At a glance
- One customer view replaces notes and spreadsheets
- One standard sales process for the whole team
- Semi-automated quotation process
The client
The client is a business-to-business producer in the polymers and chemicals sector, selling to industrial customers through a direct sales team. The CRM covered the sales process from prospect to quote and gave management one view for reporting.
What it was costing them
- Time: salespeople searched notes and spreadsheets for customer history and rebuilt quotes by hand.
- Errors: prospect validation and onboarding were manual, so data was incomplete or inconsistent.
- Key-person risk: customer knowledge sat in personal notes, so it left with the person.
- Missed sales: without competitor and project data, cross-selling and co-selling opportunities went unseen.
- Weak decisions: management could not report from consistent data.
What we built
We built a CRM that standardised how sales data is entered and added a Customer 360 view, reminders and a semi-automated quotation process.
- One view of each customer: a Customer 360 view brings contacts, history, meetings and projects together.
- The same process for everyone: standard forms and stages guide each salesperson through the same sales process.
- Competitor knowledge in one place: competition analysis is captured against the customer, not in a private file.
- Meetings and new projects recorded: reporting on meetings and new projects is part of the CRM, not a separate spreadsheet.
- Fewer missed follow-ups: automated reminders and suggestions prompt the next step.
- Faster quotes: the quotation process is semi-automated, with flexible and managed price handling.
- Prospect onboarding made simple: validation and onboarding of new prospects follow the same standard path.
- Data for management: reporting capabilities were increased, so decisions use CRM data.
Results
- Customer data, competitor notes, meetings and new projects are captured in one standard CRM structure.
- Quotations became easier and less time-consuming, with flexible price management.
- Reminders and suggestions give the sales team a proactive way to follow up, which supported more co-sale and cross-sale opportunities.
- Management gained reporting on standard data for strategic decisions.
The risk most teams miss
The month-three risk is adoption. If entering data is harder than keeping a private note, salespeople go back to spreadsheets and the CRM goes stale. Price lists and quote rules also go out of date. We kept data entry standard and short, and used reminders and suggestions to give people a reason to open the CRM. We also name a price list owner and publish a data quality view.
What we would add today
Improvements we would add on top of what is live.
- Add Copilot in Dynamics 365 Sales or a Copilot Studio agent to summarise customer history before a meeting.
- Use AI Builder prompts to draft a quote cover note and a prospect summary from CRM data.
- Apply Dataverse row-level security by region and product line, so people see only their own accounts.
- Move releases to Power Platform pipelines with environment variables for price lists and connection references.
- Open a Power Pages page where customers view and accept quotes.
Technology
Microsoft Dynamics 365 and Power Platform: CRM on Dataverse, Power Automate for reminders and quotations, Power BI for reporting.
Tell us where your customer data lives today, and we will tell you what it takes to put it into one standard sales process.
Products and capabilities
- Dynamics 365
- Dataverse
- Power Automate
- Power BI
- Customer 360
- sales process
- quotation process
The service behind this work
Dynamics 365The service behind this work
Power BIMore on this industry
Manufacturing and distribution
Related use cases
Sales and customer serviceCustomer Portal for Order Placement and Tracking
When customers order by phone or email, the sales office types each order in again, answers every call asking where a delivery is, and finds mistakes after the lorry has left. We built a customer portal where approved customers place and track orders without the sales office in the middle.
Three Trading Platforms on Model-driven and Portal Power Apps
A trading desk loses time and control when its tools are slow, scattered or closed to the brokers it deals with. The client needed platforms that traders inside the company and brokers outside it could both use at the pace of daily business. We developed three, using model-driven and portal Power Apps.
- 3
- trading platforms
- 100+
- traders and brokers
Mini CRM Options on SharePoint or Dataverse for Teams
A client list kept in spreadsheets has no history, no clear owner for each relationship and no shared view of who knows whom. A full CRM is too much for a team that needs a simple one. We compared three light options for a mini CRM, so the team could choose with the trade-offs in front of them.
- 13 hrs
- model-driven build
- 42 hrs
- per canvas build
Have a Microsoft project in mind?
Tell us what you need built, fixed or supported. A senior consultant replies within one business day.