Connectors

/

PowerGP Online

/

Review PowerGP Online overdue receivables
Report

Know which customers to chase first, today

For collections and finance teams who want overdue receivables ranked by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review PowerGP Online overdue receivables
Which customers should we chase first? Look at anything more than 45 days past due in our Dynamics GP company.
Nine customers are more than 45 days past due, 86,400.00 in total. - 1. Northwind Traders: 31,200.00, oldest 92 days - 2. Fabrikam Industries: 18,750.00, oldest 61 days - 3. Adventure Works: 12,300.00, oldest 55 days - Contoso Ltd has a recent payment not applied to its oldest invoice Want the full table by aging bucket?
PowerGP Online
Sample figures. Your results come from your own account.
powergp-online-get-receivablestransactions
powergp-online-get-customers
powergp-online-get-receivablesapply

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

The chase list is stale before collections even starts

Collections staff export an aging report from Dynamics GP and then check each customer by hand for balance and recent payments. By the time the list is ready it is stale, and customers with real exposure are easy to miss.

Without PopdockAI

  • Export an aging report from Dynamics GP
  • Look up each customer's balance and contact
  • Check whether recent payments were applied
  • Work from a list that is already out of date

With PopdockAI

  • Open receivables past your threshold read live
  • Balance, salesperson and contact added for the top ten
  • Recent payments checked against older documents
  • No adding across currencies, 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:** Review overdue receivables in `{company}` (default company if empty) and recommend which customers to chase first, looking at documents at least `{min-days-past-due}` days past due (default 30).

**Step 1: Pull open receivables**

Call `powergp-online-get-receivablestransactions` with `company` set to `{company}` when given and `due-date.to` set to today minus the days threshold. Keep rows where `unapplied-amount` is above zero. Set `max-records` to 500.

**Step 2: Add customer context**

For the 10 customers with the largest overdue total, call `powergp-online-get-customers` with `customer-number` and read `balance-due`, `salesperson` and `contact-person`. Then call `powergp-online-get-receivablesapply` with `customer-number` to see whether recent payments were applied to older documents.

**Step 3: Report**

Give a table: customer number, customer name, overdue total, oldest days past due, number of open documents, balance due. Group by aging bucket (31-60, 61-90, 90+). Finish with a ranked chase list of at most 10 customers and one sentence of reasoning each.

**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 tools for this job.
* Amounts are in the document currency; if `currency-id` varies, say so instead of summing across currencies.
* If the call hit the 500 record limit, say the totals are partial.

**Validation:**

* If no rows come back, say no receivables are past due at that threshold and stop.
* If a customer name appears under more than one customer number, report the numbers separately.

Who it's for

One answer, three teams that use it

Collections specialists

Know who to call first today

Up to ten customers ranked with one sentence of reasoning each, from live data.

Who should I chase first today for anything more than 60 days past due?

Credit managers

See overdue by aging bucket

Open receivables grouped by bucket show where the overdue money sits.

Group our overdue receivables over 30 days by aging bucket in the Contoso company.

Controllers

Check payments landed on the right invoices

Recent payments applied to older documents are checked for the worst customers, so the ranking is fair.

For the customers most past due, were recent payments applied to their oldest invoices?

How it works

What PopdockAI does when you ask

You choose how many days past due to look at and your AI assistant reads PowerGP Online. It stops if nothing is overdue and says when results are partial.

01

Ask

You choose a days past due threshold, or use the default.

Your AI tool

02

Read

It pulls open receivables past the threshold.

powergp-online-get-receivablestransactions

03

Enrich

It adds balance, contact and recent payment history for the worst customers.

powergp-online-get-customers
powergp-online-get-receivablesapply

04

Report

It groups by aging bucket and ranks up to ten customers to chase.

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

Returns receivables applications 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

A current, ranked chase list every morning

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