Nightly read
SAP Business One is read from the production company database every night into a PostgreSQL warehouse on Supabase.
SAP Business One analytics
A management cockpit on top of SAP Business One.
SAP holds the figures. We read them every night into a warehouse and give leadership sales, margin, cash and supply chain on one screen.
How it works.
The architecture of a live cockpit for a manufacturer.
Forecast workbook import
The monthly forecast stays in Excel and is loaded through an import screen that validates it.
Receivables snapshot
A daily snapshot feeds credit exposure and DSO.
Fast screens
Materialised views serve the cockpit, and the same figures are on a phone.
What leadership gets.
From the profit and loss waterfall down to each product range.
Sales and margin
By product range and by salesperson.
Cash and credit
Receivables, credit exposure and DSO.
Supply chain
Stock and flows alongside the commercial figures.
Your SAP stays untouched
We read from it. Nothing is changed in SAP unless the specification says so.
Systems we have built
Real systems, in production or in delivery. Client names are withheld.
Manufacturing executive cockpit
Sales, margin, cash and supply chain read nightly from SAP, from the P&L waterfall down to each product range.
Constraint. Figures lived in SAP and in forecast workbooks and were assembled by hand each month.
SAP Business OneExcel forecast workbookPostgreSQL (Supabase)
Read the case
Operations early-warning cockpit
Stock about to run out, a region behind pace, a discount outside the rules: flagged each morning and assigned to an owner.
Constraint. Warning signs surfaced weeks later, in a report, once the damage was done.
Sage ERPExcel targetsInstallable app with push notifications
Read the case
Five-entity group cockpit
Management no longer waits weeks for an assembled board pack. Consolidated P&L, budget and working capital, live from the ERP.
Constraint. Five entities, an on-premises ledger and a board pack assembled by hand after month end.
Dynamics 365 Business Central (on-premises)SharePoint OnlinePower BI Service
Read the case