How to Identify Duplicate Subscriptions in Work 365

Applies To: Work 365 Subscription Management, provider-synced subscriptions, model-driven app grids in Dynamics 365 / Dataverse

Overview

If you suspect duplicate subscriptions in Work 365, the fastest first check is to review Active Subscriptions and compare records by Subscription ID. Adding Subscription ID and Created On to the grid makes repeated records much easier to spot, but a matching Subscription ID should still be treated as a possible duplicate, not an automatic cleanup decision. That extra validation matters because Work 365 states that subscriptions must have a Provider and must be associated with both a Customer and a Billing Contract, and Work 365 also documents at least one known exception where the same provider-side Subscription ID can produce misleading results.

Before You Begin

Before starting, confirm that you can access:

Work 365 → Subscription Management → Subscriptions

Also confirm you can use the grid page’s Edit columns option. Microsoft documents Edit columns as the command used to add, remove, or reorder columns on a model-driven app grid page, and Apply saves those view changes for the current review.

Resolution

Step 1: Open Active Subscriptions

In Work 365, use the area selector in the lower-left corner and switch to Subscription Management. Then open Subscriptions and review Active Subscriptions. Work 365 documents Subscription Management as the area where subscription records are managed.

Step 2: Add the key review columns

On the grid page, select Edit columns. Then add:

• Subscription ID

• Created On

Microsoft documents Edit columns as the supported way to add, remove, or reorder columns on a grid page. These two columns make first-pass duplicate review much faster.

Step 3: Reorder the columns for easier comparison

Move Subscription ID and Created On to positions that are easy to compare side by side, then select Apply. Microsoft’s grid documentation states that the column editor can be used to add, remove, and reorder columns.

Step 4: Group by Subscription ID

Group the list by Subscription ID so repeated values appear together. In a model-driven app grid, this is the simplest first-pass method to identify possible duplicates. Microsoft documents the grid page as the place where users review records and adjust columns for clearer analysis.

Step 5: Review repeated Subscription IDs carefully

For any Subscription ID that appears more than once, compare at least these fields before deciding it is a true duplicate:

• Created On

• Provider

• Customer

• Billing Contract

• Product

These checks matter because Work 365 states that subscriptions must have a Provider and must be associated with both a Customer and a Billing Contract. Work 365 also states that subscription changes are tracked through License Change Logs, and that the License Change Log and subscription record have a strong dependency in the billing process.

How to Interpret the Results

If the Subscription ID appears only once

That record is not duplicated by this specific check.

If the Subscription ID appears more than once

Treat it as a possible duplicate, not an automatic cleanup candidate. That distinction is important because Work 365 documents a known exception for SYNNEX perpetual licensing: SYNNEX can reuse the same Subscription ID across multiple products in an order, which can cause overwrite behavior and generate multiple license change logs.

Recommended Next Step

Do not automatically remove the newest record just because it is newer. First, review the related License Change Logs for each suspected record. Work 365 documents License Change Logs as the audit history of quantity and price changes, and it states that the License Change Log represents the lifecycle of the subscription for billing purposes.

If you confirm that a subscription record should no longer be used for billing, Work 365’s documented best practice is to deactivate it rather than delete it. Work 365 explicitly says not to delete subscriptions if they are no longer needed, and its subscription guidance states that inactive subscriptions do not continue billing.

Troubleshooting

Duplicate-looking records keep reappearing after cleanup

Check the provider-side source and the Provider Account mapping before treating it as a purely local Work 365 issue. Work 365 documents Provider Account as the mapping between the provider and the CRM Account record, and it also documents that provider accounts are synced into Work 365 and then mapped to the correct Account.

The issue involves SYNNEX perpetual licensing

Handle this case carefully before deactivating anything. Work 365’s Known Issues page specifically documents that SYNNEX can reuse the same Subscription ID across multiple products in some perpetual provisioning scenarios, which can create multiple License Change Logs and overwrite behavior.

You need to validate data integrity after cleanup

Run the License Change Log Mismatch Report. Work 365 documents this report as the tool for finding subscriptions where License Change Logs are out of sync, and it states that action should be taken quickly if the report returns data.