Connectors

/

Microsoft Dynamics 365 Business Central

/

Dynamics 365 Business Central sales performance report
Report

Get a period-over-period sales report without building it

For sales leaders who want net sales by customer, salesperson and item against the prior period, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Dynamics 365 Business Central sales performance report
How did sales go in Business Central last month compared with the month before?
Net sales last month were 1.24 million USD, up 8 percent. - Top customer: Contoso, 186,000, up 22 percent - Top salesperson: Sam Patel, 412,000 - Top item: Trail Jacket, 2,300 units, estimated margin 49 percent - Lapsed: 6 customers bought last period but not this one Want the lapsed customer list?
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

Monthly sales reports still get built by hand

Sales reviews need net sales by customer, salesperson and item, compared with the previous period. In Business Central that means exporting invoices and credit memos, netting them and working out margins by hand every month.

Without PopdockAI

  • Export posted invoices and credit memos
  • Net them by customer, salesperson and item
  • Work out margin from unit costs
  • Repeat it all for the prior period

With PopdockAI

  • Posted invoices and credit memos are netted
  • Estimated margin is shown where unit cost is recorded
  • The prior period is read for comparison
  • Lapsed customers are listed, 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 sales between `{start-date}` and `{end-date}` (default the current month to date), by customer, by salesperson and by item.

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-sales-invoice` with posting-date.from `{start-date}` and posting-date.to `{end-date}`. Call `business-central-get-posted-sales-credit-memo` with the same dates. Raise max-records to 1000 on both and say if either hits the limit.

**Step 2: Net sales**

Net sales = invoice total-amount minus credit memo total-amount (amounts excluding tax). Group by sell-to-customer-number and by salesperson-code.

**Step 3: Items**

Call `business-central-get-posted-sales-invoice-line` and `business-central-get-posted-sales-credit-memo-line` with the same posting dates and line-type Item. Net quantity and amount by number. Where unit-cost is present on invoice lines, estimate margin as amount minus quantity times unit-cost.

**Step 4: Comparison**

Repeat Step 1 for the same length of period immediately before, and show the change.

**Step 5: Report**

* Headline: net sales, change against the prior period, number of invoices, credits as a share of sales
* Top 10 customers by net sales with change
* Sales by salesperson
* Top 10 items by amount, with quantity and estimated margin
* Customers who bought in the prior period but not this one

**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

Sales directors

Run the monthly review without prep

Top customers, salespeople and items against last period are ready in one answer.

Compare Business Central net sales this quarter with last quarter by salesperson.

Account managers

Spot customers who stopped buying

Customers who bought last period but not this one are listed, so you can win them back.

Which customers bought from us in Business Central last month but not this month?

Finance analysts

See net sales and margin by item

Item sales are netted by quantity and amount, with estimated margin where cost is recorded.

Give me Business Central net sales and estimated margin by item for October.

How it works

What PopdockAI does when you ask

You give a period and your AI assistant builds a period over period sales report from Business Central. It says when results hit the read limit and changes nothing.

01

Ask

You give a period, month to date by default.

Your AI tool

02

Read

It reads posted sales invoices and credit memos.

No items found.

03

Compare

It nets sales and margin and reads the prior period for comparison.

No items found.

04

Report

You get top customers, salespeople, items and lapsed customers.

Your AI tool

The outcome

Period over period sales without the spreadsheet

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