Get rid of the mess I created in my database (v17.2)

Question

Since I am new to Odoo and clueless, I have created a dreadful mess while trying to undo the PO that posted to current date rather than transaction date. Fortunately it's only one PO and subsequent inventory records.
Is there a way as admin to clean up the mess, delete the transactions, pour bleach over them? Or, do I have to ask the powers-that-be to re-create my database? I am on monthly subscription or "Standard" so can't do that myself

Joan Nicholson · Answer

The database is super fresh, very little in it. Eradicating it and starting over is probably the most time effective solution, however, I like your suggestion of running a query. Would be great practice and there is nothing to lose.

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
If you need to clean up the entire db, using the server action, you can run a query and clear the data from all the db tables and reset the sequence values to 1.
You can get the model details from here:   https://github.com/odoomates/odooapps/blob/17.0/om_data_remove/models/model.py [1]
Other option is if the db is very fresh and it not much configurations are done, you can drop the current db and start using a fresh one.

Thanks

[1] https://github.com/odoomates/odooapps/blob/17.0/om_data_

Related Posts	ตอบกลับ	มุมมอง
delete or remove test records clean Delete	1 มิ.ย. 20	10731
Delete all New Delete	2 เม.ย. 24	2343
Invoice Reversal as Invoice Corrected invoice reverse	2 มิ.ย. 23	5160
Admin User Deleted. How can I restore it ? ooo v16 แก้ไขแล้ว users Delete	1 ม.ค. 23	2289
reset demo data without configurations data clean	0 มี.ค. 15	5382

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!