Home · Business tools · Turn the SAP Business One stock report into this week's reorder list
Turn the SAP Business One stock report into this week's reorder list
Stock-outs happen because nobody reads the 400-line inventory report. Get the items to reorder, suggested quantities and supplier emails.
The prompt · ChatGPT
Help me turn our SAP Business One stock report into a reorder list. Stock report: [attach the export: item, description, on hand, committed, on order, reorder point, preferred supplier]
The full prompt is free – sign up in 10 seconds
Free account: every prompt, one-tap copy, saved favourites.
Already have an account? Log in
No password needed. We email you a sign-in link.
What you get (sample answer)
Below reorder / due before next delivery: Hinge-soft-close-110 — on hand 12, committed 8, on order 0 — order 40 (sells ~10/week, 3 weeks cover, MOQ 20). Oak-veneer-sheet — on hand 4, committed 3 — order 15 (lead time 10 days). Supplier North Timber: email "Please supply 40 x soft-close hinges and 15 oak sheets, deliver by Fri." Dead stock watch: Brass-knob-old-style — no sales in 12 weeks, on hand 60.
In SAP Business One, run the inventory report and export it to Excel (your user needs the MS-EXCEL authorisation).
Export sales by item for the last 8 to 12 weeks the same way.
Paste the prompt above into ChatGPT or Claude and attach both files.
Why it helps
The inventory report has everything but nobody has time to read it, so you find out you're out of a part when the order is already late.
Tools
Paste the prompt, fill the blanks, copy the draft.
- ChatGPT — required. Works with the business tool named on this recipe. You stay in control of what gets sent.