I don't know this works or not but,
try to update the fields is pgadmin,
maybe this will write the old dates.

Thank You

Hi Jenish M, thanks for your answer.
I am using odoo online, is it possible to update the fields in pgadmin in my case?
If so, how should I do it?

Thank you.

Hi,

For anyone looking for an answer, this worked for me:

Create an excel with the old data you want to import, and make sure it works (you can try first exporting some data you already have)

You'll be able to import all the data you want, except for the state of the order (which will be Quotation by defect.)

If you just validate that quoatation, the order date will be the current date, and we don't want that.
Instead of this, you need to create a new action.

Go to Server actions (in Settings / Technical / server Actions), and create a new action.

Name: (whichever name you want, in my case "Test Old Sales")
Model: Sales Order
Action: Update the record
Field: State
Evaluation type: value
Value: sale

Now, go to the Sales dashboard, select the sales you just imported (and that are Quotations) and in the Actions you should see the action you just created.

That's it :)

Hope it helps someone!

@Maria Senyer
I have used your solution it did change the status but it did not show its effect in move history any idea how it can be done?

@krakalien no idea. I know my solution does not affect in move history. I would also like to know how to do it.

Thanks for you answer, I tried this way before, but I didn't effect in stock valuation layer, because Odoo calculate it once the user validate the (Delivery/ Receipt )orders. actually this is the main problem!