<![CDATA[FrontAccounting forum — Clear all transactions]]> https://frontaccounting.com/punbb/viewtopic.php?id=223 Tue, 10 Jun 2008 06:49:19 +0000 PunBB <![CDATA[Re: Clear all transactions]]> https://frontaccounting.com/punbb/viewtopic.php?pid=688#p688 There are links to 0_gl_trans from Customer Transactions, Supplier Transactions, Item adjustments etc. You will not be able to follow these links if you delete the GL trans.
You can see in the ER Diagram which tables are related. It can be found on the download document page.

/Joe

]]> Tue, 10 Jun 2008 06:49:19 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=688#p688 <![CDATA[Clear all transactions]]> https://frontaccounting.com/punbb/viewtopic.php?pid=687#p687 I want to delete all transactions leaving category, customer lists, bank accounts etc details behind. Which table I need to empty?

0_bank_trans
0_gl_trans

i only aware of above two tables. any other table i need to clear?

]]> Tue, 10 Jun 2008 04:02:38 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=687#p687