Connectors

/

Procore

/

Review Procore punch assignee vendor balances in Dynamics 365 Business Central
Report
Cross-Connector

See what each punch vendor is owed before close-out

For project managers who want open Procore punch work set beside Business Central vendor balances, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review Procore punch assignee vendor balances in Dynamics 365 Business Central
For the Riverside Tower project, how many open punch items does each vendor have, and what does Business Central show for their balances?
Riverside Tower has 38 open punch items across 6 vendors, and 5 of them were found in Business Central. - Contoso Drywall: 14 open items, oldest 3 September, balance due 18,400.00 - Fabrikam Flooring: 9 open items, vendor blocked in Business Central - Northwind Painting: 7 open items, balance due 0.00 - Not found: Harbour Glazing, no exact name match in Business Central Want the full table of all 6 vendors?
Procore
Sample figures. Your results come from your own account.
procore-get-punch-items-activities

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

Chasing punch work without knowing who is owed money

Before close-out the team chases vendors for open punch items. Whether a vendor is still owed money or is blocked in accounting sits in another system, so the conversation starts without the full picture.

Without PopdockAI

  • Filter the project's punch items by status in Procore
  • Count open items for each assigned vendor
  • Look each vendor up in Business Central by hand
  • Compile the balances into a sheet

With PopdockAI

  • Open punch items are counted per vendor for you
  • Each vendor is looked up in Business Central by exact name match
  • Blocked status, balance and balance due are shown beside the count
  • It reports facts only and nothing is 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:** For Procore project {project-name}, show how many open punch items each assigned vendor holds and what Business Central says about that vendor's status and balance.

**Step 1: Read the punch work (procore-project-management server)**

Call `procore-get-punch-items-activities` with `project-name.contains` {project-name} and `max-records` of 200. Ignore items whose global-status-name is Closed. Group the rest by assignee-vendor-name and keep the count, the punch-item-category-name values and the oldest date-created.

**Step 2: Look up each vendor (business-central server)**

For each assigned vendor call `business-central-get-vendor` with `name.contains` set to its most distinctive word and `max-records` of 5. Keep vendor-number, name, blocked, balance and balance-due. Match only when the name is the same after lower-casing and removing punctuation and company suffixes; otherwise report Not found.

**Step 3: Report**

Give a table sorted by open items, highest first, with columns Vendor, Open items, Oldest item, Business Central vendor, Blocked, Balance, Balance due. Under it, list items with no assigned vendor as a count.

**Rules & Guidelines:**

* `procore-get-punch-items-activities` is on the procore-project-management server; `business-central-get-vendor` is on the business-central server.
* This is read-only. Do not call any `procore-create-*`, `procore-update-*`, `procore-delete-*` or `procore-send-*` tool on the procore-project-management server, and do not call any `business-central-create-*` or `business-central-update-*` tool on the business-central server.
* Report what Business Central shows. Do not suggest withholding or releasing payment.

**Validation:**

* If more than one Procore project matches {project-name}, list the project names found and stop.
* If no open punch items are found, say so and stop.
* If the vendor lookup returns nothing for all vendors, say the Business Central server may be pointed at the wrong company.

Who it's for

One answer, three teams that use it

Project managers

Prepare for close-out meetings

See which vendors hold the most open punch items and what Business Central says about them.

Show open punch items by vendor for Fabrikam Depot with their Business Central balance due.

Construction accountants

Check vendors before final payments

See blocked status and balance due beside the work still open, so you know where final payments stand.

Which vendors with open punch items on Contoso Warehouse are blocked in Business Central?

Site superintendents

Know who to chase first

Get vendors ranked by open items with the oldest item date, so you chase the longest outstanding work.

Rank the vendors by open punch items on Northwind Plaza and show the oldest item for each.

How it works

What PopdockAI does when you ask

You name the project in plain words and your AI assistant counts the open punch work in Procore, then looks each vendor up in Business Central. It only reads and does not recommend what to pay.

Ask

You name the Procore project.

Your AI tool

Count

It groups the open punch items by assigned vendor with categories and the oldest item.

procore-get-punch-items-activities

Look up

It finds each vendor in Business Central, matching on the normalised name, and reads blocked status and balances.

No items found.

Report

You get one table sorted by open items, plus a count of items with no vendor.

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-punch-items-activities

Returns Procore punch item activities for a project, including the assigned vendor and status of each punch item. Filter by project.
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

Close out with the full picture on every vendor

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