Connectors

/

Ramp

/

Review a vendor's Ramp spend and Dynamics 365 Business Central balance
Report
Cross-Connector

See a vendor's Ramp spend and Business Central balance

For finance teams who want one view of a vendor across Ramp and Business Central, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review a vendor's Ramp spend and Dynamics 365 Business Central balance
Give me a full picture of Northwind Traders: what we spend through Ramp and what we still owe in Business Central.
Northwind Traders is active in Ramp but blocked in Business Central. - Ramp spend: 6,400 in 30 days, 58,900 in 365 days - Ramp open: 3 unpaid bills totalling 9,150, plus 1 unused credit of 400 - Business Central: balance 9,900, balance due 4,300 - Difference in open totals: 750, more than 1 percent, so flagged Want the individual open bills and invoices listed?
Ramp
Sample figures. Your results come from your own account.
ramp-get-vendor
ramp-get-bill
ramp-get-vendor-credit

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Ramp

Ramp
Run it on your own Ramp data.

Connect Ramp, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Ramp spend and Business Central balances are never side by side

To judge one vendor, someone pulls spend from Ramp and open balances from Business Central separately. A vendor blocked in Business Central can stay active in Ramp, and open amounts that disagree go unnoticed.

Without PopdockAI

  • Pull vendor spend and open bills from Ramp
  • Pull the balance and open invoices from Business Central
  • Compare open amounts by hand
  • Miss a vendor blocked in one system only

With PopdockAI

  • Ramp spend, open bills and unused credits read
  • Business Central balance and open invoices beside them
  • Blocked vendors and differences over 1 percent flagged
  • Ambiguous names stop the review, and nothing changed

The prompt

Use this prompt

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

Prompt
**Objective:** Give one view of the vendor matching `{vendor-name}` across Ramp and Business Central: spend and open bills in Ramp, balance and open invoices in Business Central. Read-only.

**Step 1: Ramp side**

Call `ramp-get-vendor` (Ramp server) with `name.contains` set to `{vendor-name}`. If more than one matches, list them and stop. Keep `id`, `active`, `total-spend-last-30-days`, `total-spend-last-365-days`, `total-spend-all-time`. Then call `ramp-get-bill` (Ramp server) with `vendor-name` set to the vendor's exact name and list bills whose `payment-status` is not paid. Call `ramp-get-vendor-credit` (Ramp server) with `vendor-id` set to the vendor's `id` for unused credits.

**Step 2: Business Central side**

Call `business-central-get-vendor` (Business Central server) with `name.contains` set to `{vendor-name}`; if several match, pick the one whose email or country agrees with Ramp, else list them and stop. Keep `vendor-number`, `blocked`, `balance`, `balance-due`, `payment-terms-code`. Then call `business-central-get-posted-purchase-invoice` (Business Central server) with `buy-from-vendor-name` set to the vendor name and keep only rows with a positive `remaining-amount`.

**Step 3: Report**

A short summary: vendor identity on both sides, Ramp spend by period, Ramp open bills total, Ramp unused credits, Business Central balance and balance due, open Business Central invoices total, and the difference between the two open totals. Flag: blocked in Business Central but active in Ramp, open amounts that differ by more than 1 percent, and overdue items on either side.

**Rules & Guidelines:**

* `ramp-get-vendor`, `ramp-get-bill` and `ramp-get-vendor-credit` are on the Ramp server; `business-central-get-vendor` and `business-central-get-posted-purchase-invoice` are on the Business Central server.
* Read-only. Do not call any create, update, delete or archive tool on either server.

**Validation:**

* If the vendor exists on only one side, report that side and state clearly the other has no record.
* If the two systems use different currencies, show both and do not compute a difference.

Who it's for

One answer, three teams that use it

Finance managers

Review a vendor before a renewal

Spend over 30 days, a year and all time sits next to what is still owed.

Give me Contoso Software's Ramp spend and Business Central balance.

Accounts payable

Spot open amounts that disagree

Open totals that differ by more than 1 percent are flagged.

Do open bills for Fabrikam in Ramp agree with Business Central?

Procurement

Catch blocked vendors still in use

Vendors blocked in Business Central but active in Ramp are called out.

Is Northwind Traders blocked in Business Central while still active in Ramp?

How it works

What PopdockAI does when you ask

You name a vendor and your AI assistant combines Ramp and Business Central in one review. It says plainly when the vendor exists on one side only.

01

Ask

You name the vendor.

Your AI tool

02

Ramp

It finds the vendor and reads spend, unpaid bills and unused credits.

ramp-get-vendor
ramp-get-bill
ramp-get-vendor-credit

03

Business Central

It reads the vendor's balance, balance due and open posted invoices.

No items found.

04

Report

You get one summary with the difference in open totals and any flags.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Ramp 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.
get-data

ramp-get-bill

Returns Ramp bills as read from the Ramp connector. Filters include: vendor name, approval status, id, vendor name contains, due date to.
get-data

ramp-get-vendor-credit

Returns Ramp vendor credits as read from the Ramp connector. Filters include: id, created at to, created at from, maximum records, remaining amount currency code.
Read only.Nothing in Ramp 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

Spend, balances and risks for a vendor in one review

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