How to clone database with no financial transactions?
Copy db :
In psql or your sql client:
CREATE DATABASE my_newdb WITH TEMPLATE my_old_db;
Note this will clone everything.
If you want to get rid of the transactions, you will need to delete everything in the acc_trans, ar, ap, and gl tables.
Also if goods and services are used, delete from invoice and inventory as well, and if wishing to clear out all orders, delete from
orderitems and oe.