Connectors

/

Procore

/

Check Procore payee insurance for requisitions
Report

Check payee insurance before you pay a requisition

For accounts payable and project accountants who want payees' insurance checked before payment, asking their AI assistant to rank vendors owed money without current cover.

Try PopdockAI free
Get a live demo
Check Procore payee insurance for requisitions
Which vendors on Riverside Tower are owed money but have expired or missing insurance?
3 of 9 vendors on Riverside Tower are owed money without current insurance, 148,300 in total. - Contoso Electric: 62,000 due, insurance expired 02 Oct - Fabrikam Drywall: 54,100 due, none on file - Northwind Roofing: 32,200 due, policy undated - Requisitions skipped as draft or void: 4 Want the full table of all 9 vendors?
Procore
Sample figures. Your results come from your own account.
procore-get-requisitions
procore-get-project-vendors
procore-get-project-vendors-insurances
procore-get-vendors-insurances
procore-get-lien-waivers

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 lapsed policy slips through to a payment

Requisitions are read in one screen and vendor insurance sits in another, often under a slightly different spelling of the vendor name. A policy that expired last month is found after the money has gone.

Without PopdockAI

  • Read each requisition and note the vendor and amount
  • Find the same vendor in the insurance records
  • Work out whether the policy is current
  • Total what is owed to anyone uninsured

With PopdockAI

  • Requisitions and vendors are read for the project
  • Each vendor is matched to project or company insurance
  • Expired, missing and undated cover is flagged separately
  • Vendors owed money without cover come first, with a total

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 project `{project-name}`, find the vendors with open requisitions and report which of them have expired, missing or soon-to-expire insurance. Only look at requisitions with status `{status}` (default: every status except draft and void).

**Step 1: Read the requisitions (financials server)**

Call `procore-get-requisitions` filtered by `project-name`. Keep `vendor`, `invoice-number`, `vendor-invoice-number`, `status`, `total-claimed-amount` and `current-payment-due`. Apply the status filter yourself and say how many requisitions you skipped. Build a list of distinct vendor names. If no requisitions come back, say so and stop.

**Step 2: Find the vendors on the project (core server)**

Call `procore-get-project-vendors` filtered by `project-name`. Match each vendor name from Step 1 to a roster entry by `name` (ignore case, punctuation and suffixes such as LLC or Inc). If a vendor has no match, list it as not on the project roster and skip Step 3 for it.

**Step 3: Read the insurance (core server)**

For each matched vendor call `procore-get-project-vendors-insurances` with `project-name` and `project-vendor-name`. If that returns nothing, call `procore-get-vendors-insurances` with `vendor-name` and say the cover came from the company record. Keep `status`, `policy-number`, `effective-date` and `expiration-date`.

**Step 4: Report**

A table with one row per vendor: vendor, open requisitions, total payment due, insurance verdict (current, expires within 30 days, expired, none on file, not on roster), earliest expiration date. Put the vendors with money due and no current cover first, then a one-line total of payment due held by uninsured vendors.

**Rules & Guidelines:**

* Tools named `procore-get-requisitions`, `procore-get-lien-waivers` and the other financial reads live on the Procore construction financials server (procore-construction-financials). Project, vendor, insurance, people and task tools live on the Procore core server (procore-core). Both servers must be connected; if a tool is missing, say which server is not connected and stop.
* Read-only. Do NOT call any create, update, delete or sync tool on either server, including `procore-create-insurance`, `procore-create-vendor-insurance` and `procore-update-insurance`.

**Validation:**

* If the vendor name matches more than one roster entry, list the candidates and ask which to use rather than guessing.
* If an insurance row has no `expiration-date`, report it as undated, not as current.
* The two servers spell vendor names differently; treat a near match as a match and show both spellings.

Who it's for

One answer, three teams that use it

Accounts payable

Check before payment runs

See every vendor owed money who lacks current cover before you release the next batch of payments.

Run an insurance check on the open requisitions for Fabrikam Depot.

Project accountants

Put a figure on the exposure

Get a single total of payment due that sits with uninsured vendors, ready to take to the project manager.

How much payment is due to uninsured vendors on Contoso Warehouse?

Commercial managers

Catch policies about to lapse

Include policies that expire within the next 30 days so cover can be renewed before the next pay cycle.

On Northwind Plaza, which paid vendors have insurance expiring within a month?

How it works

What PopdockAI does when you ask

You name the project. Your AI assistant reads the requisitions, matches each vendor to its insurance, and ranks the ones owed money without current cover.

Ask

You name the project and optionally a requisition status.

Your AI tool

Read

It reads the requisitions and builds the list of vendors with money due.

procore-get-requisitions
procore-get-project-vendors
procore-get-project-vendors-insurances
procore-get-vendors-insurances
procore-get-lien-waivers

Match

It matches each vendor to the project roster and its insurance records.

No items found.

Report

You get one row per vendor, uninsured vendors with money due first, and a total at risk.

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

Returns Procore subcontractor requisitions (invoices), with vendor, vendor invoice number, status, total claimed, payment due and billing date. Filter by project name and billing date range.
get-data

procore-get-project-vendors

Returns the vendors on a Procore project roster, with contact details. Filter by project.
get-data

procore-get-project-vendors-insurances

Returns vendor insurance policies as seen from a Procore project, with policy type, status and expiry. Filter by project and vendor.
get-data

procore-get-vendors-insurances

Returns the insurance policies recorded against Procore vendors, with policy type, effective and expiration dates and status.
get-data

procore-get-lien-waivers

Returns lien waivers from Procore, with their status and the invoice or commitment they cover. Read-only.
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

Payment decisions made knowing who is uninsured

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