Connectors

/

Procore

/

Flag late Procore submittals from blocked Dynamics 365 Business Central vendors
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Flag late Procore submittals from blocked Dynamics 365 Business Central vendors
On Riverside Tower, which submittals are overdue and are any of the contractors blocked or owed money in Business Central?
7 submittals are overdue on Riverside Tower, and 2 of the contractors holding them are blocked or owed money. - Longest overdue: 03 30 00 Concrete mix design, Contoso Concrete, 34 days - Blocked: Fabrikam Glazing, 3 overdue submittals, balance due $14,500 - Owed money: Contoso Concrete, 2 overdue submittals, balance due $8,200 - Not found: Northwind Steel, no exact vendor match in Business Central Want the full table of all 7 submittals?
Procore
Sample figures. Your results come from your own account.
procore-get-submittals

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

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.

Prompt
**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.

Your AI tool

Read

It lists the submittals due before the date that are not closed or approved.

procore-get-submittals

Look up

It finds each responsible contractor in Business Central and shows Not found where no exact match exists.

No items found.

Report

You get a table by days overdue with blocked status and balance due, and the contractors holding the most.

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

Returns submittals on a Procore project, with number, title, status, due date, responsible contractor and specification section. Filter by project name or submittal fields.
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

Chase submittals with the whole story in view

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