Hello All,

We did some customization on Sales Order to add a start date and end date for a quotation. Now, normally Sale Order has a single date called quotation date that is used by the pricelist to calculate prices and ,if a start date and end date is given on the pricelist line, it fetches the price based on the quotation date which does not cause any overlapping. For Example:

Pricelists

Pricelist 1 - Jan 1,2023 -  March 4, 2023 - USD. 100

Pricelist 2 - March 5, 2023 - May 8, 2023 - USD 200

Quotation Date

Feb 4, 2023

By default Odoo will automatically take pricelist 1 as the price for the product.

Our scenario is a s follows,

Pricelists

Pricelist 1 - Jan 1,2023 -  March 4, 2023 - USD. 100

Pricelist 2 - March 5, 2023 - May 8, 2023 - USD 200

Quotation Date

Feb 4, 2023 - April 6, 2023

Now we have overlapping dates 

from Feb 4 - Mar 4 we have 100

From March 5, April 6 we have 200

What kind of mechanism can we use to solve this overlapping issue and how can we come up with a price?

Thank You