Skip to content
woodfrog
Data Foundations
DistributionUse case, no client result yet

See live stock, orders and dispatch in one place.

Your ERP says the stock is there. The warehouse says it is not. Sales has already promised it to a customer, and nobody can tell you which truck the last order left on without making three phone calls.

One view, refreshed every few minutesSchematic
4.0×Target return in 12 months, on your own numbers
Week 1Fixed-fee audit
6 weeksTo the first live result
3Senior people on the work
TypeUse case: what we build, not a client story
ForDistributors and wholesalers running an ERP such as Tally or SAP alongside a warehouse system
EngagementWeek 1 audit, then build in about six weeks, fixed scope, fixed fee
Runs onAntvia lakehouse and BI in your own cloud, with connectors to your ERP and warehouse system
Before and after

From three systems and a phone call to one view.

Before
  • Stock in the ERP and stock in the warehouse never match
  • Orders promised against stock that is already allocated
  • Dispatch status lives in calls and chat messages
  • Reports built overnight, out of date by mid-morning
After
  • One stock figure per SKU and warehouse, with any gap shown
  • Open orders checked against free stock, not total stock
  • Every order stage visible, from allocation to delivery
  • Refreshed every few minutes, not once a night
The problem

Three systems, three answers, and a customer waiting.

Orders live in the ERP. Bins and picks live in the warehouse system. Dispatch lives in e-way bills, transporter messages and someone's notebook. Each is right about its own part, so the only way to see a whole order is to ask people, and by the time you have asked, it has moved.

Tall racks of palletised stock in a warehouse
The stock is somewhere on these racks
What was broken
  • The ERP and the warehouse system disagree on stock, and nobody knows which to trust.
  • Sales promises from total stock, not stock that is free to sell.
  • Short shipments are found at packing, after the customer was told yes.
  • Dispatch status is chased by phone, one order at a time.
  • Reports run overnight, so the morning meeting looks at yesterday.
You might be here if
  • Someone calls the warehouse before confirming a large order.
  • Your daily stock report is a spreadsheet stitched by hand.
  • Customers ask where their order is and your team has to find out.
  • You carry extra stock because you do not trust the figure you have.

Why it mattered. Every wrong promise costs a customer's trust, and every unknown costs safety stock. Both come from not seeing the same thing at the same time.

The approach

Join the systems on the order, not on the report.

We do not build another report on top of each system. We follow one order through every system it touches, from the ERP line to the pick to the e-way bill, and write down where the records join and where they disagree. Then we pull each system every few minutes into one model, so a stock figure, an order and a dispatch all refer to the same thing.

A warehouse worker scanning a pallet with a handheld scanner
Every scan becomes part of one picture
Where it lives today
ERP orders and invoices
Warehouse bins and picks
E-way bills and transporters
woodfrog method
Trace one order end to endWhere records join and differ
Pull every few minutesInto one order and stock model
Flag every mismatchWith an owner to fix it
What changes
One stock figure
Free stock, not total
Every order stage visible
One live operations view
Deliberately not doneReplacing your ERP or warehouse system. They keep running as they are.
Your team owns the rules. Claude helps map fields and draft checks.schematic
The solution

One live model of stock, orders and dispatch.

What we build
  • Connectors that read your ERP, warehouse system and dispatch records every few minutes, without changing how those systems work.
  • One order model that links each order line to its allocation, pick, pack, e-way bill and delivery.
  • Free stock per SKU and warehouse: on hand, minus allocated, minus held, so sales promise from what can actually ship.
  • A daily stock match between ERP and warehouse, with each gap listed by SKU and given an owner.
  • An operations view for sales, warehouse and management: what is short, what is stuck, what left today.
  • Alerts for the few things that need a person now, such as an order promised without free stock.
It runs on Antvia, our lakehouse plus BI, in your own cloud on open formats, with connectors for 300+ sources. Your ERP and warehouse system stay exactly as they are. Everything is documented so your team can change it without us.
How it would runWeek 1 ends with one order traced through every system, so the gaps are known before the build starts. Operate is open-ended and drawn at one week only to fit.
The impact

What we would measure.

Which stages of an order you can seeBefore: the ERP knows the order and the invoice. The rest is a phone call.
Schematic, no values
Filled means the stage is visible without asking anyone.
What we would measureNo client values yet
Stock gaps between ERP and warehouseBy SKU, each with an owner
Orders promised without free stockCounted every week
Calls made to check an order's statusBefore and after
Age of the data in the morning meetingFrom overnight to minutes
Return on the engagementTarget: at least 4.0× within 12 months, measured on your own numbers
See every order without picking up the phone.A short call, or record a message. A person replies within one business day.
Contact usCertified Services Partner, Claude Partner Network