Connectors

/

Procore

/

Raise Procore observations for past-due NetSuite vendors on site
Write
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Raise Procore observations for past-due NetSuite vendors on site
On Riverside Tower, find vendors who were on site in the last 14 days with payables more than 30 days past due, and show me the observations you would raise.
2 vendors on Riverside Tower were on site recently and have payables more than 30 days past due. - Contoso Steel: 3 past-due items, oldest due 12 September - Fabrikam Electrical: 1 past-due item, oldest due 2 October - Observation names: Payment follow-up: Contoso Steel, Payment follow-up: Fabrikam Electrical - Ambiguous in NetSuite: none Shall I raise these 2 observations?
Procore
Sample figures. Your results come from your own account.
procore-get-manpower-logs
netsuite-get-apopenitem
procore-get-observations-items
procore-create-observation-item

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

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.

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

Your AI tool

Find

It lists vendors that logged manpower recently and checks NetSuite for payables past due.

procore-get-manpower-logs
netsuite-get-apopenitem
procore-get-observations-items

Confirm

You see each vendor, its past-due items and the observation name, and say yes.

No items found.

Raise

It skips vendors that already have one, raises the rest, and reports what was created or skipped.

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-manpower-logs

Returns Procore manpower log entries from daily logs, including the vendor and workers on site. Filter by project and date.
get-data

netsuite-get-apopenitem

Returns NetSuite AP open items read from the NetSuite connector, with the fields people use most. Read-only.
get-data

procore-get-observations-items

Returns Procore observation items for a project, with status, assignee and due date.
run-action

procore-create-observation-item

Creates an observation item on a Procore project. Writes to live Procore data. Not individually tested, so try it on a sandbox project first.
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

The site team warned before a payment dispute becomes a site problem

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