Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
3 Odpowiedzi
7102 Widoki

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?

Awatar
Odrzuć

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

Najlepsza odpowiedź

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.

Awatar
Odrzuć
Najlepsza odpowiedź

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

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
5
lip 23
50290
2
sie 19
5491
0
kwi 18
4105
0
lis 24
3686
0
kwi 16
3985