Questions to ask Business Central
How do I find slow-moving or dead stock in Business Central?
The short answer
In standard Business Central:
- Run Inventory – Top 10 List set to show the smallest sellers.
- Run Item Age Composition – Value to see how long stock has been on hand.
- Check Item Ledger Entries for each item’s last sale or consumption.
Putting these together for every item, and deciding what counts as slow, is usually a spreadsheet job.
The faster way
With Bee Solved, the AI Assistant for Business Central, you ask which stock is not moving.
Which items are dead or slow-moving?
| Cable tray | 140 on hand, no sales in 12 months |
| Desk lamp | Over 400 days of stock |
| Monitor arm | Over 250 days of stock |
It lists items with stock on hand and no issues (sales or consumption) in the window, which is the last 365 days unless you choose another, and items holding more than 180 days of stock at the window’s rate of issue. The same question can also show an ABC ranking by value of issues, items selling below cost, and items likely to run out before the next receipt.
Bee Solved works in Claude, ChatGPT or Microsoft 365 Copilot. It signs in as the person asking, uses their Business Central permissions, and links every answer back to the records behind it.
Questions
Can I change the period it looks at?
Yes. Ask for a different window, anywhere from 30 days to two years. The default is the last 365 days.
Can it write the stock off?
No. It only reads. Any adjustment or write-off stays in Business Central.
Can I check one item or location?
Yes. Name the item or the location in your question.
Ask this about your own stock in Business Central.