Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
3 Replies
7282 Tampilan

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 build and develop

I wish this to be done without having to duplicate the database as this is not currently possible.

Please is this possible and how do I go about it?

Avatar
Buang

hhhhmmmm i usually access the database through pgadmin or psql and delete the related transaction manually using query but you need to take a note you should do it carefully and you need to understand the flow this method is not recommended

Jawaban Terbai

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.

Avatar
Buang
Jawaban Terbai

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

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
Odoo server error Diselesaikan
5
Jul 23
50614
2
Agu 19
5647
0
Apr 18
4315
0
Nov 24
3876
0
Apr 16
4143