Filter license by Office/country/city

You are here:
< Back

A unique ability that Sync 365 License provides, is to be able to filter your Office 365 licenses to split billing up for your clients.

Use case: You have a client which has multiple locations. They have a single Office 365 tenant, however they allocate costs to each location for the licenses.
With Sync 365 License, you have the power to help them automate their billing, but splitting out their Office 365 invoicing based on their staff location.
This allows you to send them different invoices to the relevant connectwise company for their location.

How to filter licenses

To get started, add the clients office 365 tenant and link it to the relevant company in connectwise that you would like to bill for this location.

To leverage this capability, we use fields in the user accounts in Azure AD (Office 365). You can use one or multiple of the following fields in a user account to filter the licenses:
Office, Country, State or City
Names are case sensitive. For example if you were setting up users for a New York office, you may use “New York” either in City or Office in the Office 365 user settings.

In the agreement sync configure the filtering as follows.

  1. If you would like to exclude any licenses from being filtered, tick them first. (i.e. head office may pay for all advanced threat protection licenses so you could tick for those to be excluded from filtering.)

2. Click the “Filters” button
3. Enter in text to the attribute you would like to figure. I.e. in Office enter the office name you have set in the user profiles in Office 365
NOTE: This is an “and” style filter, so if you enter in an office and a country, it will be looking for both of those details in a user account.
4. Click apply

It will take a while to filter the results, however we will grab the user accounts that match the filter and you will only see the licenses applied to those users.

You can now link those licenses to an agreement as normal.

Add another location

Now that you have set up a license sync for that location you can add the Office 365 tenant and link it to the next location for that company in Connectwise. You can then repeat the process to invoice that specific location.