Connectors

/

2Checkout

/

Reconcile 2Checkout orders with Dynamics 365 Business Central invoices
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile 2Checkout orders with Dynamics 365 Business Central invoices
Check 2Checkout orders from 2026-10-01 to 2026-10-07 against Business Central invoices.
Of 18 orders, 15 are matched, 2 differ and 1 is missing from Business Central. - Amount differs: order 7781204, 2Checkout 480.00, invoice 518.40 (tax may explain it, flagged for review) - Billed but not posted: order 7781239 - Missing: order 7781251, Northwind Traders, 129.00 USD Want the full table with invoice numbers?
2Checkout
Sample figures. Your results come from your own account.
2checkout-get-order
2checkout-get-orderitem

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

2Checkout

2Checkout
Run it on your own 2Checkout data.

Connect 2Checkout, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Read

It reads the 2Checkout orders, skipping test orders.

2checkout-get-order
2checkout-get-orderitem

03

Find

It looks for the Business Central posted invoice, then an unposted document.

No items found.

04

Compare

It checks amount and currency, classifies each order and counts each class.

Your AI tool

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.

get-data

2checkout-get-order

Returns orders records from the 2Checkout connector (read-only). Accepts the filters defined on the tool, such as record identifiers, status and dates, and returns the matching rows.
get-data

2checkout-get-orderitem

Returns order items records from the 2Checkout connector (read-only). Accepts the filters defined on the tool, such as record identifiers, status and dates, and returns the matching rows.
Read only.Nothing in 2Checkout 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

Billing gaps found long before month end

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