/
/
Prepare sales tax from a checked summary
For finance teams who want Dynamics GP sales and purchase tax totalled by tax detail with anomalies flagged, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
The problem
Odd tax lines slip into the filing
Preparing a sales tax return from Dynamics GP means totalling taxable amounts and tax by tax detail, then hunting for lines that look wrong. Zero tax on taxable sales or a line posted outside the period can slip into the filing.
Without PopdockAI
- Export tax detail lines for the period
- Remove voided rows
- Total taxable amount and tax by detail for sales and purchases
- Scan for odd rates and lines in the wrong period
With PopdockAI
- Tax lines are read, leaving voided rows out
- Sales and purchases are grouped by tax detail with effective rates
- Missing tax, odd rates and out of period lines are flagged
- Labelled a working summary, with nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Summarise sales and purchase tax by tax detail for `{from-date}` to `{to-date}`, ready to check against a tax return.
Pass `{company}` as `company` on every call (if it is empty, omit `company` and the default company is used). Pass a generous `max-records` (1000). If a result comes back with exactly that many rows, say the result may be truncated.
**Step 1: Tax lines**
Call `dynamics-gp-get-cmp-tax-detail-trx` with `document-date.from` and `document-date.to`. Drop rows where `voided` is set.
**Step 2: Summarise**
Group by `tax-detail-type` (sales or purchases) and then `tax-detail-id` (with `tax-detail-description`). For each: document count, `taxable-sales-purchases`, `total-sales-purchases`, `tax-amount`, and the effective rate (tax divided by taxable).
**Step 3: Anomalies**
* Tax lines with tax but zero taxable amount, or taxable amount but zero tax.
* Lines whose effective rate differs from the tax detail's usual rate by more than half a percentage point.
* Lines posted (`posting-date`) outside the period although dated inside it, or the reverse.
* Tax posted to more than one `account-number` for the same tax detail.
**Step 4: Report**
Two tables (sales, purchases) with the Step 2 columns and totals, then net tax (sales tax minus purchase tax), then the anomalies with document number, series, customer or vendor id and amounts.
**Rules & Guidelines:**
* This prompt is read-only. Do not call any tool whose name does not contain `get` (no add, update, note or email tools).
* This is a working summary, not a filed return. Say so at the top.
**Validation:**
* If no tax lines fall in the period, say so and stop.Who it's for
One answer, three teams that use it
Tax accountants
Prepare the return from clean totals
Taxable amounts, tax and net tax by detail give you the numbers to prepare the filing.
Summarize Dynamics GP sales and purchase tax for October by tax detail.
Controllers
Review anomalies before filing
Lines with tax and no taxable amount, odd rates or wrong periods are flagged for a look.
Flag any odd sales tax lines in Dynamics GP for Q2 before we file.
Staff accountants
Check tax posted to the right account
Tax posted to more than one account is flagged, so the ledger and the return agree.
Is any Dynamics GP sales tax for September posted to more than one account?
How it works
What PopdockAI does when you ask
You give a date range, and your AI assistant builds a checked tax summary from Dynamics GP. It is a working summary for preparing the return, and nothing is changed.
01
Ask
You give a date range.
02
Read
It reads tax lines, leaving voided rows out.
03
Summarize
It groups sales and purchases by tax detail with effective rates and net tax.
04
Report
You get a working summary with anomalies flagged, not a filed return.
What PopdockAI provides
The tools behind the answer
Ready made tools for Microsoft Dynamics GP and one secure connection to your AI tool. No code, no exports.
microsoft-dynamics-gp-get-cmp-tax-detail-trx
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Returns prepared from a checked summary
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)
