Manufacturing · Salesforce ↔ Microsoft D365 ERP Integration
NystromNystrom
×
Cloud Nerd

Bridging Sales and Operations: Nystrom's Salesforce to Microsoft D365 ERP Integration

A building products manufacturer had Salesforce CRM and Microsoft D365 ERP completely disconnected — forcing reps to manually look up pricing, orders, and account data. Cloud Nerd built a custom bidirectional APEX REST API integration and 13 CRM Analytics dashboards.

Engagement at a glance

Industry
Manufacturing
Duration
16 weeks
Services
Architecture & Design · Build & Implement · Integrations · Data & AI
Stack
Salesforce Sales CloudSalesforce Sales CloudMicrosoft D365 ERPMicrosoft D365 ERPCRM AnalyticsCRM Analytics
16 weeks

D365 integration + CRM Analytics delivered

Sales volume, win rate, retention, and more

13

CRM Analytics KPI dashboards

With event log and manual push fallback

Automatic retry logic

Eliminating manual price lookups

Live pricing

Retrieved from D365 at quote time

The challenge

Nystrom's sales organization ran on Salesforce, but every meaningful data point about a customer — purchase history, open orders, quotes, pricing — lived in Microsoft D365. Sales reps were logging out of Salesforce, into D365, looking up information, and manually updating their CRM. Quotes often went out with incorrect pricing. Leadership had no real-time analytics on pipeline or account growth.

The approach

Cloud Nerd worked alongside Nystrom's D365 partner (Ascendex Consulting) to design the integration architecture. The team built a custom bidirectional APEX REST API integration — POST services to send data to D365, GET services to retrieve D365 data on-demand, trigger-based firing logic for all scoped objects, a live pricing retrieval button on Quote Line Items, and an event log with automatic retry and manual push fallback. CRM Analytics was deployed with 13 KPI dashboards.

The outcome

Sales reps now see account details, contact history, quote status, pricing, and order information without leaving Salesforce. Live pricing from D365's pricing engine is available on every quote. Thirteen CRM Analytics dashboards give leadership visibility into pipeline, win rates, and customer retention for the first time.

The problem

What was actually broken

01

Sales running on Salesforce, data living in D365

Every customer lookup — order history, open quotes, account details, pricing — required reps to leave Salesforce and log into D365 separately. Manual data entry between systems created errors and wasted time.

02

Quote pricing not validated against D365 rules

Sales reps were entering pricing from memory or outdated price lists — D365's pricing rules were not consulted at quote time, creating margin risk on every deal.

03

Zero sales analytics

Pipeline, deal win rates, account growth, and customer retention were all tracked in spreadsheets — there was no real-time reporting on sales performance.

How we did it

The work, phase by phase

  1. 01
    Weeks 1–4

    Integration Architecture & Setup

    Cloud Nerd worked with Ascendex Consulting to design the integration architecture, configure OAuth 2.0 authentication in Salesforce, and establish the Custom Metadata framework for field-level mapping configuration.

    • OAuth 2.0 Auth Provider and Named Credentials in Salesforce
    • Custom Metadata framework for object and field mapping
    • Integration architecture document and sequence diagrams
    • REST service endpoint definitions for all scoped objects
  2. 02
    Weeks 4–12

    Bidirectional APEX REST API Development

    Cloud Nerd built the full suite of APEX REST API integration components — POST services, GET services, trigger-based firing logic, a live pricing button, event log table with retry logic, and full APEX test coverage.

    • APEX REST POST services for Account, Contact, Quote, and Order sync to D365
    • APEX GET services for on-demand D365 data retrieval in Salesforce
    • Trigger-based integration firing logic for all scoped objects
    • Retrieve Pricing button with asynchronous D365 pricing API call on Quote Line Items
    • Event log table with status, error messages, and timestamps
    • 3-attempt automatic retry logic with manual push fallback
    • APEX Test Classes with full code coverage
  3. 03
    Weeks 13–16

    CRM Analytics Reporting Layer

    Salesforce CRM Analytics was deployed with 13 key sales performance dashboards — giving Nystrom leadership a real-time view of pipeline health, customer relationships, and sales team performance for the first time.

    • Sales Volume by Location dashboard
    • Sales Cycle Length and Deal Win-Loss Ratio
    • Customer Lifetime Value (CLV) report
    • Quote and Proposal Sent tracking
    • SQL-to-Customer Conversion Rate
    • Customer Retention Rate and Average Revenue Per Account
    • % Growth by Key Account and Designation
The results

What changed for Nystrom

Single pane

Salesforce shows account, order, pricing, and history in one place

Live pricing

D365 pricing rules applied at quote time — no manual lookups

13

Real-time CRM Analytics dashboards for sales leadership

Resilient

Integration with event log, auto-retry, and manual push fallback

What's next

Nystrom is evaluating additional Salesforce CPQ capabilities to extend the quoting workflow and further streamline the path from D365 pricing to customer-facing proposals.

Technologies in this engagement

Salesforce Sales CloudSalesforce Sales Cloud
Microsoft D365 ERPMicrosoft D365 ERP
CRM AnalyticsCRM Analytics

Ready to do this?

What would we build
at your company?

Book a 30-minute strategy call. We'll walk through exactly what we'd do on your stack — no commitment, no pitch deck, just specifics.

Book a Strategy Call