/
/
Check Business Central items against AvaTax tax codes
For operations teams who want to know which Business Central items are missing or mis-coded in Avalara AvaTax, just by asking.
On this page
Connector
Connect Avalara AvaTax, pick your AI tool and paste the prompt.
The problem
Item masters and the tax catalogue drift apart
Business Central item masters are checked against the Avalara AvaTax catalogue by exporting both lists and comparing them. Items missing from AvaTax, or carrying a missing or inactive tax code, are easy to overlook.
Without PopdockAI
- Export items from Business Central
- Export the AvaTax item catalogue
- Compare the two lists by hand
- Overlook missing or inactive tax codes
With PopdockAI
- Business Central items are listed and blocked ones set aside
- Each item is looked up in AvaTax, up to 25 at a time
- Missing items and tax code problems are reported
- Nothing is changed in either system
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For Business Central items matching `{item-filter}` (an item category code, or empty for all), show whether each item exists in Avalara AvaTax and which tax code it carries.
**Step 1: List the items in Business Central**
Call `business-central-get-item`. If `{item-filter}` is not empty, set `item-category-code` to it. Keep `item-number`, `description`, `type` and `blocked`. Drop items whose `type` is not an inventory or service item you can sell, and say how many you dropped.
**Step 2: Look each item up in Avalara AvaTax**
For each item, call `avalara-avatax-get-item` with `item-code` set to the Business Central `item-number`. Keep `item-code`, `tax-code`, `description` and `upc`. Check at most the first 25 items; if there are more, say the rest were not checked.
**Step 3: Look up the tax codes**
For each distinct `tax-code` found, call `avalara-avatax-get-tax-code` with `tax-code` set to it and keep its `description` and `active`.
**Step 4: Report**
List items missing from AvaTax. For items present, list item number, description, AvaTax tax code and tax code description. Flag items with no tax code, items whose tax code is not active, and items whose descriptions differ markedly between the two systems. Compare Business Central `gtin` with AvaTax `upc` where both are present.
**Rules & Guidelines:**
* Tools whose names start with avalara-avatax- are on the avalara-avatax MCP server; tools whose names start with business-central- are on the business-central MCP server. Both servers must be connected.
* This prompt is read-only. Never call any create, update, delete, add, void, commit, adjust, refund 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 `business-central-get-item` returns nothing, say so and stop.
* A blocked Business Central item missing from AvaTax is low priority; list it separately.Who it's for
One answer, three teams that use it
Inventory managers
Make new items tax ready
Check that newly added Business Central items exist in AvaTax with an active tax code.
Check our newest 25 Business Central items for Fabrikam in AvaTax.
Tax analysts
Find items that will be taxed wrongly
Items with missing or inactive codes are reported, so you fix them before they are sold.
Which Business Central items for Contoso have an inactive tax code in Avalara AvaTax?
ERP administrators
Check the item sync between systems
Items missing from AvaTax show where the catalogue sync has gaps, with blocked items kept apart.
Which Business Central items for Northwind Traders are missing from AvaTax?
How it works
What PopdockAI does when you ask
You say which items to check and your AI assistant looks each one up in AvaTax. It works in batches of 25, says so, and changes nothing.
01
Ask
You say which Business Central items to check.
02
Read
It lists the items and sets blocked ones aside.
03
Look up
It looks each item up in AvaTax, up to 25 at a time.
04
Report
You get missing items and tax code problems.
What PopdockAI provides
The tools behind the answer
Ready made tools for Avalara AvaTax and one secure connection to your AI tool. No code, no exports.
avalara-avatax-get-item
avalara-avatax-get-tax-code
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
Tax code gaps found without exports
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)
