/
/
Compare key figures across your Dynamics GP companies
For group finance leads who want cash, payables and receivables across companies without logging in to each one.
On this page
Connector
Connect PowerGP Online, pick your AI tool and paste the prompt.
The problem
Comparing GP companies means logging in to each one
Group finance leads log in to each Dynamics GP company in turn, read off cash, payables and receivables and paste them into a spreadsheet. It is slow, and a missed company or a mixed currency gives a comparison nobody trusts.
Without PopdockAI
- Log in to each GP company one at a time
- Read off cash, payables and receivables
- Paste the numbers into a spreadsheet
- Mix currencies or miss a company by accident
With PopdockAI
- Only the companies you name are read, one at a time
- Cash, payables and receivables in one table
- Any company or figure it could not read is marked
- Currencies kept apart, and nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare key figures across these Dynamics GP companies: `{companies}` (comma separated names), using `{currency-id}` as the only currency to total (default: report each currency separately).
**Step 1: Per company**
For each company named, one company at a time, call these with `company` set to that company:
* `powergp-online-get-bankbalances` for total cash
* `powergp-online-get-vendors` with `current-balance.min` of 0.01 for total payables owed
* `powergp-online-get-customers` with `balance-due.min` of 0.01 for total receivables owed
Record which call failed for which company.
**Step 2: Report**
One table with a column per company: cash, payables, receivables, net working position. Add a short note per company on the biggest vendor and biggest customer balance. Mark any figure that could not be read as "unavailable".
**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.
* Never combine figures from different currencies.
* Query only the companies listed; do not guess others.
**Validation:**
* If a company name is rejected, say so and carry on with the rest.
* If more than five companies are listed, ask the user to narrow the list.Who it's for
One answer, three teams that use it
Group finance leads
Compare entities without the spreadsheet
One column per company shows cash, payables and receivables, so you can see the group at a glance.
Compare cash, payables and receivables for Contoso East and Contoso West in Dynamics GP.
CFOs
See cash and obligations across the group
Get the headline balances for every company you run before a board or lender meeting.
Show me cash and what we owe and are owed for each of our three GP companies, in USD only.
Treasury managers
Spot the largest balances by company
A note on the biggest vendor and customer balance shows where cash is tied up in each entity.
Which customer and vendor balances are largest in Fabrikam US and Fabrikam UK?
How it works
What PopdockAI does when you ask
You list the companies and your AI assistant reads each one from PowerGP Online in turn. Figures it cannot read are marked rather than hidden.
01
Ask
You list the companies and optionally one currency.
02
Read
It queries each named company, one at a time, for cash, payables and receivables.
03
Note
It records any company or figure it could not read.
04
Report
It shows one column per company with a note on the largest balances.
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-bankbalances
powergp-online-get-vendors
powergp-online-get-customers
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
Every company's key figures side by side
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)
