Agriculture
The Onion Group
Automated invoice and order processing into Microsoft Fabric
Supplier invoices and call-off orders are extracted, validated and pushed via a custom Azure Bridge straight into the ERP and the Microsoft Fabric data lake.
Results achieved
No more manual data entry
Centralized in Microsoft stack
Error-free ERP import
The challenge
Supplier invoices and complex call-off orders with BAGS/KG variants arrived scattered across mailboxes. Documents were checked, tagged and retyped by hand, with errors and fragmented financial data as a result.
Our approach
- 1.n8n as the central orchestration engine inside Microsoft
- 2.Azure Document Intelligence for invoice and order line extraction
- 3.Microsoft Graph API (OAuth2) for mail categorisation and archiving
- 4.Custom Azure Bridge to handle Entra ID security into Microsoft Fabric and Navision
The solution
A streamlined platform that writes sensitive financial data into the data lake via secured SQL stored procedures and feeds Navision through advanced BAGS/KG and EAN matching logic.
n8nAzure Document IntelligenceMicrosoft Graph APIMicrosoft FabricNavisionAzure SQL