/
/
Reconcile ActiveCampaign orders with Dynamics 365 Sales
For finance teams who want their AI assistant to match a customer's ActiveCampaign orders to Dynamics 365 Sales orders and invoices.
On this page
Connector
Connect ActiveCampaign, pick your AI tool and paste the prompt.
The problem
Web shop orders and CRM orders that do not agree
Finance has to compare ActiveCampaign orders with Dynamics 365 Sales orders and invoices line by line. Amounts can be stored in cents and totals drift, so the differences are hard to trace.
Without PopdockAI
- Export a customer's orders from ActiveCampaign
- Find the customer in Dynamics 365 Sales
- Pull their sales orders and invoices
- Match line by line and total by hand
With PopdockAI
- Orders are read for one customer from a date you choose
- Matching goes by order number, then amount and date
- Each match is labeled by how it was made
- Currency differences are flagged and cents are checked, with no writes
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the customer with email `{email}`, check that orders recorded in ActiveCampaign appear in Dynamics 365 Sales. Look back to `{from-date}` (an ISO date, optional; when empty use all dates).
**Step 1: Orders in ActiveCampaign**
Call `activecampaign-get-ecomorder` (server: ActiveCampaign) with `email` set to `{email}` and, when a date is given, `order-date.from` set to it. Keep order number, date, currency and total.
**Step 2: Find the customer in Dynamics 365 Sales**
Call `dynamics-365-sales-get-contacts` (server: Dynamics 365 Sales) with `email` set to `{email}` and take `parent-customer` (or `full-name` when empty).
**Step 3: Orders and invoices in Dynamics 365 Sales**
Call `dynamics-365-sales-get-salesorders` with `customer.contains` set to that name and, when a date is given, `created-on.from` set to it. Call `dynamics-365-sales-get-invoices` the same way.
**Step 4: Report**
Match orders by order number first, then by amount and date within three days. Show matched, ActiveCampaign only and Dynamics 365 Sales only. Give totals per side and the difference. Label each match "by number" or "by amount and date".
**Rules & Guidelines:**
* `activecampaign-get-ecomorder` is on ActiveCampaign; `dynamics-365-sales-get-contacts`, `dynamics-365-sales-get-salesorders`, `dynamics-365-sales-get-invoices` are on Dynamics 365 Sales.
* This prompt is read-only. Never call any create, update, add or delete tool on either server, including `activecampaign-contact-add`, `activecampaign-contact-update`, `activecampaign-contact-sync`, `activecampaign-contact-delete`, `activecampaign-note-add`, `activecampaign-deal-add`, `activecampaign-deal-update`, `activecampaign-contacttag-add`, `dynamics-365-sales-create-lead`, `dynamics-365-sales-create-contact`, `dynamics-365-sales-create-account`, `dynamics-365-sales-create-opportunity`, `dynamics-365-sales-create-note`, `dynamics-365-sales-create-task`, `dynamics-365-sales-create-case`, `dynamics-365-sales-create-phone-call`, `dynamics-365-sales-update-lead`, `dynamics-365-sales-update-contact`, `dynamics-365-sales-update-account`, `dynamics-365-sales-update-opportunity`.
**Validation:**
* If the customer is not in Dynamics 365 Sales, report the ActiveCampaign orders as unmatched and say why.
* Do not convert currencies; flag differing currencies instead.
* Amounts in ActiveCampaign may be in cents: check the scale before comparing and state what you assumed.Who it's for
One answer, three teams that use it
Finance analysts
Reconcile a customer's orders quickly
See which ActiveCampaign orders have a sales order or invoice in Dynamics 365 Sales and which do not.
Reconcile orders for priya@contoso.com between ActiveCampaign and Dynamics 365 Sales since 1 October.
Accounts receivable
Find orders that were never invoiced
Spot web shop orders with no matching invoice so billing can be followed up.
Do all of tom@fabrikam.com's ActiveCampaign orders have a matching invoice in Dynamics 365 Sales?
Sales operations
Check the shop to CRM hand off
Confirm that orders captured online reach Dynamics 365 Sales with matching totals.
Compare the order totals for lena@adventure-works.com in ActiveCampaign and Dynamics 365 Sales.
How it works
What PopdockAI does when you ask
You give a customer email and your AI assistant reads the orders from both systems. It matches them and reports the gaps, and it never writes to either account.
Ask
You give the customer's email and, optionally, a start date.
Read
It reads the customer's ActiveCampaign orders and finds the customer in Dynamics 365 Sales.
Match
It matches orders to sales orders and invoices by number, then by amount and date.
Report
You get matched and unmatched orders, totals per side, the difference and how each match was made.
What PopdockAI provides
The tools behind the answer
Ready made tools for ActiveCampaign and one secure connection to your AI tool. No code, no exports.
activecampaign-get-ecomorder
microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-salesorders
microsoft-dynamics-365-sales-get-invoices
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 gaps and total differences made visible
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)
