Connectors

/

PowerGP Online

/

Profile a PowerGP Online customer account
Report

Answer customer questions from one account profile

For support and account managers who want a customer's balance, orders and contacts by asking their AI assistant.

Try PopdockAI free
Get a live demo
Profile a PowerGP Online customer account
Give me a full account profile for Fabrikam Industries in our Dynamics GP company.
Fabrikam Industries has a balance due of 24,300.00, with 9,800.00 overdue. - Contact: Alex Rivera, two ship-to addresses on file - Salesperson: Jordan Lee, Central territory - Overdue: 2 invoices, oldest 47 days past due - Orders: 14 sales documents in the last 12 months Want the list of overdue invoices?
PowerGP Online
Sample figures. Your results come from your own account.
powergp-online-get-customers
powergp-online-get-customeraddresses
powergp-online-get-salespeople
powergp-online-get-receivablestransactions
powergp-online-get-salesdocuments

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

One customer question means four Dynamics GP screens

When a customer asks about a balance, an order or their contact, support opens the customer card, addresses, receivables and sales documents in turn. Each screen answers part of the question, and the full picture takes minutes to build.

Without PopdockAI

  • Open the customer card and the addresses
  • Look up the salesperson on another screen
  • Check receivables for open and overdue items
  • Pull sales documents for the last year

With PopdockAI

  • The customer matched, with a stop if several match
  • Addresses, salesperson, receivables and orders read together
  • Overdue items called out and up to three observations
  • Only name, ID and territory for the salesperson

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Build a complete account profile for customer `{customer}` in `{company}` (default company if empty).

**Step 1: Find the customer**

Call `powergp-online-get-customers` with `customer-number` equal to `{customer}`. If nothing matches, retry with `customer-name.contains`. If more than one matches, list them (number, name, balance due) and stop.

**Step 2: Addresses and salesperson**

Call `powergp-online-get-customeraddresses` with the customer number, then `powergp-online-get-salespeople` with `salesperson-id` from Step 1.

**Step 3: Receivables**

Call `powergp-online-get-receivablestransactions` with the customer number. Split open items from paid, and list those with `days-past-due` above zero.

**Step 4: Orders**

Call `powergp-online-get-salesdocuments` with the customer number and `document-date.from` set to a year ago. Summarize by type and total.

**Step 5: Report**

Sections: identity and contact, addresses, salesperson, balance position, overdue items, 12 month order summary. Close with up to three observations such as a rising overdue balance or no orders in 90 days.

**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 payables, payroll or purchasing tools.
* For the salesperson show name, id and territory only.

**Validation:**

* If any call returns nothing, write "none found" for that section.

Who it's for

One answer, three teams that use it

Support agents

Answer balance and order questions fast

See what a customer owes and what they ordered recently without switching between screens.

What is the balance and recent order history for customer CONTOSO001?

Account managers

Prepare for a review in one read

A 12 month order summary and overdue items give you the talking points before the meeting.

Profile Northwind Traders in Dynamics GP before my quarterly review with them.

Credit analysts

Spot a rising overdue balance

Observations call out trends such as a growing overdue balance, so you can act early.

Is Fabrikam's overdue balance growing, and who is their salesperson?

How it works

What PopdockAI does when you ask

You give a customer number or name and your AI assistant builds the profile from PowerGP Online. It stops if several customers match and never changes a record.

01

Ask

You give a customer number or name.

Your AI tool

02

Match

It finds the customer in Dynamics GP and stops if several match.

powergp-online-get-customers

03

Read

It reads addresses, salesperson, receivables and recent orders.

powergp-online-get-customeraddresses
powergp-online-get-salespeople
powergp-online-get-receivablestransactions
powergp-online-get-salesdocuments

04

Report

It shows the profile, overdue items and up to three observations.

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-customers

Returns customers 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-customeraddresses

Returns customer addresses 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-salespeople

Returns salespeople 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-receivablestransactions

Returns receivables transactions 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-salesdocuments

Returns sales documents 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

Customer questions answered from one profile

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