Connectors

/

Procore

/

Add missing Procore vendors to Intacct
Write
Cross-Connector

Set up Procore project vendors in Intacct before they bill

For accounts payable teams who want missing Procore vendors added to Intacct, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Add missing Procore vendors to Intacct
Find vendors billing the Riverside Tower project in Procore that are missing from Intacct, using the prefix RT-, and show me before you create anything.
Riverside Tower has 12 vendors on invoices and direct costs, and 3 are missing from Intacct. - Missing: Fabrikam Glazing, proposed id RT-FABRIKAMGLAZING - Missing: Contoso Crane Hire, proposed id RT-CONTOSOCRANEHIRE - Similar: Northwind Steel looks close to Northwind Steel Ltd, treated as existing - Exists: 8 vendors already in Intacct Which of the missing vendors should I create?
Procore
Sample figures. Your results come from your own account.
procore-get-requisitions
procore-get-direct-costs
sage-intacct-get-vendor
sage-intacct-create-vendor

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

Vendors bill on the job before they exist in Intacct

Vendors on Procore invoices and direct costs are not always set up in Intacct. Their bills stall until accounts payable finds the gap and keys each vendor in by hand.

Without PopdockAI

  • Collect the vendors from Procore invoices and direct costs
  • Search Intacct for each vendor name
  • Judge near matches by eye
  • Key each missing vendor in with its id

With PopdockAI

  • Vendors are collected from invoices and direct costs for you
  • Close name matches are treated as existing
  • You see the proposed vendor ids and approve before anything is created
  • Each approved vendor is created once and read back

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Find vendors that bill Procore project {project-name} but do not exist in Intacct, and create the ones the user approves. {vendor-id-prefix} is added to the start of each new Intacct vendor-id; if empty, use none. Check at most {max-vendors} vendors (default 25).

**Step 1: Collect the vendors from Procore (procore-construction-financials server)**

Call `procore-get-requisitions` with `project-name` = {project-name} and note the distinct vendor values. Call `procore-get-direct-costs` with the same filter and add its distinct vendor values. Remove blanks and duplicates that differ only by case or punctuation. Keep the first {max-vendors}.

**Step 2: Check each vendor in Intacct (intacct server)**

For each vendor call `intacct-get-vendor` with `vendor-name.contains` = the vendor name. Classify it as exists (same name), similar (a close but different name) or missing (no result). For similar vendors, show both names and treat them as existing unless the user says otherwise.

**Step 3: Confirm**

Show a table of the missing vendors with the proposed name, print-as (same as name) and vendor-id (the prefix plus the name in upper case with spaces removed, at most 20 characters). Also show the exists and similar vendors for context. Ask the user which missing vendors to create. Do not continue without an explicit answer.

**Step 4: Create and verify**

For each approved vendor call `intacct-create-vendor` with `name`, `print-as`, `vendor-id` and `status` Active. Then call `intacct-get-vendor` with `vendor-id` to confirm it stored. Report created, failed and skipped vendors, with the Intacct vendor-id for each created one.

**Rules & Guidelines:**

* `procore-get-requisitions` and `procore-get-direct-costs` are on the procore-construction-financials server. `intacct-get-vendor` and `intacct-create-vendor` are on the intacct server.
* `intacct-create-vendor` is the only tool that may write, once per approved vendor, and only after the confirmation in Step 3.
* Never call any Procore create, update, delete or sync action, and never call `intacct-update-vendor`.

**Validation:**

* If Procore returns no vendors, say so and stop.
* If a vendor-id already exists in Intacct, skip that vendor and report it rather than changing the id.
* If a create call fails, report the error and continue with the next vendor.

Who it's for

One answer, three teams that use it

Accounts payable

Clear stalled bills

Find the vendors blocking bills on a project and add them to Intacct in one conversation.

Which vendors billing Fabrikam Depot in Procore are missing from Intacct? Show proposed ids with the prefix FD-.

Procurement managers

Check subcontractors are set up

See which vendors on a new project are not yet in Intacct before work is invoiced.

Check the vendors on Contoso Warehouse invoices and direct costs against Intacct and list any that are missing.

Finance controllers

Keep vendor ids consistent

Review the proposed ids and prefix before anything is created, and skip ids that already exist.

For Northwind Plaza, propose Intacct vendor ids with the prefix NP- for missing vendors, limited to 10 vendors.

How it works

What PopdockAI does when you ask

You name the project in plain words and your AI assistant compares the Procore vendors with Intacct. Nothing is created until you have seen the proposed vendors and approved them.

Ask

You name the Procore project, and optionally a vendor id prefix and a limit.

Your AI tool

Check

It collects the vendors on invoices and direct costs and looks each one up in Intacct.

procore-get-requisitions
procore-get-direct-costs
sage-intacct-get-vendor

Confirm

You see the missing vendors with their proposed ids and choose which to create.

No items found.

Create

It creates each approved vendor once and reads it back to confirm it was stored.

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-direct-costs

Returns Procore direct costs, with vendor, date, status and amount. Filter by project or date.
get-data

sage-intacct-get-vendor

Returns vendors from Sage Intacct.
run-action

sage-intacct-create-vendor

Creates a vendor in Sage Intacct Accounts Payable. Returns the new vendor's record number and vendor ID.
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

Vendors ready in Intacct before the bills arrive

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