/
/
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.
On this page
Connector
Connect Ramp, pick your AI tool and paste the prompt.
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.
**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.
02
Find
It looks up each Ramp order in Business Central by order number.
03
Compare
It checks totals in the same currency and compares Ramp spend with the invoiced amount.
04
Report
You get a table per outcome with billing and receipt status and counts.
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.
ramp-get-purchase-order
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.
The outcome
Order differences caught while the order is still open
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.

.webp)
