/
/
Find Business Central invoices that never reached AvaTax
For finance teams who want to know which posted Business Central invoices have no Avalara AvaTax transaction, just by asking.
On this page
Connector
Connect Avalara AvaTax, pick your AI tool and paste the prompt.
The problem
Invoices that never reached the tax engine
Posted Business Central invoices that never reached Avalara AvaTax go uncommitted for tax. Finding them means comparing two long lists by eye.
Without PopdockAI
- Export posted sales invoices from Business Central
- Export AvaTax transactions for the same dates
- Compare the two lists by eye
- Call an invoice missing when it was filed under another code
With PopdockAI
- Posted invoices and AvaTax transactions are read for the range
- Probable matches under a different code are set aside
- Invoices with no transaction and transactions with no invoice are listed
- Truncated results come with a request for a narrower range
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find posted Business Central sales invoices dated from `{from-date}` to `{to-date}` that have no matching Avalara AvaTax transaction, optionally for customer `{customer-number}`.
**Step 1: List the invoices in Business Central**
Call `business-central-get-posted-sales-invoice` with `posting-date.from` set to `{from-date}` and `posting-date.to` set to `{to-date}`. If `{customer-number}` is not empty, also set `sell-to-customer-number` to it. If the result is truncated by `max-records`, say so and ask for a narrower range.
**Step 2: List the transactions in Avalara AvaTax**
Call `avalara-avatax-get-transaction` with `date.from` set to `{from-date}` and `date.to` set to `{to-date}`. If `{customer-number}` is not empty, set `customer-code` to it. Do not filter on `document-type`; keep each transaction's `code`, `document-type`, `status`, `total-amount` and `total-tax`.
**Step 3: Match**
Match each invoice `invoice-number` against the AvaTax `code`. For an invoice with no code match, look for a transaction with the same `customer-code` and `total-amount`, and report it as a probable match under a different code.
**Step 4: Report**
Give counts: invoices checked, matched, probable matches, missing. Then list the missing invoices with number, posting date, customer, `total-amount` and invoice tax (`total-amount-including-tax` minus `total-amount`). Also list AvaTax transactions in the range that match no invoice.
**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 either side returns nothing, say so and report the other side only.
* Invoices posted with no tax may legitimately have no AvaTax transaction; flag zero-tax invoices separately.Who it's for
One answer, three teams that use it
Tax accountants
Make sure every invoice is committed
Invoices with no AvaTax transaction are listed, so tax is recorded before filing.
Which Business Central sales invoices posted in October are missing from Avalara AvaTax?
Controllers
Close the period with confidence
Both directions are checked, so you also see AvaTax transactions with no matching invoice.
Show AvaTax transactions from last month with no posted Business Central invoice.
ERP administrators
Find integration gaps
Missing invoices and probable mismatches point to where the integration needs attention.
Compare posted Business Central invoices for the first week of November with AvaTax and list probable matches.
How it works
What PopdockAI does when you ask
You give a date range and your AI assistant compares posted invoices with AvaTax transactions. Probable matches are reported separately and nothing is written to either system.
01
Ask
You give a date range.
02
Read
It reads posted Business Central sales invoices and the AvaTax transactions for the range.
03
Match
It matches them, setting probable matches under a different code aside.
04
Report
You get invoices with no transaction and transactions with no invoice.
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-transaction
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
Find invoices missing from AvaTax
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)
