Connectors

/

Microsoft Dynamics GP

/

Check Dynamics GP customer states against Avalara AvaTax nexus
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check Dynamics GP customer states against Avalara AvaTax nexus
Check Avalara AvaTax nexus for Oregon and show me our Dynamics GP customers there.
No active nexus is on record in AvaTax for Oregon, and 14 GP customers are located there. - Largest: Contoso Ltd, 48,200.00 in sales, 0.00 tax collected - Next: Fabrikam Inc, 31,750.00 in sales, 0.00 tax collected - Nexus status: none on record, which is not a finding of no obligation Should I list all 14 customers? Please confirm obligations with a tax advisor.
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
avalara-avatax-get-nexus
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-sales-trx

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics GP

Microsoft Dynamics GP
Run it on your own Microsoft Dynamics GP data.

Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Check

It looks up AvaTax nexus for that state and treats ended nexus separately.

avalara-avatax-get-nexus

03

List

It lists the Dynamics GP customers located there.

microsoft-dynamics-gp-get-rm-customer

04

Report

You get the largest customers with recent sales and tax collected.

Your AI tool

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.

get-data

avalara-avatax-get-nexus

Returns Avalara AvaTax nexus declarations with the filters the tool offers, for the selected AvaTax company. Read-only.
get-data

microsoft-dynamics-gp-get-rm-customer

Returns customer records from Dynamics GP Receivables Management, including contact details, class, terms and balances. Filter by salesperson ID, hold, customer name, state, zip, customer balance, customer class and city, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-sales-trx

Returns Sales Order Processing documents such as quotes, orders and invoices from Dynamics GP Sales, with the customer, dates, salesperson and document totals. Filter by batch number, customer ID, SOP type, SOP number, salesperson ID, document amount, customer name and document date, and pick the company and the maximum number of records.
Read only.Nothing in Microsoft Dynamics GP Changes

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.

How Popdock AI secures your data

The outcome

Nexus reviews that start from facts, not a hunch

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