I am currently running Odoo v13 Community Edition and I need help with adding a specific field. The field I want to edit the discount field so that first of all it is not printed in the sales_order report.

Secondly, the behavior required is as follows:

Scenario 1:

If a discount is added the unit price is changed automatically to the discounted value

Scenario 2:

If the unit price is changed, the discount price is calculated automatically from the price in the pricelist. It would be better if there is a checkbox or something that activates this functionality as sometimes the unit price changes without any discounts added.

I do not know if what I want to do is possible or not but I think it is doable. My problem is that I am not experienced in using Odoo so I need any help I can get. I do not understand relationships or how queries in python work.

Please its urgent I need your help.

Thank you in advance