Connectors

/

PowerGP Online

/

Compare PowerGP Online companies key figures
Report

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.

Try PopdockAI free
Get a live demo
Compare PowerGP Online companies key figures
Compare cash, payables and receivables for Northwind US, Northwind Canada and Northwind UK in Dynamics GP.
Here is the comparison for the three companies, each in its own currency. - Cash: US 410,000 USD, Canada 85,000 CAD, UK unavailable - Payables: US 132,500 USD, Canada 41,200 CAD - Receivables: US 268,900 USD, Canada 77,000 CAD - Largest vendor balance: US, Contoso Supply, 38,000 USD Want me to retry the UK company?
PowerGP Online
Sample figures. Your results come from your own account.
powergp-online-get-bankbalances
powergp-online-get-vendors
powergp-online-get-customers

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

PowerGP Online

PowerGP Online
Run it on your own PowerGP Online data.

Connect PowerGP Online, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Read

It queries each named company, one at a time, for cash, payables and receivables.

powergp-online-get-bankbalances
powergp-online-get-vendors
powergp-online-get-customers

03

Note

It records any company or figure it could not read.

No items found.

04

Report

It shows one column per company with a note on the largest balances.

Your AI tool

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.

get-data

powergp-online-get-bankbalances

Returns bank balances from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
get-data

powergp-online-get-vendors

Returns vendors from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
get-data

powergp-online-get-customers

Returns customers from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
Read only.Nothing in PowerGP Online 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

Every company's key figures side by side

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