What the business needed
Answers to everyday questions were spread across sales and stock exports from the ERP system, product documents, supplier correspondence and the knowledge in people’s heads. Questions such as which accounts had gone quiet, how a product family was moving across several codes, or what a document said about a product meant opening several files and asking a colleague.
What was configured
- A company-specific assistant with a chat interface, chat history and search, and a selector for which datasets an answer should use.
- A training area with a knowledge base, a product base, a competitor base and an email base, plus structured business data from the sales and stock exports.
- Saved team rules and corrections, and team responsibilities for who owns which knowledge and who reviews outputs.
- Answers that name the document, rows or rule they relied on, so anyone on the team can check them against the source.
Challenges that were scoped
- Loading complete rows from exports and confirming the scope of each export before reading it.
- Choosing the correct document and period when several reports could plausibly answer the same question.
- Reconciling totals in the assistant’s output to the source report.
- Grouping equivalent film codes only with the team’s sign-off on specifications and units.
- Excluding recent arrivals from slow-stock flags so a fresh delivery was not mistaken for stock that does not move.
How outputs were checked
Staff compared example outputs with the source reports, including row counts, totals and the exclusions above, and corrections were saved as team rules. The reporting use case is shown as an interactive example on the internal assistant page.
Customer feedback
Richard described how the internal assistant helped the team check company records and make better-informed decisions using their SAP Excel exports.
A paraphrase of feedback shared with Socraty Consulting, published with permission. Not a verbatim quotation.
The client has agreed to be named: read the full Kempner story. No staff name, figure or file from the project appears on this site; the interface reproduces the layout only.