Natural Language Queries
Ask questions in plain English and get instant answers with data from your live ERP system — across every module, no query language required.
PLAIN ENGLISHFOLLOW-UPSCROSS-MODULE
Query best practices
- Be specific about what you want to know
- Include time ranges when relevant (last week, this month)
- Use natural language — no technical terms needed
- Ask follow-up questions to drill down
- Use module names to narrow scope (inventory, production, etc.)
Inventory queries
- "Which items are below reorder point?"
- "What's the total stock value?"
- "Show me lots expiring in the next 30 days"
- "Which lots are in quarantine?"
- "How much wheat flour do we have?"
- "Show me stock by warehouse"
- "Show me stock movements this week"
- "What was received yesterday?"
- "Which items were issued today?"
Manufacturing queries
- "Which production orders are in progress?"
- "Show me orders delayed this week"
- "What's the planned production for next week?"
- "Which orders are awaiting approval?"
- "What's the average yield for bread?"
- "Show me batches with low yield"
- "Which batches had high scrap?"
- "Summarize material consumption for PO-BREAD-044"
Quality queries
- "What's the pass rate this month?"
- "Show me failed inspections this week"
- "Which lots failed quality checks?"
- "What's the pass rate by supplier?"
- "How long has lot LOT-001 been quarantined?"
- "Show me lots pending inspection"
Sales queries
- "What's the total revenue this month?"
- "Show me orders awaiting fulfillment"
- "Which customers have overdue payments?"
- "What are the top selling products?"
- "Show me orders by customer"
- "What commissions are pending approval?"
- "How much commission did John earn this month?"
Finance queries
- "Which invoices are overdue?"
- "What's the accounts receivable balance?"
- "Show me payments received this week"
- "Which invoices are partially paid?"
- "Summarize costs by category this month"
- "Show me costs by cost center"
Workforce queries
- "Who was late this week?"
- "Show me attendance by department"
- "What's the absence rate this month?"
- "Which employees missed work yesterday?"
Cross-module queries
Rona AI can handle complex queries that span multiple modules and require calculations:
- "Which production orders used lot LOT-001 and what was the yield?"
- "Show me customers who received products from lot FG-LOT-001"
- "What's the cost of goods sold for order SO-001?"
- "Which suppliers provided lots that failed inspection?"
Follow-up questions
Q1 “Which items are below reorder point?”
A1 2 items: VC-012 (12 < 20), DR-045 (0 < 40)
Q2 “Show me the stock movements for VC-012”
A2 VC-012 had 3 movements this week: received 50, issued 30, issued 8
Q3 “When did we issue the 8 units?”
A3 8 units were issued on Jan 14 for order SO-123
Query patterns
Patterns that work everywhere
| Show me [entity] [time range] | “Show me orders this week” |
| Which [entity] [condition] | “Which orders are delayed” |
| What's the [metric] [time range] | “What's the revenue this month” |
| Summarize [entity] by [dimension] | “Summarize costs by category” |
| How much [metric] [condition] | “How much stock is in quarantine” |
Pro tip
If Rona AI does not understand your query, try rephrasing it. Use different words or be more specific about time ranges, modules, or entities — the AI learns from your patterns over time.
Continue
Report generation
Comprehensive documents on demand or on a schedule — PDF, Excel, or JSON.
