Skip to Content
Menu
This question has been flagged
3 Replies
2998 Views

I have a need for the construction industry and gardening. 

I need to sell different sets of products on one sale order, one set of product could be for example building 1 m² of a terrace or cutting 10 meters of an hedge. 

When I sell 1 m2 of terrace, i actually need to sell automatically : 

-3 hours of work 
-1.5 bag of concrete
-0.6 hours of machine usage 
-Other components.. (long list sometimes)

But obviously if I make a 20 m² terace, I want all the quantities to be multiplied by 20. 

And on the same sale order, I will need to sell 45 meters of edge cutting, that has different components. 

I don't know how I can build my quotation easily in odoo because we can only set one quotation template and there are too many combinations possible between set of products to create them all. Also, using the quotation template does not allow me to multiply the quantity. 

The manufacturing app does not work for service products, and does not allow us to create field service tasks and use the planning like we should.  Moreover, the details of what has been used is not available for the customer, which is a problem. 

So I am wondering what the best solution can be ? 



Avatar
Discard
Best Answer

Hi Hugo

Depending on the Odoo version and the possibility to install third party apps, a simple and efficient solution already used by the community for a long time would be for you to install "Sale product set": https://odoo-community.org/shop/product/sale-product-set-2334#attr=9582

BR

Ricardo Gross

Avatar
Discard
Best Answer

You could define these products as KITs (BOM), so the qty / multiples would be applied only on the specific KIT. 

This would mean you could have 20 m² terrace along with 45 mts of edge cutting on the same SO.

However, the limitation with standard Odoo would be the KIT product would be 1 SO line and NOT 1 line per component. The challenge would be if there is need to invoice individual components having different tax rates.

If the need for component is for information purposes only, you could always use the sales description field to put down the component and qty information.

Or apply any small customization that would break down the KIT BOM line in SO to individual component lines. (not being a developer am unable to help here)!

Avatar
Discard
Best Answer

A small development might resolve this, here is a prototype:

1. Create a custom field on the Sale Order so Users can enter a line multiplier and add it to the UI:


2. On create or on change of the sale order line, update the quantity based on the multiplier (this code works on change but it might be better to do this on create only):

This sample code comes from a custom field (to validate the prototype) but would be implemented via a module:

COMPUTE:

for record in self:
    record['x_onchange_trigger'] = False
        if record.product_uom_qty > 0:
            multiplier = record.order_id.x_multiplier
            if multiplier > 0:
                record['product_uom_qty'] = record.order_id.x_multiplier * record.product_uom_qty

DEPENDENCIES:
product_uom_qty


3. When the multiplier is 0, everything will have a quantity of 1 and can be edited to any other quantity:



4. When the multiplier is > 1, everything will have quantity to match the multiplier (and for this prototype - each time the User enters a quantity it will be multiplied by 45 - but you can modify this by leveraging on create instead of on change):


This is just a prototype, the User would have to change 45 back to 0 or to another multiplier if they wanted the next things they add to the Sales Order to not use 45 as the quantity.  It may or may not work for your case and there could be a better design/code.

Avatar
Discard
Related Posts Replies Views Activity
3
Sep 24
2701
1
Aug 24
455
2
Feb 24
1886
2
Jan 24
16495
1
Oct 23
4198