Breaking news from around the world
Get the Bing + MSN extension
Master planning setup wizard Watch this video as a guide for the Master planning setup wizard. It explains how parameter suggestions are calculated and also provides examples that show how different companies set up master planning, based on their business needs.Learn more
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
Our client wants to give the salesperson commission based on the actual profit.
The purchase order amount is $2000
The sales order amount is $1000
Gross profit = 2000 - 1000 = 1000
the salesperson gets a 10% commission from the gross profit. In this scenario, he gets 100 dollars.
Does standard ax does have this functionality available?
I know in ax we have an option to set up a sales commission based on the sales order revenue.
Do we need to do customization for this?
Thanks in advance.
I don't understand your scenario here. The purchase order amount is higher than the sales amount. Shouldn't it be a loss here?
Oh my god I typed wrongly. Extremely sorry for my mistake. Yes you are right. My purchase amount is 1000$ and sales amount is 2000$ . My gross profit here is 1000 ( Gp = sales - purchase ) .
The sales person gets 10 % from my gross profit. He should get $100 as his commision .
Does standard ax has this feature available? Or I should do customization to achieve this ?
Thanks in advance
Does standard ax has this feature available? Or I should do customization to achieve this?
Had you tried to use margin for the commission calculation?
I will try that option and will let you know. Thanks for your response :)
There is an option to set the commission calculation based on the margin. I haven't used the commission feature for about 12 years, so not sure how it will deal with several item cost models and inventory recalculations. You can actually test some setup and various use cases.
In the past, a customer wanted to have a margin per batch. In that scenario, we enabled the batch inventory dimension also to include financial cost.
Thanks, Andre for your response.
I tried selecting Margin for sales commission calculation but it does not work for me.
Please refer to the below screenshots which explains how I tried this.
Sales commission setup:
Commission sales group:
Commission Item group:
Commission Customer group:
Commission posting :
Assigned 50200 - commission bonus account
Assigned 60500 - Commission income account as commission offset
Commission calculation :
Assigned the commission customer group to the customer.
For an example: Assigned "IS" commission customer group to customer account C00001
Assigned the commission Item group to the Item.
For an example: Assigned "IS" commission Item group to Item Number: 0.0.463.65 (this is a service item)
The item model group is service. ( We act as a distributor between vendor and customer. The vendor will directly deliver the item to the customer .
Therefore we don't have inventory. All our items will be service item)
Created Purchase order via a direct delivery form:
Here my gross profit is 500-400 = 100 (GP= sales amount - purchase amount)
Invoiced the purchase order and sales order.
I think it does commission based on the sales revenue.
The expected commission should be $5.
My purchase amount is 400, the sales amount is 500
The gross profit is 100
Now Casey should receive 5% from 100 dollars which should be $5
Please suggest me if I missed any setups.
Business Applications communities