Connectors

/

PowerGP Online

/

Check PowerGP Online inventory reorder risk
Report

Spot stock-out risk before the shelf is empty

For planners and buyers who want low items matched against open purchase orders by asking their AI assistant.

Try PopdockAI free
Get a live demo
Check PowerGP Online inventory reorder risk
Which items at the Dallas warehouse have 10 or fewer on hand and nothing coming in the next two weeks?
Three items at Dallas need attention. - Reorder now: Widget A100, 4 on hand, nothing on order - At risk: Bracket B220, 7 on hand, next supply promised in 21 days - Covered: Cable C310, 9 on hand, 200 due in 5 days Skipped 2 inactive item sites. Want the full table with current costs?
PowerGP Online
Sample figures. Your results come from your own account.
powergp-online-get-itemsitequantities
powergp-online-get-items
powergp-online-get-purchaseorders

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

Low stock is spotted after the item has already run out

Planners scan stock reports for low items, then check each one against open purchase orders to see whether anything is coming. For dozens of items that takes too long, so an item runs out before anyone raises a reorder.

Without PopdockAI

  • Scan stock reports for items under the threshold
  • Look up each item's cost and order quantity
  • Search purchase orders for a promised date
  • Raise the reorder after the shelf is empty

With PopdockAI

  • Item sites at or below your threshold found in Dynamics GP
  • Description, class and cost read for the lowest items
  • Open purchase orders checked for the next promised date
  • Inactive sites skipped and counted, and no order created

The prompt

Use this prompt

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

Prompt
**Objective:** Find items at risk of stock-out in `{company}` (default company if empty), at location `{location-id}` when given, using on-hand at or below `{quantity-threshold}` (default 10).

**Step 1: Stock levels**

Call `powergp-online-get-itemsitequantities` with `quantity-on-hand.max` set to the threshold and `location-id` when given. Set `max-records` to 500.

**Step 2: Item details**

For the 20 lowest items, call `powergp-online-get-items` with `item-number` to read description, class, `current-cost` and `valuation-method`.

**Step 3: Supply coming**

Call `powergp-online-get-purchaseorders` with `item-number` to find open lines and `promised-date`. Use `quantity-on-order` from Step 1 as a cross check.

**Step 4: Report**

Table: item number, description, site, on hand, on order, next promised date, current cost. Mark items with nothing on order as "reorder now", items with supply after 14 days as "at risk", the rest as "covered". Suggest a reorder quantity only when `fixed-order-quantity` is present.

**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 create or change purchase orders.
* Skip item sites whose `item-site-status` is not active and say how many were skipped.

**Validation:**

* If no items fall under the threshold, say so and stop.

Who it's for

One answer, three teams that use it

Inventory planners

Start the day with a ranked reorder list

Items are marked reorder now, at risk or covered, so you spend time only on the ones that need action.

Which items at the Chicago warehouse have 5 or fewer on hand and no open purchase order?

Buyers

See what is already on order before you buy

Open purchase orders and promised dates appear next to each low item, so you do not order twice.

Show low stock items under 20 units and tell me which ones already have a PO coming.

Warehouse managers

Know which shelves are close to empty

Get a quick view of low items at your location with their current cost and next delivery date.

What is running low at the Seattle site, and when is the next delivery for each item?

How it works

What PopdockAI does when you ask

You give a stock threshold and your AI assistant checks PowerGP Online stock and open orders. It ranks what needs attention and never creates or changes a purchase order.

01

Ask

You give a stock threshold and optionally a location.

Your AI tool

02

Check

It reads item site quantities at or below the threshold.

powergp-online-get-itemsitequantities

03

Match

It looks up item details and open purchase orders with promised dates.

powergp-online-get-items
powergp-online-get-purchaseorders

04

Report

It ranks items as reorder now, at risk or covered.

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

Returns item site quantities 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-items

Returns items 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-purchaseorders

Returns purchase orders 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

Reorders raised before stock runs out

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