A count of ecom customers with active orders who have no record in the D365 customer master. Until they are promoted, their orders cannot be billed and revenue cannot post.
At a glance
The headline count of commerce customers with at least one active, non-cancelled order who do not yet exist in the D365 customer master. A commerce order cannot become a D365 Sales Order, a free-text invoice, or GL revenue until the customer exists as a master record. Every customer in this count represents revenue that is committed on the commerce side but structurally blocked from posting in D365. It is the customer-level twin of the order-level Commerce Orders Without Business Central Sales Order card: fix the customer here and the blocked orders there clear in the same sync.
| What it counts | A distinct count of commerce customers (Shopify, BigCommerce, Adobe Commerce) with one or more active orders in the trailing window who have no matching D365 Customer record on the field-mapped key (typically email, external customer ID, or VAT/tax ID). Cancelled orders and quote-only customers are excluded. |
| Currency | This is a count, so it is currency-agnostic. Each underlying customer carries the blocked order value in commerce-platform currency plus the Reporting Currency equivalent in the drill-down. |
| Multi-Company | Each absent customer carries the expected D365 legal entity from the field map (by ship-to country, platform tag, or per-customer override). If the mapping is ambiguous, the customer is flagged so onboarding knows which entity to create the record in. |
| Time window | 7D (customers with active orders in the trailing 7 days) |
| Alert trigger | >10 with active orders absent (more than 10 customers with active orders and no D365 record fires the alert) |
| Roles | owner, finance, marketing, operations |
Calculation
Calculated automatically from your Microsoft Dynamics 365 data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US wholesale distributor on Finance & Operations plus BigCommerce B2B and Shopify Plus DTC, two legal entities (US Trade Inc, USD, and CA Trade ULC, CAD). The 7-day window covers 06 Apr 26 to 12 Apr 26.| Metric | Value |
|---|---|
| Ecom customers absent from D365 master (this card) | 17 |
| Of which B2B (BigCommerce / Adobe) | 6 |
| Of which DTC (Shopify) | 11 |
| Blocked order value behind the absent customers (7d) | $61,200 |
| Largest single blocked customer (Wholesale-X) | $18,400 |
| Customers also present in Dataverse but not promoted to D365 | 4 |
- 17 customers exceed the alert threshold of 10. The alert fired, and the drill-down ranks the 17 by blocked order value so onboarding works the biggest revenue first. The top customer alone, Wholesale-X, is holding $18,400 of orders that cannot be invoiced because there is no customer to invoice.
- The split between B2B and DTC drives different actions. The 6 B2B customers need manual onboarding (credit check, tax-ID validation, payment terms), so they sit with the AR team. The 11 DTC customers are usually auto-creatable: the standard sync flow can promote them with default settings, so they should clear on the next connector run unless a field is failing validation.
- 4 of these customers already exist in Dataverse but were never promoted to D365. That is a different failure mode: the record made it into the Common Data Service / Dataverse layer (perhaps from Dynamics 365 Sales) but the dual-write or promotion step into the F&O customer master never completed. Those four belong on the Customers in Dataverse Not Promoted to D365 card, and this card cross-references them so onboarding does not create a duplicate.
- The non-cross-channel sibling counts the same population from the D365 side. The Ecom Customers Absent from D365 card frames the gap as a connector-health metric; this cross-channel version frames it as revenue at risk by attaching the blocked order value. Both should agree on the headcount; if they diverge, the field-map key differs between them and onboarding should reconcile.
Sibling cards merchants should reference together
This card is the customer-level entry point into the ecom-to-ERP onboarding cluster. Pair it with these to close each gap.| Card | Why pair it with Ecom Customers Absent from D365 Customer Master |
|---|---|
| Ecom Customers Absent from D365 | The non-cross-channel twin. Same population framed as connector health rather than revenue at risk; headcounts should agree. |
| Customers in Dataverse Not Promoted to D365 | The subset that reached Dataverse but never completed dual-write into the F&O master. A different fix from a true greenfield create. |
| Commerce Orders Without Business Central Sales Order | The order-level consequence. Promote the customer here and the matching blocked orders there clear. |
| Ecom Orders Missing Matching D365 Free-Text Invoice | The downstream billing gap once the customer exists but the invoice still has not posted. |
| Active Customers | The successfully-mapped complement: customers who do exist in D365 and are transacting. |
| Power Automate Flow Failures (Ecom Integration) | When the auto-create flow is failing, this card explains why DTC customers are not clearing on their own. |
Reconciling against Microsoft Dynamics 365
Where to look in Business Central / Finance & Operations:Finance & Operations: Accounts receivable > Customers > All customers (search for the commerce email or external ID, expect no match) Finance & Operations: Data management > Dual-write > Customers (check whether the record stalled mid-promotion) Business Central: Sales > Customers filtered to the commerce external ID (no match = absent) Business Central: AL Extension connector logs (customer-create failures and validation errors)No native D365 screen lists “commerce customers who do not exist here yet”, because D365 cannot enumerate records it does not hold. The customer master only knows who is in it. This card builds the missing set by reading the commerce platforms and subtracting the customers already present in D365. Why our number may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| Field-map key choice | Either | If the field map joins on email but a customer was created in D365 under a different email (a buyer vs an AP contact), they show as absent here even though a record exists. Confirm the join key. |
| Sync timing | Card more inclusive | A customer whose order is < 15 minutes old may still be in Awaiting Sync; the auto-create flow has not run yet. The card counts them; a manual export run after the sync would not. |
| Dataverse staging | Card vs Dataverse view | A customer in Dataverse but not promoted to the F&O master counts as absent here. The Dataverse customer list would show them as present, which is why those rows are cross-referenced to the dedicated promotion card. |
| Multi-entity expectation | Either | A customer may exist in one legal entity but the field map expects them in another. They show absent for the expected entity even though a record exists elsewhere. |
| Quote-only customers | Card lower | A commerce customer with only quotes and no active orders is excluded by definition, so a manual list of all commerce contacts will be larger than this count. |