Connectors

/

Microsoft Dynamics 365 Business Central

/

Dynamics 365 Business Central purchase spend report
Report

See where your purchase money goes and how concentrated it is

For finance teams who want net purchase spend by vendor and by what was bought, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Dynamics 365 Business Central purchase spend report
Give me a purchase spend report from Business Central for last quarter.
Net purchase spend last quarter was 1.82 million USD across 640 invoices. - Top vendor: Fabrikam, 410,000, 22.5 percent - Top five vendors: 61 percent of spend - Top account: 5100 Raw Materials, 720,000 - One-off vendors: 37 used only once Want the top 15 vendors table?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
No items found.

On this page

The problem

The problem

The prompt

Who it's for

How it works

Connector

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central
Run it on your own Microsoft Dynamics 365 Business Central data.

Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Purchase spend is hard to see without a manual export

Understanding purchase spend means netting posted invoices against credit memos and grouping by vendor and by what was bought. In Business Central that is a manual export, and concentration with a few vendors is hard to see.

Without PopdockAI

  • Export posted purchase invoices and credit memos
  • Net them in a spreadsheet
  • Pivot by vendor, item and account
  • Work out vendor concentration by hand

With PopdockAI

  • Posted invoices and credit memos are netted by vendor
  • Lines are grouped by type, item and G/L account
  • Top vendors, their share and one time suppliers are listed
  • Each currency gets its own table, and nothing is changed

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Report net purchase spend between `{start-date}` and `{end-date}` (default the current month to date), by vendor and by what was bought.

Pass `{company}` as the company argument on every call. If `{company}` is empty, leave the company argument out so the connector's default company is used.

**Step 1: Posted invoices and credits**

Call `business-central-get-posted-purchase-invoice` and `business-central-get-posted-purchase-credit-memo` with posting-date.from `{start-date}` and posting-date.to `{end-date}`. Raise max-records to 1000.

**Step 2: By vendor**

Net spend = invoice amount minus credit memo amount (excluding tax), grouped by buy-from-vendor-number.

**Step 3: By what was bought**

Call `business-central-get-posted-purchase-invoice-line` with the same dates. Group amount by type (item, G/L account, resource, fixed asset, charge) and then by number and description. Call `business-central-get-posted-purchase-credit-memo-line` and subtract.

**Step 4: Concentration**

Work out the share of spend with the top five vendors, and list vendors with only one invoice in the period.

**Step 5: Report**

* Headline: net spend, invoice count, credit total
* Top 15 vendors: vendor, invoices, net spend, share
* Spend by line type, then top 10 items and top 10 G/L accounts
* Concentration: top-five share and one-off vendors

**Rules & Guidelines:**

* This prompt is read-only. Do not call any tool named business-central-create-* or business-central-update-*.
* Keep one table per currency if several appear.

**Validation:**

* If there are no invoices in the period, say so and stop.

Who it's for

One answer, three teams that use it

Procurement managers

Prepare for supplier negotiations

See top vendors and their share of spend before you sit down to negotiate.

Show me our top vendors by net purchase spend in Business Central this year.

Controllers

Watch vendor concentration

The share held by the top five vendors shows how dependent you are on a few suppliers.

How concentrated was our purchase spend in Business Central last quarter?

FP and A analysts

Explain spend by item and account

Spend grouped by item and G/L account gives you the detail behind cost lines.

Break down Business Central purchase spend for October by item and G/L account.

How it works

What PopdockAI does when you ask

You give a period and your AI assistant reads posted purchase documents from Business Central and nets the spend. It reports only.

01

Ask

You give a period, month to date by default.

Your AI tool

02

Read

It reads posted purchase invoices and credit memos.

No items found.

03

Group

It nets spend by vendor, line type, item and G/L account.

No items found.

04

Report

You get a headline, top vendors with share and concentration.

Your AI tool

The outcome

Know where purchase money goes

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation