/
/
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.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
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.
**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.
Count
It groups the open punch items by assigned vendor with categories and the oldest item.
Look up
It finds each vendor in Business Central, matching on the normalised name, and reads blocked status and balances.
Report
You get one table sorted by open items, plus a count of items with no vendor.
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.
procore-get-punch-items-activities
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.
The outcome
Close out with the full picture on every vendor
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.

.webp)
