Connectors

/

Ramp

/

Reconcile Ramp purchase orders to Dynamics 365 Business Central
Report
Cross-Connector

Reconcile Ramp purchase orders to Business Central

For operations and procurement teams who want Ramp orders checked against Business Central, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Ramp purchase orders to Dynamics 365 Business Central
Compare Ramp purchase orders created since 1 September with Business Central and tell me which ones differ or have been overspent.
21 of 26 Ramp purchase orders match Business Central. - Different total: PO-2087, 8,400.00 in Ramp vs 8,100.00 in Business Central - Not found: PO-2093 and PO-2101 - Overspent: PO-2075, Ramp spend 5,000.00 vs 4,200.00 invoiced - Unmatchable: 1 order has no purchase order number Want billing and receipt status for the matched orders?
Ramp
Sample figures. Your results come from your own account.
ramp-get-purchase-order

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 runs ahead of Business Central and nobody sees it

Purchase orders are raised in Ramp and in Business Central separately and compared by hand. Totals drift, orders exist on one side only, and nobody sees Ramp spend running ahead of what Business Central invoiced.

Without PopdockAI

  • List Ramp purchase orders since a date
  • Find each order in Business Central
  • Compare totals and invoiced amounts in a spreadsheet
  • Notice the overspend after the order closes

With PopdockAI

  • Each Ramp order looked up by order number
  • Orders not found and different totals reported
  • Ramp spend beyond the invoiced amount flagged
  • Same currency only, and nothing changed or archived

The prompt

Use this prompt

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

Prompt
**Objective:** For Ramp purchase orders created from `{created-from}` (optionally with name containing `{po-name}`), find the matching Business Central purchase order and compare amounts and billing progress. Read-only.

**Step 1: Read the Ramp orders**

Call `ramp-get-purchase-order` (Ramp server) with `created-at.from` set to `{created-from}`, `name.contains` set to `{po-name}` when given, and `max-records` 100. Keep `id`, `purchase-order-number`, `name`, `amount`, `currency-code`, `spend-total-amount`, `billing-status`, `receipt-status`.

**Step 2: Find each order in Business Central**

For each order call `business-central-get-purchase-transaction` (Business Central server) with `document-type` Order and `document-number` set to the Ramp `purchase-order-number`. If nothing returns, mark the order as not found in Business Central (the tool cannot filter by the vendor's own order number). Keep `document-number`, `buy-from-vendor-name`, `total-amount-including-tax`, `total-outstanding-amount`, `status`, `order-date`.

**Step 3: Report**

Table per outcome: matched and equal; matched with a different total; Ramp orders not found in Business Central; matched where Ramp `spend-total-amount` exceeds the Business Central invoiced amount (total minus outstanding). Show `billing-status` and `receipt-status` beside each. Finish with counts.

**Rules & Guidelines:**

* `ramp-get-purchase-order` is on the Ramp server; `business-central-get-purchase-transaction` is on the Business Central server.
* Read-only. Do not call `ramp-purchase-order-update`, `ramp-purchase-order-archive`, `business-central-create-purchase-order` or `business-central-update-purchase-order`.

**Validation:**

* If Ramp returns none, report that and stop.
* If a Ramp order has no purchase order number, list it as unmatchable.
* Compare amounts only when currencies agree; otherwise show both values.

Who it's for

One answer, three teams that use it

Purchasing managers

Keep both copies of an order aligned

Orders missing from Business Central or with a different total are listed.

Compare Ramp purchase orders since 1 October with Business Central.

Budget owners

Spot spend beyond the invoiced amount

Orders where Ramp spend exceeds what Business Central invoiced are flagged.

Which Ramp orders have more spend than Business Central has invoiced?

Accounts payable

See billing and receipt status together

Billing and receipt status sit next to each order for follow-up.

Reconcile Ramp POs with Marketing in the name against Business Central since 1 August.

How it works

What PopdockAI does when you ask

You give a start date and your AI assistant reconciles Ramp purchase orders with Business Central. Orders with no number are listed as unmatchable.

01

Ask

You give a start date and optionally part of an order name.

Your AI tool

02

Find

It looks up each Ramp order in Business Central by order number.

ramp-get-purchase-order

03

Compare

It checks totals in the same currency and compares Ramp spend with the invoiced amount.

No items found.

04

Report

You get a table per outcome with billing and receipt status and counts.

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-purchase-order

Returns Ramp purchase orders as read from the Ramp connector. Filters include: name, maximum records, currency code, created at from, name contains.
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

Order differences caught while the order is still open

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