/
/
See Dynamics GP customers in states with no AvaTax nexus
For tax managers who want to check a state's nexus in Avalara AvaTax against the Dynamics GP customers there, just by asking.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
The problem
Sales into states with no nexus are found too late
Checking where Dynamics GP customers are located against the states where you have nexus in Avalara AvaTax is a manual cross check. Sales into states with no registration are often found only after the fact.
Without PopdockAI
- Look up nexus for the state in Avalara AvaTax
- Filter Dynamics GP customers by state
- Pull recent sales and tax for the largest customers
- Treat an ended nexus the same as an active one
With PopdockAI
- Nexus for the state is checked, with ended nexus treated separately
- Dynamics GP customers in that state are listed
- The largest customers show recent sales and tax collected
- No tax advice is given 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:** List the Dynamics GP customers in state `{state}` and report whether Avalara AvaTax shows tax nexus for that state, so the user can see where sales may be going to a jurisdiction the company has not registered in. If `{country}` is empty, use US.
**Step 1: Check nexus in Avalara AvaTax**
Call `avalara-avatax-get-nexus` with `region` set to `{state}` and `country` set to `{country}` (US if empty). Keep `jurisdiction-name`, `nexus-type`, `tax-type-group`, `effective-date` and `end-date`. Treat a nexus record whose `end-date` is in the past as ended. Say plainly whether the state has active nexus, ended nexus, or none.
**Step 2: List the customers in Dynamics GP**
Call `dynamics-gp-get-rm-customer` with `state` set to `{state}` and `inactive` set to false. Keep `customer-id`, `customer-name`, `city` and `customer-balance`. Then call `dynamics-gp-get-rm-sales-trx` for the five customers with the highest `customer-balance`, using `customer-id` and a `document-date.from` of 12 months ago, to show their recent sales and `tax-amount`.
**Step 3: Report**
State the nexus finding first, then the customer count, the five largest customers with their 12-month document totals and tax collected, and a one-line note on whether tax was collected where no active nexus exists.
**Rules & Guidelines:**
* Tools whose names start with avalara-avatax- are on the avalara-avatax MCP server; tools whose names start with dynamics-gp- are on the dynamics-gp MCP server. Both servers must be connected.
* This prompt is read-only. Never call any create, update, delete, add, void, commit, adjust, post or other action tool on either server.
* Report what the two systems show. Do not present results as tax advice or as a filed return.
**Validation:**
* If AvaTax has no nexus record for the state, say that no nexus is on record; do not say the company has no obligation.
* If Dynamics GP has no customers in the state, say so and stop after the nexus finding.Who it's for
One answer, three teams that use it
Tax managers
Check a state before it becomes a problem
See the nexus on record and the customers you sell to in a state, with recent sales and tax, in one answer.
Do we have nexus in Avalara AvaTax for Colorado, and which Dynamics GP customers are there?
Finance controllers
Size the exposure in a state
The largest customers' recent sales and tax collected give you a starting figure for any review with your advisers.
Show recent sales and tax collected for our biggest Dynamics GP customers in Tennessee and the AvaTax nexus status.
Sales operations
Know the tax picture for a new territory
Before expanding in a state, check what nexus is on record and who you already sell to there.
We are expanding in Georgia. What nexus do we have in Avalara AvaTax and which GP customers are already there?
How it works
What PopdockAI does when you ask
You name a state, and your AI assistant checks Avalara AvaTax nexus and lists your Dynamics GP customers there with their recent sales. It reports the facts and gives no tax advice.
01
Ask
You name the state to check.
02
Check
It looks up AvaTax nexus for that state and treats ended nexus separately.
03
List
It lists the Dynamics GP customers located there.
04
Report
You get the largest customers with recent sales and tax collected.
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.
avalara-avatax-get-nexus
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-sales-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
Nexus reviews that start from facts, not a hunch
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)
