Copilot in Planning Parameter Worksheet
A custom extension called Planning Parameter Worksheet uses Copilot powered by Azure OpenAI to suggest inventory planning parameters for items based on ABC classification and usage data. The AI evaluates one item at a time, applies established economic formulas, and explains its parameter recommendations.
post Olof Simren
Key points
- The extension performs double ABC classification of items by transaction frequency and value, then applies rules for safety stock and reorder settings
- Business Central pre-calculates metrics like average monthly usage, standard deviation, and lead time demand before sending them to Copilot to avoid excessive data
- Copilot receives a predefined prompt instructing it to return results in JSON format with Business Central-specific period notations like ‘2W’ or ‘1M’
- The AI explains its suggestions using established theories such as economic order quantity (EOQ) formulas and service level calculations based on ABC classifications
- Processing takes about 5-7 seconds per item with a gpt-5-chat model, making bulk analysis of thousands of items time-consuming but practical
AL objects mentioned
As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.
- other “Planning Parameter Worksheet”
- other “Copilot Inventory Queries extension”
Context
- Features: Copilot-powered parameter suggestions, ABC classification (double classification), Economic order quantity calculation, Safety stock calculation, Lead time demand evaluation, Reordering policy recommendations, Automated explanation generation, JSON formatted responses
Source: Olof Simren, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.