Ask your ERP a question. Get the number, cited.
Lunica answers a question in English with a read-only query over your ERP, the result, and the rows behind it.
Finance & reportingUpdated Oct 202620 ERPs
See it work.
Click through the steps. Fictional data; the real thing runs on your ERP.
Which accounts are more than 90 days beyond their terms, by salesman?
Five accounts, $76,792.50 in total. Three belong to Rick Alder.
| Salesman | Customer | Beyond terms | Balance |
|---|---|---|---|
| R. Alder | Bayview Decks | 118 days | $31,240.15 |
| R. Alder | Oak Hill Builders | 104 days | $9,870.00 |
| R. Alder | Ferry St Renovations | 97 days | $12,402.35 |
| T. Nguyen | Shoreline Electric | 101 days | $12,980.00 |
| T. Nguyen | Granite Peak Builders | 95 days | $10,300.00 |
5 rows from your ERP’s open items, aged on each account’s terms · read at 6:02 am · query shown below
A governed, read-only query over the open items, aged on each account’s own terms. The rows come back with the answer.
The problem.
The number exists in your ERP. Getting it means knowing which screen, which report, which filter, or asking the one person who does and waiting until they’re free.
So people keep their own spreadsheets, and three versions of last month’s sales circulate on Monday.
How it works.
- 1
Ask in English
Open accounts over ninety days by salesman. Drywall sales this month against last. What we paid a vendor in the third quarter.
- 2
A governed, read-only query
Written against curated knowledge of your ERP’s tables and terms codes, checked by a governor: select only, single statement, row-capped.
- 3
The answer, cited
The figure, the table behind it, and the query, so anyone can check it. Validated against your ERP’s own screens during setup.
- 4
Export or automate
Excel or PDF in one click. Save the question as an automation and have it in your inbox every Monday.
How it connects to your ERP.
Lunica reads your ERP through its database or data warehouse, under an account that can only read: the customer file, open items, invoice history, purchase orders and receipts, the item file, whatever the question needs. Each query is written against curated knowledge of your ERP’s tables and terms codes, so an account on Net 30 EOM ages from end of month, and runs as a single select capped at a row count. The model sees the question, the schema context and the rows behind the answer, never the whole database.
Nothing is written to your ERP by Ask, and nothing is sent on its own. The governor allows one read-only select per question and refuses everything else. An export is a file a person downloads; a saved question goes only to the inbox of the people you named. If an answer leads to a change, a credit limit, a price, a count, that change is keyed by your team in your ERP, never by a query.
What a week looks like.
- The number comes from the system of record, not a spreadsheet.
- Every answer shows its work.
- Every question is logged with the user’s name.
- Monday’s report writes itself.
Questions
Can it change anything in your ERP?
No. Every query passes a governor that allows a single read-only select and nothing else.
Is it accurate?
Answers are validated against your ERP’s own screen values during setup, and every figure links to its rows so you can check.
Who can use it?
Anyone you give an account. Read-only accounts can ask; only named users can send or act.
Which your ERP data can it see?
Whatever the read-only account is granted: the customer file, open items, sales history, purchasing, inventory. The scope is set at onboarding and can be narrowed per user.
Does it run on our server?
Yes. Lunica runs on one server inside your network, beside your ERP, and every query runs there against its database or data warehouse, under an account that can only read.
Does our data train anything?
No. The model sees the question and the schema context it needs, and nothing is used for training.
Available for.
Each version is written in that system’s own terms: its screens, its files, its codes.
Own your AI. Own your software.
Thirty minutes with the people who build it. Bring your ERP.