/
/
Walk into every customer meeting fully informed
For account managers who want a Dynamics GP customer's balance, orders, projects and service in one review, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
The problem
Walking into a customer meeting half informed
Getting the full customer picture from Dynamics GP means opening receivables, payments, sales, projects, service calls and contracts one by one. It is easy to walk in without knowing about an overdue balance, a late order or an open call.
Without PopdockAI
- Check the balance and aging
- Look up recent payments and how fast they pay
- Open sales documents and late orders
- Check projects, service calls and contracts separately
With PopdockAI
- Credit standing, balances and average days to pay are read
- Sales by quote, order, invoice and return are summarized
- Late orders, projects, service calls and contracts are added
- Three points worth raising, with 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:** Give a complete picture of the customer `{customer-name}` over the last `{lookback-days}` days (default 90): their credit standing, what they owe and pay, what they have ordered, and any project or field service activity.
Pass `{company}` as `company` on every call (if it is empty, omit `company` and the default company is used). Pass a generous `max-records` (1000). If a result comes back with exactly that many rows, say the result may be truncated.
**Step 1: Resolve the customer**
Call `dynamics-gp-get-rm-customer` with `customer-name.contains` set to `{customer-name}`; if nothing matches, try `customer-id` set to `{customer-name}`. If more than one customer matches, list id, name and city and stop; ask the user which one they mean. Use the resolved `customer-id` for every later step.
From the record note: `customer-balance`, `credit-limit-amount`, `hold`, `inactive`, `payment-terms-id`, `customer-class`, `contact-person`, `phone-1`, `main-email-address`, `salesperson-id`.
**Step 2: Receivables**
Call `dynamics-gp-get-rm-trx` filtered by `customer-id`. Report the open balance (sum of `current-transaction-amount` on non-voided debit documents), the overdue part (`due-date` before today), unapplied credits, and the oldest open document. If this open balance differs noticeably from `customer-balance`, say so.
**Step 3: Payments**
Call `dynamics-gp-get-rm-trx-apply` filtered by `customer-id` with `document-date.from` at the lookback. Report the total `amount-applied`, discounts and write-offs, and average days to pay (payment `document-date` minus `applied-to-document-date`).
**Step 4: Sales activity**
Call `dynamics-gp-get-rm-sales-trx` filtered by `customer-id` with `document-date.from` at the lookback. Summarise by `sop-type` (quotes, orders, invoices, returns): count and total `document-amount`. List unposted documents (by `posting-status`) and orders whose `requested-ship-date` has passed.
**Step 5: Projects and service**
* `dynamics-gp-get-pa-project` filtered by `customer-id`: each project's status, `actual-total-cost` against `forecast-total-cost`, and `actual-billings`.
* `dynamics-gp-get-srv-service-call` filtered by `customer-id` with `entry-date.from` at the lookback: count of calls, calls still open (no `complete-date`), highest priority open call.
* `dynamics-gp-get-srv-contract` filtered by `customer-id`: active contracts, their `end-date` and `next-bill-date`.
Skip a section quietly when its tool returns nothing, and say "none" in the report.
**Step 6: Report**
Sections in this order: Account (id, name, class, terms, contact, email, phone, salesperson, credit limit, balance, hold, inactive), Receivables, Payments, Sales, Projects, Field service, then three bullet points headed "Worth raising with this customer".
**Rules & Guidelines:**
* Read-only. Do not call `dynamics-gp-rm-customer-update`, `dynamics-gp-rm-customer-note`, `dynamics-gp-rm-sales-trx-update` or any tool whose name does not contain `get`.
* A credit limit of 0 usually means no limit is set; say that rather than reporting the customer as over limit.
**Validation:**
* If Step 1 finds no customer, say so and suggest a shorter part of the name.
* If the customer is inactive, say so at the top of the report.Who it's for
One answer, three teams that use it
Account managers
Prepare for a meeting in minutes
Balance, orders, projects and service in one review, ending with points to raise.
Review the Contoso account in Dynamics GP for the last 12 months before my call tomorrow.
Credit controllers
See payment habits at a glance
Average days to pay and overdue balance show whether the account needs attention.
How quickly does Northwind Traders pay us, and what is overdue in Dynamics GP?
Service managers
Know what is open before visiting
Open service calls and active contracts are in the same review, so nothing surprises you on site.
Give me a Dynamics GP review of Fabrikam including open service calls and contracts.
How it works
What PopdockAI does when you ask
You name the customer and a lookback window, and your AI assistant pulls the account together from Dynamics GP. It flags an inactive account at the top and only reads.
01
Ask
You name the customer and a lookback window.
02
Read
It reads credit standing, balances, payments and average days to pay.
03
Gather
It adds sales documents, late orders, projects, service calls and contracts.
04
Report
You get the review with three points worth raising.
What PopdockAI provides
The tools behind the answer
Ready made tools for Microsoft Dynamics GP and one secure connection to your AI tool. No code, no exports.
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-trx-apply
microsoft-dynamics-gp-get-rm-sales-trx
microsoft-dynamics-gp-get-pa-project
microsoft-dynamics-gp-get-srv-service-call
microsoft-dynamics-gp-get-srv-contract
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 customer meeting, fully informed
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)
