AI Want to work smarter with AI? See how Agentforce fits your business.

Get Started

Explore Folio3

Explore Folio3 Network

×
AI-data

AI & Data

Agentic AI, computer vision, generative AI

app-development

App Development

Web, mobile, and custom software

security

Security

Engineering, warehousing, analytics

agtech

Agtech

Farm, livestock, and crop software

foodtech

Foodtech

Traceability and food supply chain

digital-health

Digital Health

EHR, telehealth, and interoperability

NetSuite

NetSuite

ERP implementation and support

Dynamics

Microsoft Dynamics

Dynamics 365 and Business Central

Salesforce

Salesforce

CRM consulting and integration

Ecommerce

Ecommerce

B2B ecommerce, ERP integrations and migrations

Integrated Salesforce With Dynamics 365 for a Midwest U.S. Hydraulics Distributor

Salesforce Sales Cloud and Service Cloud integrated with Dynamics 365 for a Midwest U.S. hydraulics distributor
88%

Fewer billing corrections, from 42 a month to 5

22 min

Median quote turnaround, request to customer PDF

94.2%

Of cases met the 1-hour first-response target

Service

  • Sales Cloud implementation
  • Service Cloud implementation
  • Custom AWS integration with Dynamics 365
  • NetSuite data migration and retirement
  • Phased territory rollout and UAT

Platforms

  • Salesforce Sales Cloud
  • Salesforce Service Cloud
  • Microsoft Dynamics 365 Finance and Supply Chain Management
  • Node.js microservices on AWS Lambda and Amazon API Gateway
  • NetSuite (retired)

Overview

Folio3 integrated Salesforce Sales Cloud and Service Cloud with Microsoft Dynamics 365 for a Midwest U.S. distributor of fluid power and mechanical components that runs 4 warehouses and about 180 Salesforce seats. Stock, pricing and orders lived in Dynamics 365, which the sales team had no view into, and customer history sat in NetSuite, which the client wanted retired. An 8-person Folio3 team connected Salesforce to Dynamics 365 and retired NetSuite. The project was planned for 12 months and delivered on plan.

Client: Midwest U.S. fluid power distributor  |  Scale: About 180 seats, 4 warehouses  |  Timeline: 12 months, on plan  |  Team: 8 people

Integration architecture connecting Salesforce and Dynamics 365 through Node.js microservices on AWS, with NetSuite data migrated and retired

Challenge

The front office had no view of the system that held stock, prices and orders.

No Live Inventory for Reps

Reps phoned the back office to check stock across 4 warehouses before they could quote.

Manual Order Entry

Quotes were built in spreadsheets and retyped into Dynamics 365. SKU typos and wrong tier-pricing choices caused 42 billing corrections a month.

Untracked Support

Cases arrived in shared Outlook inboxes, with no SLA tracking or escalation.

Customer Data Split Across Two ERPs

Historical ledgers and contact hierarchies sat in NetSuite, while daily operations ran in Dynamics 365.

A Heavily Customized ERP

More than 5 years of Dynamics 365 customizations had to be handled before sync could run at scale.

Why They Chose Folio3

Folio3 Salesforce and Microsoft Dynamics practices covering both sides of the integration

Both Sides of the Integration

Folio3 runs both Salesforce and Microsoft Dynamics practices, so one team understood the CRM and the ERP.

Custom integration with no middleware license or recurring platform fee

Integration Without Middleware Licenses

Custom microservices avoided recurring middleware fees and handled the client's specific field mappings.

NetSuite data cleaned, migrated and retired by the same Folio3 team

Data Migration in the Same Engagement

The same team cleaned and migrated the NetSuite data before it was retired.

The Solution We Delivered

Salesforce quote showing live Dynamics 365 stock across four warehouses and tier pricing

Live Dynamics 365 Stock and Pricing in Every Quote

Salesforce queries Dynamics 365 in real time while a rep builds a quote, so stock and pricing are never stale copies. Standard Salesforce Quotes with Apex covered quoting without a separate CPQ tool.

Accepted Salesforce quote automatically creating a sales order in Dynamics 365

Accepted Quotes Create the Sales Order Automatically

When a customer accepts a quote, the sales order is created in Dynamics 365 on its own. No one retypes order lines anymore.

Node.js microservices on AWS Lambda, API Gateway, SQS, DynamoDB and Secrets Manager

A Custom Integration Built Around a Customized ERP

8 legacy Dynamics 365 endpoints were refactored before high-volume sync could run. Node.js microservices on AWS Lambda and Amazon API Gateway, with Amazon SQS, DynamoDB and Secrets Manager, connect the Salesforce APIs to Dynamics 365. Field mappings live in DynamoDB, so a Dynamics 365 field change needs a configuration update, not a redeploy.

Service Cloud case queue with Omni-Channel routing, entitlements and 1-hour first-response milestones

Service Cloud With Tracked SLAs

Omni-Channel routing, Entitlement Management and Milestones replaced shared inboxes. Every case has an owner and a 1-hour first-response target.

1.2 million NetSuite records deduplicated to 600,000 clean customer records and migrated to Salesforce

NetSuite Cleaned, Migrated and Retired

1.2 million raw NetSuite records were deduplicated down to 600,000 clean customer records and migrated into Salesforce. NetSuite was then retired.

12-month plan with Sales Cloud live in month 8, Service Cloud in month 11 and four territories onboarded one at a time

Territory-by-Territory Rollout

Sales Cloud went live in month 8 and Service Cloud in month 11. The four territories were onboarded one at a time: Midwest, Northeast, Southeast and West Coast. Regional teams joined UAT outside their Q3 peak season.

Results: Fewer Billing Errors and Faster Quotes

Results dashboard showing billing corrections cut from 42 to 5 a month, 94.2% SLA and 22-minute quotes

Frequently Asked Questions

Folio3 integrated Salesforce Sales Cloud and Service Cloud with Dynamics 365 Finance and Supply Chain Management for a Midwest U.S. distributor. The client has about 180 Salesforce seats and 4 warehouses. The project was delivered in 12 months, on plan.

Folio3 removed the retyping. When a customer accepts a quote in Salesforce, the sales order is created in Dynamics 365 automatically. Billing corrections fell from 42 a month to 5, which is 88% fewer.

Folio3 cleaned the data before moving it. 1.2 million raw NetSuite records were deduplicated down to 600,000 clean customer records and migrated into Salesforce. NetSuite was then retired. See Folio3 Salesforce Migration Services.

Folio3 replaced this distributor’s shared Outlook inboxes with Service Cloud Omni-Channel routing, Entitlement Management and Milestones. Every case has an owner, and 94.2% of cases met the 1-hour first-response target.

Folio3 chooses the route by how customized the ERP is:

  • Heavily customized Dynamics 365 Finance and Supply Chain Management, as here: custom microservices on AWS.
  • Several systems at once: MuleSoft.
  • Standard Dynamics 365 Business Central flows: Folio3’s own BURQ iPaaS connector.

Folio3 prices each Dynamics 365 integration after scoping it, rather than from a standard price list, because the biggest cost drivers are how customized the ERP is and how much legacy data needs cleaning. Clients choose a fixed-price implementation for a well-defined scope, or time and material when the scope is still evolving. Managed services and staff augmentation are also available, with no onboarding fees and no lock-in.

Learn more: Folio3 Microsoft Dynamics Services

Yes. At this distributor Folio3 made Salesforce the front office for sales and service, and kept Dynamics 365 as the ERP for stock, pricing, orders and finance. Each field has a defined owner: Dynamics 365 for finance fields such as credit limits, Salesforce for sales fields such as lead status.

Folio3 recommends auditing the ERP and the legacy data before the SOW is signed. At this distributor, more than 5 years of Dynamics 365 customizations meant 8 legacy endpoints had to be refactored before high-volume sync could run, and 1.2 million NetSuite records had to be cleaned before migration. See Folio3 Salesforce Integration Services.

Folio3 brought this distributor’s four territories (Midwest, Northeast, Southeast and West Coast) onto Sales Cloud one at a time. Sales Cloud went live in month 8 and Service Cloud in month 11, and hypercare closed in month 12.

Yes. Folio3’s Service Cloud phase added CTI, Omni-Channel routing, and live inventory and order lookups against Dynamics 365. Agents answer from the case instead of asking the back office.

Folio3 scheduled UAT so this distributor’s regional sales teams could join outside their Q3 peak season, and staggered the rollout by territory. The project still finished in 12 months, as planned.

Folio3 delivered this project with an 8-person team: a project delivery lead, a functional consultant, an integration architect, two Salesforce developers, a data migration specialist, a QA lead and a project manager.