/
/
See which RFI contractors you also owe money to
For project managers who want contractors on open Procore RFIs matched to their NetSuite vendor balance by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
The contractor holding an RFI may be owed money
The open RFI is in Procore and the contractor's balance is in NetSuite, so nobody sees both. The team chases an answer from a contractor without knowing a payment is overdue.
Without PopdockAI
- List the open RFIs and their responsible contractors
- Search NetSuite for each contractor as a vendor
- Read each balance and note the differences in spelling
- Pull it together before the next RFI meeting
With PopdockAI
- Open RFIs are read with overdue and cost impact counts
- Each contractor is looked up as a NetSuite vendor
- Name matches are shown as probable, never confirmed
- Contractors with no vendor are listed separately
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the Procore project named `{project-name}`, find the contractors responsible for open RFIs and show each one's NetSuite vendor record and balance, so the team sees who is owed money while they owe an answer. Treat a balance above `{balance-threshold}` as notable (default 0).
**Step 1: Read the open RFIs**
Call `procore-get-rfis` (procore-project-management) with `project-name.contains` set to `{project-name}`. Keep RFIs whose `status` is not closed. Take `responsible-contractor-name`, `full-number`, `subject`, `due-date` and `cost-impact-status`. If more than one project matches, list the matches and stop.
**Step 2: Look each contractor up in NetSuite**
For each distinct `responsible-contractor-name` call `netsuite-get-vendor` (netsuite) with `company-name.contains` set to that name. Keep `vendor-id`, `company-name`, `balance` and `email`. If more than one vendor matches, list them and do not pick one.
**Step 3: Report**
Return a table of contractor, number of open RFIs, overdue RFIs, RFIs with a cost impact, NetSuite vendor, and balance. Put contractors with a balance above the threshold first. List contractors with no NetSuite vendor separately as present in Procore and absent from NetSuite.
**Rules & Guidelines:**
* Procore tools are on the procore-project-management server and NetSuite tools are on the netsuite server. This prompt is read-only: do not call any `procore-create-*`, `procore-update-*`, `netsuite-add-*` or `netsuite-update-*` tool.
* Name matches are by company name only; state that they are name matches, not confirmed identities.
**Validation:**
* If there are no open RFIs, say so and stop.
* If a vendor name differs only by suffix (Inc, LLC), show it as a probable match and mark it so.Who it's for
One answer, three teams that use it
Project managers
Handle RFIs and payments together
See which contractors you are waiting on and which of them you owe, before the next coordination meeting.
Which contractors with open RFIs on Fabrikam Depot have a balance in NetSuite?
Project engineers
Prioritise overdue RFIs
See overdue RFIs by contractor with their balance, so you know where the commercial pressure is.
Show overdue RFIs on Northwind Plaza by contractor with their NetSuite balance.
Accounts payable
Know who is waiting on an answer
See which vendors with a balance also have open RFIs, so a payment query is answered with context.
Do any vendors we owe over 20,000 have open RFIs on Contoso Warehouse?
How it works
What PopdockAI does when you ask
You name the project in plain words. Your AI assistant reads the RFIs and vendors, lists every candidate when a name is ambiguous, and changes nothing in either system.
Ask
You name the Procore project and optionally a balance threshold.
Read
It reads the project's open RFIs and the responsible contractor on each.
Look up
It looks each contractor up as a NetSuite vendor and reads the balance, listing matches rather than picking.
Report
You get a table with RFI counts and balances, plus contractors missing from NetSuite.
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-rfis
netsuite-get-vendor
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
RFI delays and payments seen together
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)
