Skip to Content
Menu
This question has been flagged
2 Replies
191 Views

Odoo offers the possiblity to apply the a percentage discount on sales order lines, and that results in a nice visual indication with strikethrough and new price.

But if you have a product with a listprice of 4868 euro, and as a sales person i want to sell it at 4500 ... i would prefer to be able to enter that. instead of having to calculate the percentage and apply that.


how would we do this ?

Avatar
Discard
Best Answer

Hello there,

If you wish to show the customer, the sales price of the product has been changed, as in a discount on sales order lines,

  • Then, click the Discount button, choose the Fixed amount & enter the desired amount.

  • which creates another sales order line with a negative unit price, or else create a "Discount" as product name with Service type & all to the sales order line with a negative unit price



The preview would be,



Avatar
Discard
Best Answer

Hi,


A better way is to add a new field called “Net Price” on the sales order line. With this field, the salesperson just types the final price they want to sell at (e.g., 4500). Odoo will then automatically calculate the correct discount percentage in the background and apply it. That way:


    The salesperson works directly with the real selling price they agreed on.


    Odoo still shows the discount percentage and the strikethrough list price on the quotation, so the customer sees the discount clearly.


Try with the following code,


Python


class SaleOrderLine(models.Model):

    _inherit = "sale.order.line"


    net_price = fields.Float(

        string="Net Price",

        help="Final selling price entered directly by the salesperson."

    )


    @api.onchange('net_price')

    def _onchange_net_price(self):

        for line in self:

            if line.net_price and line.price_unit:

                # Calculate discount %

                discount = (1 - (line.net_price / line.price_unit)) * 100

                line.discount = max(discount, 0.0)


XML


<record id="view_order_form_net_price" model="ir.ui.view">

        <field name="name">sale.order.form.net.price</field>

        <field name="model">sale.order</field>

        <field name="inherit_id" ref="sale.view_order_form"/>

        <field name="arch" type="xml">

            <xpath expr="//field[@name='order_line']/tree/field[@name='discount']" position="after">

                <field name="net_price"/>

            </xpath>

            <xpath expr="//field[@name='order_line']/form/field[@name='discount']" position="after">

                <field name="net_price"/>

            </xpath>

        </field>

    </record>



Hope it helps

Avatar
Discard
Related Posts Replies Views Activity
1
Jan 25
1809
2
Nov 24
1158
1
Feb 24
1491
0
Dec 23
1131
2
Aug 23
2602