Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


How to add a commission for sales invoice in openerp?

on 8/22/14, 11:49 AM 2,239 views

I have a sales order of rs.100. When i create invoice to this sales order, Invoice created with rs 100. I want to add a commision rs 10. Then invoice total should be rs.90. how can i proceed for this?. I am adding one service type product "commision", with category "commision type". This commision type category default income account="commision account". I am adding this product in sales invoice with "-ve" cost. so this cost deducting from sales order and amount will go to "commision account ". Is this corect process or am i face any problems in accounting system. Correct me if i wrong. 

I am not sure the word "commission" fits in what you are describing. Normally, commissions are paid to sales agents and not deducted from sales order. So do you want to make a reduction of 10RS?

Eva Pinter
on 8/23/14, 3:56 AM

I want to add commision in sales invoice.

on 8/26/14, 10:22 AM
Michael Bos
On 8/23/14, 5:06 AM

Samba, I think Eva is right. Commision is normally something else.

But maybe this can help you.

Correct me if I am wrong but I think you have a product which you sell for 100RS and when a independent sales agent sells it. You are selling it to him for 90RS, so that he gets 10RS commision?

Then you could set up a sales list in which specific customers get a discount on certain products. This can be a fixed price as well as a percentage. But this would already show in your sales order, I hope that doesn't matter.

  1. To do this make sure you have all rights in sales module. Then look under the Section Header "Settings" for "Pricelist"
  2. Then click on this and click again on pricelist.
  3. Click on the create button.
  4. Give it any name you want.
  5. Then a little further down you can see  "add an item", click on this.
  6. Name it again (can be the same name)
  7. Then click on "add an item" again (also a little further then then where you have given this a name)
  8. Gives this name a rule like "10% commision" Or something descriptive so you can remeber it and know where it is used for.
  9. Then select the product or product categorie so OpenERP/Odoo knows which product(categorie) it needs to apply this rule on. You can also add a minimum quantity to this (when this applies only when selling 10+/50+/100+) but it's not neccesary.
  10. The sequence can be set where 0 is most important and 1 second most and so on. This is used in combination with the minimum order quantity(=MOQ). You can define which rule is most important (the one with the highest MOQ) and then the second and so on. (If this is usefull but not clear let me know I will explain this in detail).
  11. Under the section header "Price Calculation" you change "Based on" to Sale price. It says Price * (1+ x) + y . X can be seen as a percentage and y as an fixed addition or deduction. So if you use 10% commision it would be -0.1 (which equals 0.9 or 90%) and if you use a fixed deduction type -10.
  12. Save all the things you have just created and for this particular product it now works.
  13. One note on this, you need to this this seperatly for every product you want this for. Or skip step 9 where you select a product, but then it will be used on all your products.



Ben Bernard

--Ben Bernard--
| 4 3 6
Jakarta, Indonesia
--Ben Bernard--
Ben Bernard
On 8/22/14, 11:56 AM

There is a sale_commission module (at least for 6.1), maybe it'll help.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

3 follower(s)


Asked: 8/22/14, 11:49 AM
Seen: 2239 times
Last updated: 3/16/15, 8:10 AM