Connectors

/

Microsoft Dynamics GP

/

Review a Dynamics GP customer account
Report

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.

Try PopdockAI free
Get a live demo
Review a Dynamics GP customer account
Review the Fabrikam account in Dynamics GP before my meeting on Friday.
Fabrikam is in good standing but has one late order and an open service call. - Balance: 18,600 open, 2,300 overdue, average 34 days to pay - Sales: 6 invoices and 1 return in 90 days - Late: order ORD-1042 is 5 days past its ship date - Service: 1 open call on an SD-200 dock Want the three points to raise in the meeting?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
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

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics GP

Microsoft Dynamics GP
Run it on your own Microsoft Dynamics GP data.

Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Read

It reads credit standing, balances, payments and average days to pay.

microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-trx-apply

03

Gather

It adds sales documents, late orders, projects, service calls and contracts.

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

04

Report

You get the review with three points worth raising.

Your AI tool

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.

get-data

microsoft-dynamics-gp-get-rm-customer

Returns customer records from Dynamics GP Receivables Management, including contact details, class, terms and balances. Filter by salesperson ID, hold, customer name, state, zip, customer balance, customer class and city, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-trx

Returns receivables transactions such as invoices, payments and credit memos from Dynamics GP Receivables Management, including customer, dates, amounts and outstanding balances. Filter by customer ID, document type, customer name, document date, document amount, document number, batch number and void status, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-trx-apply

Returns receivables apply records from Dynamics GP Receivables/Sales, showing which payments and credits were applied to which invoices and for how much. Filter by customer name, document date, amount applied, document number, document type, applied to document type, customer ID and applied to document number, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-sales-trx

Returns Sales Order Processing documents such as quotes, orders and invoices from Dynamics GP Sales, with the customer, dates, salesperson and document totals. Filter by batch number, customer ID, SOP type, SOP number, salesperson ID, document amount, customer name and document date, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-pa-project

Returns project records from Dynamics GP Project Accounting, with the customer, contract, manager, status and forecast and actual cost and billing totals. Filter by status, actual begin date, actual total cost, contract number, project name, project type, project number and project manager ID, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-srv-service-call

Returns service call records from Dynamics GP Field Service, including customer, service type, status, technician, priority and totals. Filter by total, service type, customer ID, office ID, service call status, name, priority level and service call number, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-srv-contract

Returns service contracts from Dynamics GP Field Service, with customer, contract dates, billing cycle and status, and contract totals. Filter by customer name, status, contract record type, contract type, start date, total, contract number and customer ID, and pick the company and the maximum number of records.
Read only.Nothing in Microsoft Dynamics GP 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 customer meeting, fully informed

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