/
/
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.
On this page
Connector
Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.
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.
**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.
02
Read
It reads posted sales invoices and credit memos.
03
Compare
It nets sales and margin and reads the prior period for comparison.
04
Report
You get top customers, salespeople, items and lapsed customers.
The outcome
Period over period sales without the spreadsheet
Related use cases
More ways to put this data to work
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.

.webp)
