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.

Release: 
FAQ Category: