Microsoft Dynamics 365Microsoft Dynamics 365Prowi

Prowi for Microsoft Dynamics 365

Opportunities and orders from Dynamics Sales, with corrections when they change.

LivePå roadmappet

How the Dynamics 365 integration works

Prowi reads won opportunities from Dynamics 365 with value, stage, close date, owner, products and the custom fields you choose, and calculates commission live by your plan. The rep sees the amount in the app straight away. If an opportunity changes later, it is recalculated and the difference lands on the next statement as a correction.

Connect

Authorise Microsoft Dynamics 365. Read-only access to the fields you choose.

Calculate

Every won deal gets its commission calculated by your plan, in seconds.

Notify

The rep sees the amount in the app. If the deal changes later, a correction follows.

Questions

Does Prowi integrate with Dynamics 365?

Yes. Prowi connects to Dynamics 365 with read-only access and pulls opportunities and the fields you choose. Commission is calculated live and the rep sees it in the app.

How fast does data sync?

Live. Changes in Dynamics 365 reach Prowi continuously, so the rep’s numbers follow the deal with no manual steps.

Can we use custom fields?

Yes. Any field on the deal can drive a rule: discount, deal type, contract length, strategic flag.

What if an opportunity changes after close?

Prowi recalculates the original period with today’s data and applies the difference to the current statement, with the change listed line by line.

How long does setup take?

Most teams connect, map fields and run their first plan within a few days. No developer needed.

Automate Commissions Directly from Microsoft Dynamics 365

With Prowi's Microsoft Dynamics 365 CRM integration, commission and bonus calculations become a natural part of your sales process. No more spreadsheets. No manual errors. Just real-time data that ensures transparency and motivates your sales team. Dynamics 365 is Microsoft's leading CRM platform, and with Prowi you get a commission solution that leverages all the data you're already tracking in your pipeline.

Many companies still use Excel to calculate commissions, even though they've invested in Dynamics 365. This creates a bottleneck where data must be exported, manipulated, and verified manually. With Prowi's Dynamics 365 integration, you eliminate this step entirely. Commissions are calculated automatically based on the opportunities and activities that already exist in your CRM.

From Opportunity to Commission, Fully Automated

When an opportunity closes in Dynamics 365, the data is sent directly to Prowi. Here, commissions are calculated according to your specific rules, and the rep can see their expected payout immediately in the Prowi app. This means sales reps no longer have to wait for month-end to gain insight, and management no longer has to spend time on manual calculations.

The flow is simple: A rep marks an opportunity as Won in Dynamics 365. Prowi automatically receives information about the amount, products, account, and other relevant fields. Based on your commission model, Prowi calculates the correct commission, and the rep sees the amount in their app within seconds. No waiting. No uncertainty.

What syncs from Dynamics 365

Prowi reads opportunities from Dynamics 365 and uses them as the basis for commission. The integration only reads the fields you choose and never writes anything back to Dynamics 365.

  • Data: estimated revenue, status reason, actual close date, owner, product line items and the custom fields you choose.
  • Direction: one way, from Dynamics 365 to Prowi. Prowi has read-only access.
  • Frequency: live. When an opportunity is created, changed or won, the calculation updates.
  • Changes after close: Prowi recalculates the original period and puts the difference on the next open statement as a correction.

Prowi's integration pulls the data you need for accurate commission calculations. Estimated Revenue is naturally central, but the integration goes deeper than that. We sync Status Reason, so you can tie commissions to specific phases in your sales process. Product Line Items are transferred, enabling differentiated rates across different product lines. Account information ensures that deals from different customer segments are handled correctly.

Actual Close Date is another important parameter. With this information, Prowi can automatically place commissions in the correct period, whether you settle monthly or quarterly. Owner is also transferred, so commissions are attributed to the right rep, even in complex team structures.

Additionally, the integration supports Dynamics 365 Custom Fields. If you've created fields to track special conditions that affect commissions, these can also be included in calculations. This could be anything from discount percentages to deal type, contract length, region, or strategic importance. This flexibility means Prowi can handle even complex commission models without requiring changes to your Dynamics 365 setup.

How to set up the Dynamics 365 integration

  1. Connect Dynamics 365 in Prowi with a user that can see the relevant opportunities. Prowi only gets read access.
  2. Choose the pipelines and fields to include. Prowi only reads what you select.
  3. Map the fields to the plan: who owns the opportunity, which date decides the period, and which amounts count.
  4. Build the commission plan and run a shadow calculation on a closed period. Compare it with your spreadsheet before you go live.
  5. Invite the reps to the app. From then on every won opportunity is calculated automatically.

What you can calculate with Dynamics 365 data

Dynamics 365 is often used by companies that already run on Microsoft and pay commission on margin and quota attainment. Typical models are accelerators and margin-based commission, and every model can be combined with rules for cancelled deals and corrections.

Many Dynamics customers pay more the higher the rep’s quota attainment. Prowi shows each rep how close they are to the next step.

Integration with the Microsoft Ecosystem

For companies already working within the Microsoft ecosystem, the Dynamics 365 integration provides a natural extension. Data flows from your CRM to Prowi, so sales data stays in Dynamics 365 while commission is calculated, approved and shown to reps in Prowi.

Benefits of the Integration

Real-time commission visibility: Reps can see their commission immediately when an opportunity closes in Dynamics 365. There's no delay between winning a deal and knowing what it's worth in dollars and cents. This immediate feedback creates a stronger connection between effort and reward.

Automated calculations without errors: Manual spreadsheets are a source of errors. Wrong formulas, copied data, forgotten updates. With Prowi, these risks are eliminated. Calculations happen automatically using the same rules every time, and results can be audited down to individual opportunities.

Full transparency for everyone: Both reps and management can follow how commissions are calculated. Reps don't just see a number; they can drill down into the opportunities that make up their commission. Management gets an overview of the team's total performance and can identify trends early.

Scalability without complexity: As companies grow, commission models often grow with them. New products, new teams, new markets. With Prowi, you can add complexity without losing control. Split commissions, tiered rates, accelerators, and other advanced models are handled just as easily as a simple percentage-based model.

Compliance and audit trail: Prowi stores a complete audit trail of all calculations, changes, and payouts. During audits, you can quickly document how commissions were calculated and why any adjustments were made.

Who Benefits from the Integration

For sales reps, the integration means they always know where they stand. They can see their accumulated commission, understand how it's calculated, and plan their efforts accordingly. Motivation increases when the reward is visible and understandable. Reps often report feeling more recognized when they can see the results of their work immediately, rather than waiting until month-end.

For sales managers, Prowi provides a new tool for managing the team. They can see who's performing, who needs support, and how the commission structure affects behavior. It becomes easier to set goals and follow up on them. Managers can also experiment with new commission models and see the effects in real-time, without waiting for the next payroll run.

For finance teams, the integration significantly reduces the monthly workload. Commission data is already calculated and ready for export to the payroll system. Errors are detected automatically, and audit trails ensure documentation for audits. Instead of spending days collecting and verifying data, finance can focus on analysis and strategic advice.

Get Started with Prowi and Dynamics 365

The Microsoft Dynamics 365 integration can be set up quickly, and within just a few days your commissions can run fully automated. Book a demo today and experience how Prowi and Dynamics 365 together can free up time, create transparency, and boost motivation in your sales team.

Whether you have a simple commission model or a complex structure with split commissions and accelerators, Prowi adapts to your needs. Start by connecting your Dynamics 365 organization and see results immediately.