Fuji Oil: SAP order changes, visible within two hours
Fuji Oil, an oils and seeds wholesaler with around 500 employees, got the sales-order change report SAP did not have — a robot, change tracking and Power BI, delivered in two months after a previous vendor spent six months with no result.
What the client came to us with.
Fuji Oil, an oils and seeds wholesaler with around 500 employees, runs on SAP. Sales kept changing ship and delivery dates on orders, and SAP had no report of those changes — logistics and revenue forecasting learned about them late. One employee spent close to a full working week tracking the changes by hand, through SAP and Excel. A previous vendor had spent more than six months on the same problem with no result.
The solution.
A Power Automate flow orchestrates a robot (Power Automate Desktop) that pulls reports from SAP into SharePoint and a database; a procedure fills the reporting tables and triggers change tracking (Change Data Capture); the Power BI report “Sales Order Changes” refreshes for end users. Delivered in two months; the engagement continued for years afterwards.
What measurably changed.
Data extraction went from several days to under two hours, so the report can refresh several times a day. Around 120 hours of manual work saved per month.
“The team’s innovative approach and rapid delivery exceeded our expectations. The solution not only resolved our immediate challenges but also set the foundation for continued success.” — Tricia Taylor, Analytics Lead, Fuji Oil
Facing something similar?
We start with a discovery workshop: 1–2 weeks, fixed price, and a scope and estimate document at the end — yours whether or not we go further.
Request a workshop