Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

How to give discount on the total of a Sales order

Subscribe

Get notified when there's activity on this post

This question has been flagged
discount
22 Replies
63087 Views
Avatar
Max

Hello,

In sales order, we can give discount on per line basis. What about the discount on the total figure? Sometimes we give a lump sum discount on the sales order, without that, we need to adjust discount on each line.

Thanks.

5
Avatar
Discard
Acespritech Solutions Private Limited

Hello ! Is pricelist feature helpful for you ? But again its on particular line only.

Zahin

http://goo.gl/foA1pQ, Discount on total for sale order and invoice too.

Avatar
Gusto
Best Answer

Hello,

We have developed a module which allow users to apply discount (Fixed Amount, Percentage) on Sales and Customer Invoice.

The module also allow user to display the discount on Sales and Invoice report.

Once you Validate the invoice, the module generate the Journal Entries. You can track the discount on P/L report by creating a separate account for the discount which you just have to configure in the company. This account will be used to post the entries of the discount account.

Hope this module will ease everyone's life.

For now, the module is developed for v7 only and we are on the way to migrate it in v8 and v9 as well.

Download: Discount Sales / Invoice

0
Avatar
Discard
Avatar
Alessandro Dell'Anna
Best Answer

Hope this can help you .... I have coded a little function (apply_discount) in a inherited class of sale.order

def apply_discount(self, cr, uid, ids, discount_rate):
        cur_obj = self.pool.get('res.currency')
        res = {}
        line_obj = self.pool.get('sale.order.line')
        for order in self.browse(cr, uid, ids, context=None):

            for line in order.order_line:

                line_obj.write(cr, uid, [line.id], {'discount': discount_rate}, context=None)

        return res

I have added a new column to the new inherited sublass of sale order

'discount_rate' : fields.float('Discount rate'),

Then in the sale order view (a inherited one) I have placed the new field (discount) on the sale.order.view and I have fired an event on the "on_change" of the value passing the self value of the field to the "on_change" event

<field name="discount_rate" on_change="apply_discount(discount_rate)"/>

In this way you can apply discount sequentially to the rows of the order without altering the normal process of OpenERP

3
Avatar
Discard
Luis Lozano

Hi, great answer Alessandro, I have Open ERP online and I am new in this, where do I go to insert the code that you mentioned? Thanks!

ABU K

Is this total amount from sale order will affect invoice ?

Avatar
joseph d'souza
Best Answer

Hello

I have developed one module which set a discount on whole sale order and customer invoice with fixed and percentage vise. when your quote will move to invoice that same discount and total will move to the invoice I think this module feature will helps you more can see on : http://www.youtube.com/watch?v=RTRB0xq9Y38&feature=youtu.be To get the module can contact me: dsouzajoseph199@gmail.com

3
Avatar
Discard
Vikram

Good to your video in Youtube regarding discount. Can you share your module with me?

Arbi Khelifi

Hi Joseph, I just viewd your video on youtube, it's really great work!, I'm really interested in this feature and wonder if possible to get the module as indicated in your post. Thanks

Lerner

Hi Joseph, I saw your video good work can I get those module please to work with Odoo discount feature.

Sudhir Arya (ERP Harbor Consulting Services)

Good work Joseph. I am wondering how you are dealing with accounting entries? Are you creating accounting entries based on discounted amount?

Pawan Kumar Sharma

Hi Joseph,

Can you share your module with me?

Avatar
Geetha
Best Answer

Our custom module for sale discount and invoice discount [Fixed & Percentage Discounts] supported For odoo10  & odoo9 .Even discount is passed to invoice when sale order is converted to invoice. 

https://github.com/euroblaze/eb_sales_invoices_discounts

0
Avatar
Discard
Avatar
Keenmeng Lew
Best Answer

Have you tried this - https://www.odoo.com/documentation/user/9.0/point_of_sale/advanced/manual_discount.html?


KM

0
Avatar
Discard
Avatar
Andreas Brueckl
Best Answer

Here are some approaches:

  • You can try to use module additional_discount. But when reading the comments it seems that the module is not as stable as it should be.
  • You can set the same discount in every line
  • You can use a separate Discount product and give it a negative unit price. This solution would give an absolute discount instead of a relative.
0
Avatar
Discard
michel Guénard

how do you manage the tax (VAT) issue with a global discount, specifically when your invoice is made with products having different tax percentages?

Alessandro Dell'Anna

VAT is applied to the single net price discounted or not ....

Avatar
Shahar Or
Best Answer

You can use pricelists and the Prices Visible Discounts app (product_visible_discount).

0
Avatar
Discard
Avatar
jamesbale
Best Answer

You can use payment term, in payment term you can define your rule

0
Avatar
Discard
Avatar
patrick
Best Answer

In order to give discounts on the whole order, you have to use pricelists.

You can find them under: Sales -> Pricelists under the text 'Configuration' -> Pricelist

NB:

If you do not have 'Configuration', give the user the access rights 'Technical Features'

If you do not see Pricelist, give the user the access rights 'Sales Pricelists'

Now you can create a new pricelist, which you probably want to base on the default pricelist. I use in the title of the pricelist the amount of discount I give (5% discount, 10% discount, ....). Play around to find the correct value(s).

In the order it is important to change the pricelist, before adding any products, otherwise the discount is not calculated.

Important notice:

When using a discount like this, it will not show up on the discount line, but it will change the value of the product, so an article costing €10, and using a discount of 10% will show with a costprice of €9.

0
Avatar
Discard
Flyguy

The problem with pricelists is that the customer doesn't see the discount. So even though he received a discount, the customer may still ask for a discount, because he can't see that he already received one. My advice is to make a custom module for this. That's what we did.

patrick

Same here, only issue we had was to find the original price, as there are different 'base' prices, depending on the currency. And for some exeptions, the base price is different than all the other base prices.... But I fixed it.

Avatar
Zahin
Best Answer

Complete Solution for Discount on sale tota, discount on invoice total, with report.

http://goo.gl/foA1pQ

and

http://goo.gl/YWw9JW

 

 

-3
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Special rates for non profit organisations
discount
Avatar
Avatar
Avatar
2
Sep 25
1141
Tracking, paying and posting customer rebates based on sales volumes. Solved
discount
Avatar
Avatar
1
Oct 25
2626
Discount visible on the bill in the point of sales Solved
discount
Avatar
Avatar
1
Feb 24
2088
Warranty in a product and discount when taking yearly subscription
discount
Avatar
0
Dec 23
1573
discount / repair -quote
discount
Avatar
0
Jun 23
1983
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now