Connectors

/

Sage Intacct

/

Create an Intacct customer for a Procore bid customer
Write
Cross-Connector

Add a bid customer to Intacct only if it is missing

For accountants who want the customer on a Procore bid board project created in Intacct, without duplicates, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Create an Intacct customer for a Procore bid customer
Make sure the customer on the Riverside Tower bid board project exists in Intacct, and create it if it is missing.
The customer on Riverside Tower is Contoso Development, and Intacct has no customer with that name or a close one. - Name: Contoso Development - Print as: Contoso Development - Customer id: assigned by Intacct - Status: Active Shall I create it?
Sage Intacct
Sample figures. Your results come from your own account.
procore-get-estimating-bid-board-projects
sage-intacct-get-customer
sage-intacct-create-customer

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Sage Intacct

Sage Intacct
Run it on your own Sage Intacct data.

Connect Sage Intacct, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Retyping a bid customer creates a second record

After a win, the customer from the Procore bid board is keyed into Intacct by hand. If the existing customer was spelled differently, a duplicate appears and billing is split between two records.

Without PopdockAI

  • Open the bid board project and copy the customer name
  • Search Intacct under every spelling you can think of
  • Retype the customer if nothing turns up
  • Find the duplicate when invoices split

With PopdockAI

  • The customer is read from the bid board project
  • Intacct is checked by exact and partial name before anything is created
  • Any match stops the run, and you see the existing record
  • Creation waits for your explicit yes and is 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:** Make sure the customer company on the bid board project `{bid-board-project-name}` exists in Intacct, creating it only if it is missing and the user confirms.

**Step 1: Read the project (Procore)**

Call `procore-get-estimating-bid-board-projects` with `name` set to `{bid-board-project-name}`. If more than one project matches, list them and stop. Keep `customer-company-name`. If it is empty, stop and say the project has no customer.

**Step 2: Check Intacct for the customer**

Call `intacct-get-customer` with `customer-name` set to the customer company name, then with `customer-name.contains` if nothing returns. If a match exists, report its customer-id and status and stop: do not create anything.

**Step 3: Confirm, then create**

Show the user the customer record you would create: `name` and `print-as` set to the Procore customer company name, `customer-id` set to `{customer-id}` if given (otherwise leave it for Intacct to assign), and `status` active. Ask for an explicit yes. Only after a yes, call `intacct-create-customer` once. Then call `intacct-get-customer` again to confirm it exists and report the customer-id.

**Rules & Guidelines:**

* Tools whose names start with procore are on the procore-preconstruction server. Tools whose names start with intacct are on the intacct server. Both servers must be connected.
* The only write allowed is one call to `intacct-create-customer`, after a yes. Do not call any Procore write tool, including `procore-create-bid-board-project`, `procore-update-bid-board-project`, `procore-delete-bid-board-project`, `procore-create-estimating-bid-board-projects-notes`, `procore-create-estimating-bid-board-projects-tasks`, `procore-create-cost-item`, and do not call `intacct-update-customer` or any other Intacct write tool.
* `intacct-create-customer` is built Inactive and untested end to end; if the call is rejected, report that and stop.

**Validation:**

* Never create a customer when a name match already exists, even a close one; show it and ask.
* If the user says no or does not answer, create nothing.
* Do not retry a failed create.

Who it's for

One answer, three teams that use it

Accountants

Set up customers from won bids

Add the customer from a won bid to Intacct without searching under every spelling or retyping the name.

Make sure the customer on the Northwind Plaza bid board project exists in Intacct.

Estimators

Hand a win over cleanly

After a win, get the customer ready for billing without sending a request to accounting.

The Fabrikam Warehouse bid was won. Check that its customer is in Intacct and add it if it is not.

Credit controllers

Keep one record per customer

Stop a new customer being created when a close match already exists, and see the match first.

Check whether the customer on the Contoso Medical Centre bid already exists in Intacct before anything is created.

How it works

What PopdockAI does when you ask

You name the bid board project. Your AI assistant checks Intacct first, shows you the record and creates it once, only after your yes.

Ask

You give the bid board project and, if you have one, the customer id to use.

Your AI tool

Check

It reads the customer company from Procore and searches Intacct by exact and partial name.

procore-get-estimating-bid-board-projects
sage-intacct-get-customer

Confirm

If nothing matches, you see the exact customer record and say yes.

No items found.

Create

It creates the customer once and reads it back to report the customer id.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Sage Intacct and one secure connection to your AI tool. No code, no exports.

get-data

procore-get-estimating-bid-board-projects

Returns Procore Preconstruction bid board projects, with status and the assigned estimator.
get-data

sage-intacct-get-customer

Returns customers from Sage Intacct.
run-action

sage-intacct-create-customer

Creates a customer in Sage Intacct Accounts Receivable. Returns the new customer's record number and customer ID.
Read only.Nothing in Sage Intacct 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

One customer record, created once and confirmed

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