/
/
Reconcile 2Checkout orders with Business Central invoices
For finance teams who confirm every order was billed, by asking their AI assistant to compare 2Checkout orders with Business Central sales invoices.
On this page
Connector
Connect 2Checkout, pick your AI tool and paste the prompt.
The problem
Unbilled orders found at month end
Finance matches 2Checkout orders to Business Central invoices line by line in spreadsheets. Orders that were never billed, or billed for the wrong amount, usually surface at month end.
Without PopdockAI
- Export orders from 2Checkout
- Search Business Central posted invoices
- Check unposted documents too
- Compare amounts and currencies by hand
With PopdockAI
- Orders read from 2Checkout, test orders skipped
- Posted invoice found, then any unposted document
- Each order classified by amount and currency
- Rounding and tax differences shown, nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For 2Checkout order `{order-reference}`, find the Business Central sales document that billed it and compare the amounts. If `{order-reference}` is empty, check every order from `{order-date-from}` to `{order-date-to}` (dates as YYYY-MM-DD, default the last 7 days).
**Step 1: Read the order in 2Checkout**
If an order reference was given, call `2checkout-get-order` with `external-reference` set to `{order-reference}`; if nothing comes back, call `2checkout-get-orderitem` and match on `reference-number`. If no reference was given, call `2checkout-get-orderitem` with `order-date.from` and `order-date.to` and group the lines by `reference-number`. Note `reference-number`, `status`, `currency`, `gross-discounted-price` and `order-date` for each order. Skip orders with `test-order` true.
**Step 2: Find the invoice in Business Central**
For each order call `business-central-get-posted-sales-invoice` with `external-document-number` set to the 2Checkout `reference-number`. If nothing is returned, call `business-central-get-sales-transaction` with the same `external-document-number` to find an unposted invoice or order.
**Step 3: Compare**
Compare 2Checkout `gross-discounted-price` with Business Central `total-amount-including-tax`, and `currency` with `currency-code`. Classify each order as Matched, Amount differs, Currency differs, Billed but not posted (only found by `business-central-get-sales-transaction`), or Missing from Business Central.
**Step 4: Report**
Give a table with one row per order: reference, order date, 2Checkout amount, Business Central document number, Business Central amount and classification. Finish with counts per classification.
**Rules & Guidelines:**
* Tools named the 2checkout prefix are on the 2checkout server and tools named the business-central prefix are on the business-central server. Both servers must be connected.
* This is a read-only job. Never call any 2checkout or business-central create, update, add, order or subscription action tool.
* Business Central tools take an optional company parameter; only use it if the user named a company.
**Validation:**
* If 2Checkout returns no orders, say so and stop.
* Differences under 0.01 are rounding and count as Matched.
* A Business Central amount that differs because of tax may be legitimate; show both figures and flag it for review instead of calling it an error.
Who it's for
One answer, three teams that use it
Billing specialists
Invoice orders that were missed
Orders with no Business Central invoice are classified as missing.
Which 2Checkout orders from last week have no Business Central invoice?
Accountants
Post documents left unposted
Orders billed but not posted are listed so they can be posted.
Show 2Checkout orders this month that are billed but not posted in Business Central.
Controllers
Check one order end to end
Give a single order reference to see its invoice and any difference.
Check 2Checkout order 882100 against Business Central.
How it works
What PopdockAI does when you ask
You give an order reference or a date range, and your AI assistant looks for the Business Central invoice behind each order. Tax differences are shown for review rather than called errors.
01
Ask
You give an order reference or a date range.
02
Read
It reads the 2Checkout orders, skipping test orders.
03
Find
It looks for the Business Central posted invoice, then an unposted document.
04
Compare
It checks amount and currency, classifies each order and counts each class.
What PopdockAI provides
The tools behind the answer
Ready made tools for 2Checkout and one secure connection to your AI tool. No code, no exports.
2checkout-get-order
2checkout-get-orderitem
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
Billing gaps found long before month end
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)
