Connectors

/

Procore

/

Compare Procore open items to the field backlog
Report

See which overdue items are punch and observations

For leadership and project executives who want overdue open items set beside the field backlog on each project, asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare Procore open items to the field backlog
For projects with at least 10 overdue open items, how many overdue punch items and observations sit behind them?
4 projects have 10 or more overdue open items, and only 2 are explained by the field backlog. - Riverside Tower: 38 overdue, 21 punch items, 6 observations, 84,200 punch cost impact - Contoso Warehouse: 24 overdue, 9 punch items, 2 observations - Fabrikam Depot: 17 overdue, none in punch or observations, the items are elsewhere Want the full table with each project's stage?
Procore
Sample figures. Your results come from your own account.
procore-get-open-items-all
procore-get-projects
procore-get-punch-items
procore-get-observations-items

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Procore

Procore
Run it on your own Procore data.

Connect Procore, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

A high overdue count does not say what is behind it

A project's overdue open item count shows it is behind, but not whether punch items or observations are the cause. The numbers live in different places, so reviews stay vague.

Without PopdockAI

  • Pull the overdue open item count for each project
  • Open punch items and observations separately
  • Count the overdue ones on each project
  • Add up the punch cost impact by hand

With PopdockAI

  • Projects above your threshold are picked out
  • Overdue punch items and observations are counted for each
  • Punch cost impact is totalled per project
  • Both directions of mismatch are called out

The prompt

Use this prompt

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

Prompt
**Objective:** For each project with at least `{min-overdue}` overdue open items (default 1), show how many overdue punch items and observations sit behind that count, optionally for project `{project-name}` only.

**Step 1: Read the open item summary (procore-core)**

Call `procore-get-open-items-all` (with `project-name` if given). Keep rows where `overdue-count` is at least the minimum. Record `project-id`, `project-name`, `open-count`, `overdue-count`, `last-activity`. Optionally call `procore-get-projects` to add the project `stage`.

**Step 2: Read the field backlog (procore-project-management)**

Today's date is the cutoff. For each kept project call `procore-get-punch-items` with `project-id` and `due-date.to` set to today, and keep rows whose `status` is not closed. Call `procore-get-observations-items` the same way. Count rows and sum `cost-impact-amount` on the punch items.

**Step 3: Report**

A table sorted by `overdue-count`: project, stage, overdue open items, overdue punch items, overdue observations, punch cost impact. Note projects where the overdue count is high but the field backlog is empty (the overdue items are elsewhere, for example tasks) and the reverse.

**Rules & Guidelines:**

* `procore-get-open-items-all` and `procore-get-projects` are on procore-core. `procore-get-punch-items` and `procore-get-observations-items` are on procore-project-management.
* Read-only. Do not call any create, update, delete or send tool on either server.

**Validation:**

* If no project meets the threshold, say so and stop.
* The two servers count different things; do not claim the numbers should be equal.
* If a project-id filter is rejected, filter by `project-name` instead.

Who it's for

One answer, three teams that use it

Executives

Run sharper project reviews

See which projects are behind and whether punch and observations explain it, before the review meeting starts.

Show projects with 5 or more overdue open items next to their overdue punch items.

Portfolio managers

Find the hidden backlog

Spot projects with a high overdue count but an empty field backlog, so you know to look at tasks and other items instead.

Which projects have many overdue open items but no overdue punch items or observations?

Operations directors

See the cost behind the punch

Check the punch cost impact on each project with overdue items, to put a figure on the problem.

For Contoso Warehouse, how much cost impact sits on overdue punch items?

How it works

What PopdockAI does when you ask

You ask which projects are behind. Your AI assistant sets the open item counts beside the punch and observation backlog and does not treat the two as equal.

Ask

You give a minimum overdue count and optionally a single project.

Your AI tool

Read

It reads the overdue open item counts for each project that meets the threshold.

procore-get-open-items-all
procore-get-projects
procore-get-punch-items
procore-get-observations-items

Count

It counts overdue punch items and observations and totals the punch cost impact.

No items found.

Report

You get a table sorted by overdue items, with mismatches noted either way.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Procore and one secure connection to your AI tool. No code, no exports.

get-data

procore-get-open-items-all

Returns Procore open item statistics per project, including how many items are open and overdue.
get-data

procore-get-projects

Returns the projects in Procore, with project number, name, stage, active flag and dates. Filter by name, number or status.
get-data

procore-get-punch-items

Returns Procore punch list items for a project, with status, assignee, due date and cost impact.
get-data

procore-get-observations-items

Returns Procore observation items for a project, with status, assignee and due date.
Read only.Nothing in Procore 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

Reviews that show where the overdue work really sits

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation