Connectors

/

ActiveCampaign

/

Reconcile ActiveCampaign orders with Dynamics 365 Sales orders
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile ActiveCampaign orders with Dynamics 365 Sales orders
Check that the orders for dana@northwindtraders.com in ActiveCampaign appear in Dynamics 365 Sales since 1 September.
4 ActiveCampaign orders: 3 matched in Dynamics 365 Sales and 1 is missing. - Matched by number: INV-1042 and INV-1051 - Matched by amount and date: order 5017, 1,250.00 within two days - ActiveCampaign only: order 5023, 380.00 - Totals: 3,980.00 in ActiveCampaign vs 3,600.00 in Dynamics 365 Sales Want me to look at another customer?
ActiveCampaign
Sample figures. Your results come from your own account.
activecampaign-get-ecomorder
microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-salesorders
microsoft-dynamics-365-sales-get-invoices

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

ActiveCampaign

ActiveCampaign
Run it on your own ActiveCampaign data.

Connect ActiveCampaign, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

Read

It reads the customer's ActiveCampaign orders and finds the customer in Dynamics 365 Sales.

activecampaign-get-ecomorder
microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-salesorders
microsoft-dynamics-365-sales-get-invoices

Match

It matches orders to sales orders and invoices by number, then by amount and date.

No items found.

Report

You get matched and unmatched orders, totals per side, the difference and how each match was made.

Your AI tool

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.

get-data

activecampaign-get-ecomorder

Returns ActiveCampaign e-commerce orders with the fields and filters the connector exposes. Read only.
get-data

microsoft-dynamics-365-sales-get-contacts

Returns Dynamics 365 Sales contacts. Filter by full name, email, city, job title, state, parent customer, created date and status, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-salesorders

Returns Dynamics 365 Sales orders. Filter by name, total amount, created date, customer, owner, order ID and status reason, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-invoices

Returns Dynamics 365 Sales invoices. Filter by name, customer, invoice ID, created date, total amount, status reason and due date, and cap how many records come back.
Read only.Nothing in ActiveCampaign 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 gaps and total differences made visible

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation