• Registered: 06/03/2008
  • Posts: 2

Topic: Clear all transactions

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?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Clear all transactions

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