Hi everybody,

I am trying to solve a tricky usecase in Odoo 14.

We want to sell product kits that can have components with different tax rates. According to our tax consultant, we need to account for each component individually from an accounting & invoice perspective. 

Example:
We sell a "Flower Bundle" containing one "Red Orchid" and a "Yellow Pot".
The Red Orchid would have a reduced tax rate of e.g. 10%, the Yellow Pot a standard tax rate of e.g. 20%. 

According to our tax consultant, the invoice must look somewhat like that:

Item	Unit Price	Quantity	Tax Rate	Total Price
Flower Bundle				€ 50,00
- Red Orchid	€ 15,00	2	10%	€ 30,00
- Yellow Pot	€ 20,00	1	20%	€ 20,00
Total Paid				€ 50,00
			Tax 10%	€ 3,00
			Tax 20%	€ 4,00

Problem #1:
Is that somehow possible with Odoo 14, without major customizations or even out-of-the-box?


Question #2:
A customer can purchase the components also individually, but of course at a higher price. Let's say that the individual sales price for a Red Orchid is € 20,00 and for the Yellow Pot it is € 30,00. This means, that the Flower Bundle comes at a discount: € 50,00 instead of € 100,00 (2x € 30 + 1x € 40). 
Now here comes the tricky part: In our Bundle example, we do not want to manually calculate each component's price individually every time we sell one. This should be calculated dynamically based on the individual item price. To do that, we need to calculate the weight of a component of an undiscounted bundle: €60 = 60% for the Red Orchid and €40 = 40% for the Yellow Pot. This means that in the Flower Bundle with a sales price of € 50, the Red Orchid is €50 * 60% = 30€ and the Yellow Pot is €50 * 40% = 20€ (see above invoicing table).
Is Odoo 14 somehow able to achieve that out-of-the-box?

Many thanks for your help.