콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
3 답글
7270 화면

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?

아바타
취소

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

베스트 답변

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.

아바타
취소
베스트 답변

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

아바타
취소
관련 게시물 답글 화면 활동
Odoo server error 해결 완료
5
7월 23
50597
2
8월 19
5642
0
4월 18
4293
0
11월 24
3869
0
4월 16
4131