Case Study: How CRMONCE Automated Purchase Order Processing from Inbox to Sage 100 Sales Order

Watch the Case Study Video

Client: CRMONCE, a Microsoft Dynamics 365 and Power Platform consulting firm.

The Challenge

Purchase orders arrived as PDF attachments to a shared inbox, each based on a different customer's own template. Staff were manually reading each PO, cross-checking it against the sales quote already on file in Dynamics 365 CRM, and then re-entering the order into Sage 100. This created processing delays and occasional mismatches between what was quoted and what was actually keyed into the ERP, along with the routine risk of manual data entry errors on quantities and pricing.

The Solution

CRMONCE built an automated pipeline using tools already native to its Microsoft-centered stack. Incoming PO emails trigger a Power Automate flow that captures the PDF and sends it to a custom Azure Document Intelligence model trained on real customer PO formats. A dedicated matching service cross-checks each extracted line item against the corresponding CRM quote, flagging price or product mismatches instead of assuming the extraction is correct. Validated orders are handed to Sage 100 through its Visual Integrator module, which runs a predefined import job to create the sales order without requiring custom ERP-side development, and the resulting sales order number is captured and written back onto the CRM record for full visibility.

The Results

Manual re-keying of purchase orders was eliminated for the majority of incoming orders, with only genuinely mismatched or low-confidence lines routed to a human for review. Turnaround from email receipt to confirmed Sage 100 sales order dropped from a manual, multi-step process to a largely automated one running in minutes. Because CRM and Sage 100 stay in sync automatically, sales and support staff have immediate visibility into order status without needing to check both systems separately. The matching layer also added a quality gate that hadn't existed before, catching pricing or product discrepancies between quote and PO before they became fulfillment problems.

Looking Ahead

CRMONCE is extending the same pipeline to cover order change requests and additional customer PO formats, building on the existing Document Intelligence model rather than starting over each time a new customer format appears.

Read the full technical breakdown in our companion post: From Inbox to Sales Order: Automating PO Processing with Azure Document Intelligence, Power Automate, and Sage 100 Visual Integrator.