Reports your ERP won't build. From the database you already own.
Your ERP stores everything. Getting it out is the problem. LAVO reads your ERP database directly and gives you the reports in English.
The five reports
Route margin
Invoiced revenue by route and stop, net of the costs you give it, every Monday.
| Route | Revenue | Stops | Rev per stop | Margin |
|---|---|---|---|---|
| 12 | $18,420 | 212 | $86.89 | 38.4% |
| 7 | $15,110 | 241 | $62.70 | 31.0% |
Example data.
Missing inventory trend
Every garment or mat with no scan in 30 days, by customer and route, trended week over week so you see it growing before it becomes a write-off.
AR aging by route
Open receivables bucketed by age, but grouped by the route that serves the account, so the Route Service Representative who sees the customer weekly knows who owes.
Substitutions
What was delivered against what was ordered. Which products you keep running short of, and which customers keep getting the substitute.
12-month scheduled sales forecast
Forward revenue by month from the delivery schedule in your ERP, not from last year plus a percentage. Changes the day a frequency changes.
Ask it a question
Example questions and answers.
What it needs
- An ERP on SQL Server.
- A read-only SQL login you create and can revoke.
- Outbound HTTPS from one machine on your network for the tunnel.
- Nothing installed on the ERP server.