Executive Summary
A major UK manufacturing and distribution business struggled with order bottlenecks. Whenever customer purchase orders deviated slightly from Salesforce contract agreements, SAP SD (Sales and Distribution) blocked the orders. This required manual triage, holding up manufacturing schedules.
We designed and deployed a secure, non-invasive SAP Pricing Exception Handler using n8n and a lightweight SAP gateway. The system resolves minor price disputes automatically and routes high-value exceptions to sales reps via one-click approval workflows. This solution cut manual data reconciliation by 90% and slashed order release times from 12 hours to under 5 minutes.
The Challenge
For this manufacturer, even small pricing discrepancies halted operations:
- Friction Points: Minor discrepancies in delivery terms, unit prices, or freight rates (often as small as £10) triggered blockages in SAP.
- Administrative Tax: 3 full-time data coordinators spent their entire day cross-referencing SAP records with Salesforce agreements, emailing sales reps, and manually entering SAP overrides.
- Downstream Delay: Blocked orders caused warehouse dispatch delays, leading to missed shipping dates and client complaints.
The Solution
Rather than proposing a costly and disruptive custom ABAP development project inside SAP, we built an adjacent, middle-out solution.
Blocked SAP Order
Pricing variance flagged in ERP
Click to inspect parameter details & payload
n8n Event Listener
Intercepts order block IDocs
Click to inspect parameter details & payload
Verify Contract (SF)
Checks Salesforce price tiers
Click to inspect parameter details & payload
Auto-Approve Override
Bypasses blocks under £20 limit
Click to inspect parameter details & payload
If: < £20Slack One-Click Alert
Reps approve variations ≥ £20
Click to inspect parameter details & payload
If: ≥ £20Update SAP SD tables
Releases order to warehouse
Click to inspect parameter details & payload
If: ApproveFlag for Manual Review
Logs task in Salesforce CRM
Click to inspect parameter details & payload
If: RejectKey Components
- SAP Event Listener: An API connector monitors blocked billing or order blocks via intermediate documents (IDocs) and logs the mismatch payload.
- Contract Reconciliation Engine: A workflow in n8n queries Salesforce Contracts to check if the incoming price matches a negotiated customer tier or active promotion.
- Automated Tolerances: Under predefined rules, discrepancies below a threshold (e.g., £20) are automatically bypassed by injecting a price correction block back into SAP via standard RFC/BAPI calls.
- Interactive Slack Routing: Major variances trigger a Slack notification sent directly to the assigned Account Manager with detailed line-item differences and “Approve Override” / “Reject & Cancel” buttons.
The Outcomes
- 90% Less Manual Entry: Over 90% of pricing exceptions are now processed and resolved entirely by the automated pipeline.
- Instant Order Releases: Blocked sales orders are cleared and released for manufacture in less than 5 minutes, down from a 12-hour manual queue.
- Resource Reallocation: Freed 2 full-time employees to focus on high-touch inventory management rather than copying and pasting values.
Technology Stack
- Workflow Automation: n8n (self-hosted, secure VPC)
- SAP Middleware: RFC/BAPI Gateway proxy (Node.js)
- Integrations: Salesforce API, Slack App Platform, SAP ERP (ECC 6.0)