How to clone database with no financial transactions?

Member for

1 month 1 week
Submitted by Anonymous (not verified) on Wed, 11/16/2011 - 18:07

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