/
/
Find materials purchase orders missing from Intacct
For finance teams who want every Procore materials purchase order checked against Intacct purchasing documents by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Purchase orders and accounting drift apart
Procore materials orders are matched to Intacct purchasing documents by hand, one vendor at a time. Orders never recorded in accounting, and documents with no order behind them, are found late.
Without PopdockAI
- Export the project's purchase orders from Procore
- Search Intacct purchasing documents vendor by vendor
- Match references and numbers by eye
- Find the gaps when a vendor asks about payment
With PopdockAI
- Orders and vendor documents are read from both systems
- Matches use reference and number, never a guess
- Same vendor and similar date is labelled a possible match
- Unmatched orders and Intacct documents are listed with counts
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}`, check that each materials purchase order has a matching Intacct purchasing transaction, looking at purchase orders with status `{status}` (optional).
**Step 1: Read the Procore purchase orders**
Call `procore-get-materials-mgmt-purchase-orders` (Procore Resource Management server) with `project-name` set to `{project-name}` and `status` set to `{status}` when given. If no rows match exactly, retry with `project-name.contains` and, if that returns several distinct projects, list them and stop. Keep `name`, `vendor`, `status`, `date-created`, `original-contract-delivery-date` and `line-items-count`.
**Step 2: Read the Intacct transactions**
For each distinct `vendor`, call `intacct-get-purchasing-transaction` (Intacct server) with `vendor-name` set to that vendor. Keep `document-number`, `reference-number`, `vendor-document-number`, `document-date`, `total`, `state` and `transaction-type`.
**Step 3: Match across**
A Procore purchase order matches an Intacct transaction when the Procore `name` equals the Intacct `reference-number`, `vendor-document-number` or `document-number` (ignore case and spaces). Same vendor and similar date is only a possible match, and must be labelled as one.
**Step 4: Report**
A table with each Procore purchase order, its vendor, the matched Intacct document and its total and state, or "no Intacct record". Then list Intacct transactions for these vendors that matched no Procore order. Give counts of matched, possible and unmatched.
**Rules & Guidelines:**
* `procore-get-materials-mgmt-purchase-orders` is on the Procore Resource Management server. `intacct-get-purchasing-transaction` is on the Intacct server.
* This prompt is read-only. Do not call any create or update tool on either server (no `intacct-create-*`, no `intacct-update-*`).
**Validation:**
* If the project has no purchase orders, say so and stop.
* If a vendor has no Intacct transactions at all, report the vendor as missing from Intacct rather than the orders as unmatched.Who it's for
One answer, three teams that use it
Accounts payable
Catch orders with no accounting record
See which approved orders have no Intacct purchasing document before the invoice arrives and cannot be paid.
Which approved materials purchase orders on Fabrikam Depot have no Intacct record?
Project accountants
Close out a project's orders
Check every order on a project against Intacct before cost reporting, with possible matches flagged for a person to decide.
Reconcile all materials purchase orders for Northwind Plaza with Intacct and give me the counts.
Buyers
Confirm orders were recorded
See whether the orders you raised in Procore reached accounting, and which Intacct documents have no order behind them.
Did the Contoso Warehouse orders I raised last month all make it into Intacct?
How it works
What PopdockAI does when you ask
You name the project in plain words. Your AI assistant reads both systems and reports the match, changing nothing and stopping if the project name is ambiguous.
Ask
You name the Procore project and optionally an order status.
Read
It reads the project's materials purchase orders in Procore and each vendor's purchasing documents in Intacct.
Match
It matches by reference and number, and labels same vendor and similar date as a possible match only.
Report
You get each order with its Intacct document, plus unmatched Intacct documents and counts.
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-materials-mgmt-purchase-orders
sage-intacct-get-purchasing-transaction
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
Orders accounting never saw, found early
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)
