web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Get customer rebate to affect cost/margin

(0) ShareShare
ReportReport
Posted on by 105

Hi,

in our business it is rather common that we have a customer bonus, a kick-back for large customers if they buy a certain quantity or for a certain amount during the year. This could also be tiered, if you buy this amount you get this percentage, if you buy more you get a larger percentage. During the year the bonus is posted to a balance account and in the end of the year a large credit note is created for the customer. In our current Ax 4.0 environment we have solved this with tweaking the commission functionality and some modifications. We have been experimenting with the customer rebate functionality for this in our Dynamics 365 environment, but have not managed to get the accrued posted amount to effect the cost/margin on the sales order line. Is that possible, have we missed some setting? Or is there some other Dynamics functionality that could help us. The agreements can look like this

Buy for 1 000 000 during the year - get 3% kick back in the end of the year

Buy for 2 000 000 during the year - get 4% kick back in the end of the year

Buy for more than 3 000 000 - get 5% kick back in the end of the year.

The customer does not commit to any of these, so it depends on how much they buy, how much % they get in the end of the year. In current solution we have a function that recalculates and reposts old transactions if the customer surpasses one of the % steps and the accrual need to be changed.

And we want the bonus to effect the margin on the sales order line.

BR


Anette

I have the same question (0)
  • nunomaia Profile Picture
    25 Moderator on at

    I have a made a small test and using customer rebate it created a customer credit for a total sales over a period. If you create 100 Sales Order to a customer over a determined period, it will hit the rebate goals and generate a credit / discount to that customer.  

    How are analyzing the Sales Order margin ?  

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Anette,

    I am wondering why you want to basically allocate the bonus that you give at the end of the year to the individual orders to get the margin adjusted.

    The bonus can be related to thousands of sales order lines, which makes things complex to calculate.

    Irrespective of that, do your managers check the individual sales order margins once again at the end of the year after a bonus has been granted? I have not seen something like that being done and wonder whether this is really needed and what information somebody takes out of this?

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 672 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 534 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 289 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans