/
/
Warn the site team about vendors with past-due payables
For project managers who want observations raised in Procore for vendors on site with past-due NetSuite payables, by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Site teams are the last to hear about a payment dispute
A vendor on site may have payables long past due in NetSuite, but the site team does not see that. The first sign is a payment dispute that shows up as a site problem.
Without PopdockAI
- Read the manpower logs to see who was on site
- Search NetSuite for each vendor past-due items
- Decide who to warn the team about
- Write the observations one at a time in Procore
With PopdockAI
- Vendors on site are taken from recent manpower logs
- Past-due payables are checked in NetSuite for each one
- You see the proposed observations and confirm first
- Vendors with an observation already are skipped and NetSuite is never 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 the Procore project named `{project-name}`, find vendors that logged manpower in the last `{lookback-days}` days (default 14) and have payables more than `{days-past-due}` days past due in NetSuite (default 30), then, after confirmation, raise one Procore observation per vendor so the project team knows payment friction may affect the site.
**Step 1: Find the vendors on site**
Call `procore-get-manpower-logs` (procore-project-management) with `project-name.contains` set to `{project-name}` and `date.from` set to the start of the lookback window. Keep distinct `vendor-name` values and note the Procore project id. If more than one project matches, list the matches and stop.
**Step 2: Check NetSuite payables**
For each vendor call `netsuite-get-apopenitem` (netsuite) with `vendor` set to the vendor name and `due-date.to` set to the date `{days-past-due}` days ago. Keep `document-number`, `due-date` and `amount-applied`. Drop vendors with no results. If the vendor name matches more than one NetSuite vendor, exclude it and list it as ambiguous.
**Step 3: Propose, then confirm**
Show a table of vendor, number of past-due items, oldest due date and the observation name you would use, such as "Payment follow-up: <vendor>". Ask for a yes. If the answer is not a clear yes, stop and write nothing.
**Step 4: Raise the observations**
Call `procore-get-observations-items` (procore-project-management) with `project-name.contains` set to `{project-name}` to skip any vendor that already has an observation with that name. For each remaining confirmed vendor call `procore-create-observation-item` (procore-project-management) with `project-id` and `observation-name`. Report the observations created and those skipped.
**Rules & Guidelines:**
* The only tool allowed to write is `procore-create-observation-item`, and only after the confirmation in Step 3. All other Procore and NetSuite tools are read-only.
* Never call `netsuite-add-*`, `netsuite-update-*`, or any other `procore-create-*` or `procore-update-*` tool.
* Do not put amounts in the observation name.
**Validation:**
* If no vendor qualifies, report that and write nothing.
* If `procore-create-observation-item` fails for a vendor, report it and continue with the rest.Who it's for
One answer, three teams that use it
Project managers
Warn the team early
Know which vendors on your job are owed money long past due, and have a Procore observation raised for each.
Raise observations on the Contoso Warehouse project for vendors on site with payables over 45 days past due.
Site superintendents
See payment friction on site
Find out which crews working today may be affected by unpaid invoices.
Which vendors on site at Fabrikam Depot in the last 7 days have past-due NetSuite payables?
Accounts payable leads
Feed payment risk to the project
Pass past-due vendor information to the project team through observations, without separate emails.
Check Riverside Tower vendors on site against NetSuite past-due items and show me what you would raise.
How it works
What PopdockAI does when you ask
You name the project and your AI assistant finds the vendors on site and checks NetSuite. Observations are raised in Procore only after you have seen the list and said yes.
Ask
You name the Procore project and optionally the look-back and past-due windows.
Find
It lists vendors that logged manpower recently and checks NetSuite for payables past due.
Confirm
You see each vendor, its past-due items and the observation name, and say yes.
Raise
It skips vendors that already have one, raises the rest, and reports what was created or skipped.
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-manpower-logs
netsuite-get-apopenitem
procore-get-observations-items
procore-create-observation-item
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
The site team warned before a payment dispute becomes a site problem
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)
