/
/
Know why a contractor's submittals are late
For project managers who want overdue Procore submittals shown with the contractor's Business Central blocked status and balance, by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Submittal chases stall for reasons you cannot see
A project manager chases overdue submittals in Procore without knowing the contractor is blocked or unpaid in the accounting system. The chase goes nowhere, and the real reason sits in another system.
Without PopdockAI
- Filter Procore submittals for those past due and not closed
- Note each responsible contractor
- Look every contractor up in Business Central
- Check blocked status and balance one by one
With PopdockAI
- Overdue submittals listed longest first
- Each contractor looked up, with exact name matching only
- Blocked status and balance due shown beside each
- No match shown as Not found, never as clear
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-id}, list submittals due before {as-of-date} (default today) that are not closed, and show whether each responsible contractor is blocked or owed money in Business Central.
**Step 1: Read the submittals (procore-project-management server)**
Call `procore-get-submittals` with `project-id` {project-id} and `max-records` of 200. Keep formatted-number, title, status, due-date, specification-section-number and responsible-contractor-name. Drop any submittal that is closed or approved, and any whose due-date is on or after {as-of-date}.
**Step 2: Look up each contractor (business-central server)**
For each distinct responsible-contractor-name 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 on a name that is the same after lower-casing and removing punctuation and company suffixes; otherwise the contractor is Not found.
**Step 3: Report**
Give a table sorted by days overdue, longest first, with columns Submittal, Title, Contractor, Due date, Days overdue, Business Central vendor, Blocked, Balance due. Then list the contractors who are blocked or have a balance due and say how many overdue submittals each holds.
**Rules & Guidelines:**
* `procore-get-submittals` 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.
* A balance due is context for the project manager, not a reason to say the contractor is at fault.
**Validation:**
* If there are no overdue submittals, say so and stop without calling the business-central server.
* If a submittal has no responsible-contractor-name, list it under No contractor assigned.
* If {as-of-date} is not a date, use today and say so.Who it's for
One answer, three teams that use it
Project managers
Chase with context
See whether an overdue contractor is blocked or owed money before you call them.
Which overdue submittals on Northwind Plaza are held by a blocked contractor in Business Central?
Document controllers
Prioritise the chase list
Get overdue submittals sorted by days late, with the contractor's status beside each.
List overdue submittals on Contoso Warehouse as of today with the contractor's blocked status.
Commercial managers
Raise payment issues that hold up work
See contractors with a balance due who also hold overdue submittals, so payment can be raised with accounts.
Which contractors with overdue submittals on Riverside Tower also have a balance due to them?
How it works
What PopdockAI does when you ask
You give the project and your AI assistant lists the overdue submittals and checks each contractor. It only reads, and it contacts nobody.
Ask
You give the Procore project and optionally an as-of date.
Read
It lists the submittals due before the date that are not closed or approved.
Look up
It finds each responsible contractor in Business Central and shows Not found where no exact match exists.
Report
You get a table by days overdue with blocked status and balance due, and the contractors holding the most.
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-submittals
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
Chase submittals with the whole story in view
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)
