---
id: post/olofsimren-com/3585
type: post
title: Copilot Inventory Queries
summary: Copilot Inventory Queries is a free AppSource extension the author built to answer natural language inventory questions in Business Central, such as reorder points, replenishment timing and demand trends, with explanations. It sends the user question plus JSON inventory data like item ledger entries and open orders to an Azure OpenAI model, guided by a system prompt.
tier: community
language: en
tags:
  - copilot prompts
  - azure openai
  - inventory optimization
  - ai-driven suggestions
  - inventory queries
system: copilot
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:58:57.907Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: d78b70af8ee00986ab4ffe2780d030d3d85c6f4b81fc886c8e01324af0c5cd1e
evidence:
  - kind: blog
    url: https://www.olofsimren.com/copilot-inventory-queries/
    title: Copilot Inventory Queries
    date: "2025-10-08"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://www.olofsimren.com/copilot-inventory-queries/
    title: Copilot Inventory Queries
    date: "2025-10-08"
    commit: null
    t: null
    quote: The Copilot features and the underlying AI capabilities are what get people talking when we present Business Central to customers.
  - kind: blog
    url: https://www.olofsimren.com/copilot-inventory-queries/
    title: Copilot Inventory Queries
    date: "2025-10-08"
    commit: null
    t: null
    quote: It is surprisingly simple to create, you need to learn the Copilot interface features that Microsoft provides
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "3585"
source_id: olofsimren-com
source_name: Olof Simren
url: https://www.olofsimren.com/copilot-inventory-queries/
published_at: "2025-10-08T14:01:46.000Z"
author: Olof Simren
full_text: false
words: 1001
quotes:
  - text: The Copilot features and the underlying AI capabilities are what get people talking when we present Business Central to customers.
    why_it_matters: It illustrates why Copilot is a key sales driver and customer interest point for Business Central in competitive positioning
  - text: It is surprisingly simple to create, you need to learn the Copilot interface features that Microsoft provides
    why_it_matters: It shows that building custom Copilot features is accessible to partners when they understand the available tools and interfaces
code_objects_mentioned: []
systems:
  - copilot
  - inventory
  - manufacturing
versions_mentioned: []
preview:
  embeddable: true
  frame_url: https://www.olofsimren.com/copilot-inventory-queries/embed/
  image: null
  image_alt: null
  image_w: null
  image_h: null
  site_name: null
  favicon: https://i0.wp.com/www.olofsimren.com/wp-content/uploads/2026/03/OlofSimren_512x512.png?fit=32%2C32&ssl=1
  probed_at: "2026-10-07T11:50:56.614Z"
---

# Copilot Inventory Queries

[Read the post](https://www.olofsimren.com/copilot-inventory-queries/) · Olof Simren (Olof Simren) · 2025-10-08 · 1001 words · tier community · reviewed (checked by Opus)

> Copilot Inventory Queries is a free AppSource extension the author built to answer natural language inventory questions in Business Central, such as reorder points, replenishment timing and demand trends, with explanations. It sends the user question plus JSON inventory data like item ledger entries and open orders to an Azure OpenAI model, guided by a system prompt.

## Key points

- Built with the Copilot capability tools Microsoft provides for AL; the author found it simple to create
- Needs an Azure OpenAI model from Azure AI Foundry; endpoint, deployment name and API key go in a setup table, with the API key kept in isolated storage
- A system prompt tells the model it receives Business Central inventory data plus a question and must explain its answer
- Item ledger entry data can be compressed and only relevant, configurable fields are sent to limit response time and cost
- Example queries cover reorder point and quantity, typical sales volume and reordering policy; future ideas include MRP explanations and forecasting

## Quotes

- "The Copilot features and the underlying AI capabilities are what get people talking when we present Business Central to customers." (It illustrates why Copilot is a key sales driver and customer interest point for Business Central in competitive positioning)
- "It is surprisingly simple to create, you need to learn the Copilot interface features that Microsoft provides" (It shows that building custom Copilot features is accessible to partners when they understand the available tools and interfaces)

## Context

- Features: Copilot interface for inventory questions, Azure OpenAI backend integration, Inventory data analysis, Reorder point suggestions, Demand trend analysis, Automated explanations for AI recommendations

Source: Olof Simren, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.