Agriculture
The Onion Group
Invoices and orders straight into Microsoft Fabric
Supplier invoices and call-off orders get read, validated, and pushed via a secure connection straight into the ERP and the data lake. Nobody has to type them in anymore.
Results achieved
Eliminated manual data entry
Centralized Microsoft stack
Automated ERP imports
The challenge
Supplier invoices and complex call-off orders with BAGS/KG variants arrived scattered across mailboxes. Employees checked, tagged, and retyped documents by hand. This resulted in errors and fragmented financial data.
Our approach
- 1.Deploy n8n as the central orchestration engine within the Microsoft environment.
- 2.Use Azure Document Intelligence for invoice and order line extraction.
- 3.Implement Microsoft Graph API for email categorization and archiving.
- 4.Build a custom Azure Bridge to handle Entra ID security into Microsoft Fabric and Navision.
The solution
A platform that writes sensitive financial data into the data lake via secured SQL stored procedures. It feeds Navision through specific BAGS/KG and EAN matching logic.
n8nAzure Document IntelligenceMicrosoft Graph APIMicrosoft FabricNavisionAzure SQL