What you can do with Microsoft Dynamics 365 in Sylus
Sylus gives Dynamics 365 users an AI data analyst on top of their CRM and ERP data. Ask "How did pipeline change by region this quarter?" or "Which items are below safety stock?" and get numbers, charts, and dashboards. A good fit for teams on Dynamics 365 Sales, Business Central, or Finance and Operations who need reports without waiting on IT.
How the Microsoft Dynamics 365 integration works
Sylus connects through the Microsoft Dataverse and Dynamics 365 APIs, signing in with a Microsoft Entra ID (formerly Azure AD) app registration that has read-only access. It reads the tables you select, such as accounts, opportunities, sales orders, and general ledger entries, and keeps them up to date for reporting.
Questions you can ask about your Microsoft Dynamics 365 data
Finance
Which customers have invoices more than 60 days overdue?
How did gross margin change month over month this year?
What are our top 10 expense accounts this quarter compared to budget?
What collections are due in the next 30 days?
Sales
What are our top 20 customers by revenue this year?
Which salespeople closed the most revenue this quarter?
Which products are growing fastest compared to last year?
What is our average order value by customer group?
Operations and inventory
Which items are below safety stock?
What is our open purchase order value by vendor?
Which vendors delivered late most often this quarter?
What is our inventory value by location?
Leadership
How are revenue and margin trending against last year?
Which departments are over budget this quarter?
What were our biggest cost changes compared to last quarter?
Give me a weekly summary of sales, margin and receivables.
How to connect Microsoft Dynamics 365 to Sylus
You need a Microsoft Entra ID admin to register an app, and a Dynamics 365 admin to give it read-only access.
In the Microsoft Entra admin center, register an app for Sylus and create a client secret.
In Dynamics 365, add the app as an application user and assign a security role with read-only privileges.
In Sylus, add Microsoft Dynamics 365 as a data source and enter your environment URL, tenant ID, client ID, and secret.
Choose the tables you want to sync.
Environment URL format: https://yourorg.crm.dynamics.com

