Is there a way to clear a database of all posted transactions, stock movement and activity without changing configurations and settings in the modules? (Odoo V8)

Question

Here is what i want to do

- I have created a database and i want to use it for testing so to this effect, many transactions and product movement will occur within the database. However, I wish to use this same database as a production(live database).

- I want to know if it is possible to clear all transactions and activities within the database without having to uninstall and re-install the modules in which they occur because the modules have custom fields and menus that took alot of time to b

Jim · Accepted Answer

have tried this but the problem is the sequence or the id of the transactions, i have a problem locating where i can reset the sequence for these transactions, hope you can also help me .. errors occur when creating new entries for that cleared database.

Rajesh Narayanan T K · Answer

Go to Settings -> Technical -> sequences and Identifier -> Sequences. Find the required objects and Sequence code and reset the required one. Eg : purchase Order. Type PO in search filter and open the record and change the next number to 1. You can reset any sequence code

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Odoo server error Ratkaistu hr database odooV8	5 heinäk. 23	51864
How to search through a database? database odooV8 odoo8.0	2 elok. 19	6379
Dockerizing Odoo for tests: "odoo Skipping database as its base version is not 8.0.1.3" database odooV8 Docker	0 huhtik. 18	5351
Override odoo base_import? database importing odooV8	0 marrask. 24	4848
How to decide when to use select=True database index odooV8	0 huhtik. 16	5047

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!