This question has been flagged

Hi,

I want delete transaction table only like PO, SO, MRP, ECO, Journal Item, Journal Entries.

Is there any possibility to delete transaction tables all at once.

Thanks in advance.


Avatar
Discard

like this one: https://apps.odoo.com/apps/modules/10.0/app_odoo_customize/ ? (data cleaning section )
i wouldn't advise it though.

Best Answer

Hi,

It's not possible to delete a record if any existing reference is available. Deleting records directly from the database can lead to data inconsistencies and may violate referential integrity. So it's better to create a new database or archive records; they will still be available for historical reference. Odoo provides options for archiving records in many modules.


Hope it helps

Avatar
Discard