/
/
Audit a vendor's payables and 1099 setup in one answer
For accounts payable teams who want a vendor's balance, payments and 1099 gaps without opening three Dynamics GP screens.
On this page
Connector
Connect PowerGP Online, pick your AI tool and paste the prompt.
The problem
One vendor check means three screens and a 1099 surprise
To check one vendor, accounts payable opens the vendor inquiry, then payment history, then the 1099 screens in Dynamics GP. A missing tax ID or blank 1099 type slips past across three screens and only shows up when the forms are due.
Without PopdockAI
- Open the vendor inquiry for the balance
- Switch to payment history for applied payments
- Check the 1099 screens for the year
- Find the missing tax ID when forms are due
With PopdockAI
- The vendor matched in Dynamics GP, with a stop if several match
- Open and closed payables and applied payments read together
- The year's 1099 rows totalled in the same summary
- A missing tax ID reported only when the 1099 rows show it
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a full picture of vendor `{vendor}` in `{company}` (default company if empty): balance, open documents, payment history and 1099 setup for year `{year}` (default current calendar year).
**Step 1: Find the vendor**
Call `powergp-online-get-vendors` with `vendor-id` equal to `{vendor}`. If nothing matches, call it again with `vendor-name.contains` set to `{vendor}`. If more than one vendor matches, list them (id, name, balance) and stop.
**Step 2: Open and recent documents**
Call `powergp-online-get-payablestransactions` with the vendor id. Separate open documents (unapplied amount above zero) from closed ones, and note any past `due-date`.
**Step 3: Payments applied**
Call `powergp-online-get-payablesapply` with the vendor id to see which payments were applied to which documents.
**Step 4: 1099**
Call `powergp-online-get-payables1099transactions` with the vendor id and `document-date.from` and `document-date.to` set to the year. Report whether `tax-id-number` is present, the 1099 type, and the total document amount.
**Step 5: Report**
Give: vendor header (id, name, class, balance, last invoice, last payment), open documents table, payments summary, 1099 total and any gaps (missing tax id, 1099 type blank on a document).
**Rules & Guidelines:**
* This prompt is read-only. Only the get tools on this server exist; never try to change, post, approve, release or delete anything in Dynamics GP.
* Do not call customer or receivables tools.
* Only report a missing tax id when the 1099 call returned rows with it blank; do not guess otherwise.
**Validation:**
* If the vendor has no 1099 rows, say so rather than implying a problem.Who it's for
One answer, three teams that use it
Accounts payable
Answer what we owe a vendor in one reply
Balance, open documents and payments come back together, without opening three inquiry screens.
What do we owe Fabrikam Freight in Dynamics GP and what have we paid them this year?
Tax and compliance
Find 1099 gaps before the forms are due
See the 1099 total for the year and whether the tax ID is really missing, well before year end.
Is the 1099 information for Northwind Consulting complete for 2026 in our GP company?
Controllers
Review key vendors ahead of year end
Check balance, payments and 1099 status for a vendor in one read-only summary before you close the year.
Audit Contoso Logistics for 2026: open payables, payments applied and 1099 total.
How it works
What PopdockAI does when you ask
You name a vendor and a year and your AI assistant reads PowerGP Online for you. It stops if several vendors match and changes nothing in Dynamics GP.
01
Ask
You name a vendor and a year.
02
Match
It finds the vendor in Dynamics GP and stops if several match.
03
Read
It reads open payables, applied payments and 1099 rows for the year.
04
Report
It summarizes balance, documents, payments and any missing tax ID.
What PopdockAI provides
The tools behind the answer
Ready made tools for PowerGP Online and one secure connection to your AI tool. No code, no exports.
powergp-online-get-vendors
powergp-online-get-payablestransactions
powergp-online-get-payablesapply
powergp-online-get-payables1099transactions
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
A vendor's balance and 1099 gaps in one 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)
