/
/
Find jobs that exist in Procore but not in NetSuite
For finance teams who want Procore projects reconciled with NetSuite projects by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Two project lists are compared by hand
You compare the Procore project list with NetSuite projects line by line. Jobs that exist in only one system, or are open in one and closed in the other, slip through.
Without PopdockAI
- List projects in Procore
- Search NetSuite for each project number
- Compare active and closed status by eye
- Discover a missing job after costs post
With PopdockAI
- Procore projects are read for you
- Each project is looked up in NetSuite by number
- Missing, mismatched and status conflicting projects are listed
- Name-only matches are labelled unconfirmed and never guessed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Reconcile Procore projects whose name contains `{project-name-contains}` (default: all, capped at 50) against NetSuite projects and report what is missing or inconsistent.
**Step 1: Read the Procore projects**
Call `procore-get-projects` (procore-core server) with `project-name.contains` set to `{project-name-contains}` when given, and `max-records` 50. Keep `number`, `project-name`, `stage`, `active`, `estimated-value` and `actual-start-date` for each.
**Step 2: Find each one in NetSuite**
For each Procore project, call `netsuite-get-project` (netsuite server) with `project-number` set to the Procore `number`. If nothing comes back, retry once with `customer-company-name.contains` set to the first word of `project-name`. Keep `project-number`, `status`, `customer-company-name`, `end-date` and `projected-end-date`.
**Step 3: Report**
Give three lists: (a) Procore projects with no NetSuite match, (b) NetSuite projects returned by the retry that match a Procore name but a different number, (c) matched pairs where Procore says `active` is false but the NetSuite `status` is open, or the reverse. End with counts for each list.
**Rules & Guidelines:**
* `procore-get-projects` is on procore-core. `netsuite-get-project` is on netsuite. Both servers must be connected.
* Read only. Do not call any Procore create, update or delete tool, and do not call any NetSuite add or update tool.
* Treat project numbers as text. Trim spaces and ignore case when comparing.
**Validation:**
* If `procore-get-projects` returns nothing, say so and stop.
* If `netsuite-get-project` returns nothing for every project, say the NetSuite side may not track projects by this number and stop after listing what you tried.
* Never guess a match from similar names alone; label name-only matches as unconfirmed.Who it's for
One answer, three teams that use it
Finance managers
See jobs missing in NetSuite
Get the Procore projects that have no NetSuite project before costs have nowhere to post.
Which Procore projects have no matching NetSuite project?
Project accountants
Catch open and closed conflicts
Find jobs closed in one system but still open in the other.
Show Procore projects that are active where the NetSuite project is closed, or the reverse.
Controllers
Check a project family
Narrow the check to projects with a given name and see the counts for each list.
Reconcile Procore projects whose name contains Tower with NetSuite projects.
How it works
What PopdockAI does when you ask
You can narrow by project name and your AI assistant looks up each project in NetSuite. It only reads, so no project is created or changed.
Ask
You optionally give part of a project name, or check up to 50 projects.
Read
It reads the Procore projects with their number, stage and active status.
Look up
It finds each project in NetSuite by number, then retries once by customer.
Report
You get missing projects, number mismatches, status conflicts and counts for each list.
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-projects
netsuite-get-project
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
One list of the jobs that do not line up
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)
