Connectors

/

Microsoft Dynamics GP

/

Onboard a Dynamics GP customer
Write

Set up new Dynamics GP customers once, addresses and email included

For sales and finance teams who want a new Dynamics GP customer created without duplicates and in their ID style, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Onboard a Dynamics GP customer
Set up Fabrikam Inc. in Seattle as a new Dynamics GP customer with salesperson SAM and email ap@fabrikam.com.
No customer or prospect looks like Fabrikam Inc. in Seattle. - Customer ID: FABRIKAM001, in your existing style - Address: 400 Pine Street, Seattle - Salesperson: SAM, valid - Email: ap@fabrikam.com Shall I create the customer? Credit limit and holds are not set.
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-prospect
microsoft-dynamics-gp-get-rm-salesperson
microsoft-dynamics-gp-rm-customer-add
microsoft-dynamics-gp-rm-customer-address-add
microsoft-dynamics-gp-rm-customer-address-email

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics GP

Microsoft Dynamics GP
Run it on your own Microsoft Dynamics GP data.

Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

New customers set up twice under slightly different names

Setting up a new Dynamics GP customer starts with a search, because the business may already exist as a customer or prospect under another name. Then come the card, ship-to address, email and an ID in your house style.

Without PopdockAI

  • Search customers and prospects by name, city and phone
  • Invent an ID that follows your house style
  • Key the customer card, ship-to address and email separately
  • Merge the duplicate that slipped through

With PopdockAI

  • Customers and prospects are searched by name, city or phone
  • A likely match stops the setup
  • An unused ID in your house style is proposed
  • Customer, ship-to and email are created in order 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:** Set up `{customer-name}` as a new customer with id `{customer-id}` (default proposed) from `{details}`, without creating a duplicate, after the user confirms.

Pass `{company}` as `company` on every call (if it is empty, omit `company` and the default company is used). Pass a generous `max-records` (1000). If a result comes back with exactly that many rows, say the result may be truncated.

**Step 1: Duplicate check**

* `dynamics-gp-get-rm-customer` with `customer-name.contains` using the most distinctive word of `{customer-name}`, and again by city or phone if given. Show likely matches and stop if one looks like the same business.
* `dynamics-gp-get-rm-prospect` with `customer-name.contains`: if the business is already a prospect, suggest the `convert-prospect-to-customer` prompt instead and stop unless the user says continue.

**Step 2: Validate references**

* If a salesperson is named, confirm it with `dynamics-gp-get-rm-salesperson`.
* If `{customer-id}` is empty, propose one in the style of existing ids (look at a few from Step 1) and check it is unused with `dynamics-gp-get-rm-customer` by `customer-id`.

**Step 3: Confirm**

Show the user exactly what will be written, field by field, and ask for explicit confirmation. Do nothing further without a clear yes. Show id, name, class, address, city, state, zip, country, phone, contact, terms, salesperson, email, and any ship-to address.

**Step 4: Write**

1. Call `dynamics-gp-rm-customer-add` once with the confirmed customer fields.
2. If a separate ship-to address was given, call `dynamics-gp-rm-customer-address-add` once with `customer-id`, `address-code` and its fields.
3. If an email was given, call `dynamics-gp-rm-customer-address-email` once with `customer-id`, `address-code` (the primary address code unless it belongs to the ship-to) and `email-address`.

Run each step only if the one before succeeded. If a later step fails, say which parts were created. Do not retry a failed write automatically. Report the error exactly as returned.

**Step 5: Verify**

Call `dynamics-gp-get-rm-customer` by `customer-id` and report the stored record.

**Rules & Guidelines:**

* The only write tools this prompt may call are `dynamics-gp-rm-customer-add`, `dynamics-gp-rm-customer-address-add` and `dynamics-gp-rm-customer-address-email`, once each, after Step 3.
* Do not set a credit limit or hold; neither is part of onboarding here.

**Validation:**

* If the proposed customer id is taken, propose another and confirm again.

Who it's for

One answer, three teams that use it

Sales reps

Get a new account trading quickly

Set up the customer, ship-to and email in one conversation, so the first order is not held up.

Set up Contoso Pharma in Boston as a new Dynamics GP customer, salesperson JLEE, email ap@contosopharma.com.

Sales administrators

Keep the customer list free of duplicates

Existing customers and prospects are searched first, so the same business is not set up twice.

Add Northwind Health in Chicago to Dynamics GP, but check it is not already a customer or prospect.

Credit controllers

Start from a complete record

Address and email are in place from day one, and holds and limits are left for you to set.

Create a Dynamics GP customer for Fabrikam Retail in Austin with a separate ship-to at their warehouse.

How it works

What PopdockAI does when you ask

You give the customer's name and details, and your AI assistant checks Dynamics GP for an existing match first. Nothing is written until you have seen every field and confirmed.

01

Ask

You give the customer's name and details.

Your AI tool

02

Check

It searches customers and prospects by name, city or phone and stops on a match.

microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-rm-prospect
microsoft-dynamics-gp-get-rm-salesperson

03

Confirm

You see every field and the proposed ID in your house style.

No items found.

04

Create

It creates the customer, ship-to address and email in order and reads it back.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Microsoft Dynamics GP and one secure connection to your AI tool. No code, no exports.

get-data

microsoft-dynamics-gp-get-rm-customer

Returns customer records from Dynamics GP Receivables Management, including contact details, class, terms and balances. Filter by salesperson ID, hold, customer name, state, zip, customer balance, customer class and city, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-prospect

Returns sales prospects from Dynamics GP Receivables/Sales, including name, contact, address, phone and customer class. Filter by prospect ID, state, customer name, zip, contact person, created date, customer class and city, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-salesperson

Returns salesperson records from Dynamics GP Receivables Management, including territory, contact details, commission rates and year to date sales. Filter by employee ID, first name, salesperson ID, inactive, last name and sales territory ID, and pick the company and the maximum number of records.
run-action

microsoft-dynamics-gp-rm-customer-add

Adds a customer in Dynamics GP through eConnect; GP defaults any field not listed. Requires customer name and customer ID. Optional: country, state, contact person, customer class, address 1 and use customer class. Writes to the live Dynamics GP company database.
run-action

microsoft-dynamics-gp-rm-customer-address-add

Adds customer address in Dynamics GP through eConnect; GP defaults any field not listed. Requires address code and customer ID. Optional: address 1, state, country, address 2, contact person and zip code. Writes to the live Dynamics GP company database.
run-action

microsoft-dynamics-gp-rm-customer-address-email

Adds or updates a customer address email in Dynamics GP through eConnect; GP defaults any field not listed. Requires customer ID and address code. Optional: email address. Writes to the live Dynamics GP company database.
Read only.Nothing in Microsoft Dynamics GP 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 clean customer record, ready to trade

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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