Connectors

/

Microsoft Dynamics 365 Business Central

/

Add Dynamics 365 Business Central vendors to Ramp
Write
Cross-Connector

Add Business Central vendors to Ramp without re-keying

For finance teams who want new vendors in Ramp straight from Business Central, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Add Dynamics 365 Business Central vendors to Ramp
Which active Business Central vendors with Contoso in the name are missing from Ramp? Show me the list and I will tell you which to add.
2 Contoso vendors are missing from Ramp. - V00120: Contoso Supplies, ap@contososupplies.com, US - V00134: Contoso Freight, billing@contosofreight.com, CA - Cannot be created: Contoso Labs has no email on file - Possible match for review: Contoso Ltd looks like Contoso Limited in Ramp Which vendors should I create in Ramp?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
ramp-get-vendor
ramp-vendor-add

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central
Run it on your own Microsoft Dynamics 365 Business Central data.

Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Vendors set up in Business Central never quite make it into Ramp

Every new Business Central vendor has to be retyped into Ramp, and someone has to work out which ones are missing first. Vendors get skipped, misspelled or entered twice, and the gap shows up only when a bill cannot be paid.

Without PopdockAI

  • Compare the two vendor lists by eye
  • Retype names, emails and countries into Ramp
  • Create a second record for a vendor spelled differently
  • Find the missing vendor when a payment is held up

With PopdockAI

  • Active Business Central vendors are checked against Ramp
  • Close name matches go on a review list, not into Ramp
  • You pick which missing vendors to create
  • Each vendor is added with its vendor number 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 active Business Central vendors matching `{vendor-name}` (default: all, up to 50) that are missing from Ramp, show the list, and create only the vendors the user confirms in Ramp.

**Step 1: Read Business Central vendors**

Call `business-central-get-vendor` (Business Central server) with `blocked` empty or false, `name.contains` set to `{vendor-name}` when given, and `max-records` 50. Keep `vendor-number`, `name`, `email`, `country-code`, `state`.

**Step 2: Check Ramp**

For each vendor call `ramp-get-vendor` (Ramp server) with `name.contains` set to the vendor's name. Treat a vendor as existing if a Ramp vendor has the same normalised name (lower case, suffixes such as Inc, LLC, Ltd and punctuation removed). Possible matches that are not exact go on a separate list and are never created.

**Step 3: Present and confirm**

Show a table of missing vendors with `vendor-number`, `name`, `email`, `country-code`. List separately vendors that cannot be created because `email` or `country-code` is empty (Ramp requires both). Ask the user which vendors to create and wait for an explicit answer. Create nothing before that answer.

**Step 4: Create**

For each confirmed vendor call `ramp-vendor-add` (Ramp server) with `name`, `country` set to the Business Central `country-code`, `business_vendor_contacts_email` set to `email`, `state` when present, and `external_vendor_id` set to the Business Central `vendor-number`. Call one vendor at a time. After each, report the result; if one fails, say why and continue with the rest only if the user has said to.

**Step 5: Verify**

Call `ramp-get-vendor` again for each created vendor and report its new `id`.

**Rules & Guidelines:**

* `business-central-get-vendor` is on the Business Central server. `ramp-get-vendor` and `ramp-vendor-add` are on the Ramp server.
* The only write allowed is `ramp-vendor-add`, only after confirmation. Do not call `ramp-vendor-update`, `ramp-vendor-delete`, `business-central-create-vendor` or `business-central-update-vendor`.

**Validation:**

* If Business Central returns no vendors, say so and stop.
* If the user does not confirm, make no changes and say so.
* Never invent an email or country for a vendor that lacks one.

Who it's for

One answer, three teams that use it

Accounts payable

Pay new vendors without waiting on setup

New Business Central vendors reach Ramp with matching ids, so a bill is not held up because the vendor was never keyed in.

Which active Business Central vendors are not in Ramp yet? List them so I can choose which to add.

Finance operations

Keep vendor ids matched across both systems

Each vendor is created with its Business Central vendor number as the external id, which makes later reconciliation simple.

Add Fabrikam Supplies from Business Central to Ramp, using its vendor number as the external id.

Controllers

Stop duplicate vendors before they start

Close name matches are set aside for review instead of created, so Ramp does not end up with two records for one supplier.

Check Business Central vendors with Northwind in the name against Ramp and flag any that look like near duplicates.

How it works

What PopdockAI does when you ask

You name a vendor or leave it open, and your AI assistant compares Business Central with Ramp. Only the vendors you choose are created, and missing emails or countries are listed rather than invented.

01

Ask

You name a vendor, or leave it open to check up to 50 active vendors.

Your AI tool

02

Match

It compares each Business Central vendor with Ramp and sets close name matches aside for review.

ramp-get-vendor

03

Confirm

You see the missing vendors and pick which to create.

No items found.

04

Create

It adds each one to Ramp, one at a time, and reads it back.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

ramp-get-vendor

Returns Ramp vendors as read from the Ramp connector. Filters include: name contains, created at to, legal name contains, vendor owner id, maximum records.
run-action

ramp-vendor-add

Add vendor in Ramp. Writes to the live Ramp account. Not individually tested, so try it against a sandbox Ramp account first.
Read only.Nothing in Microsoft Dynamics 365 Business Central 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

Every vendor ready to pay in Ramp, keyed once

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