• From: Egypt, Al Mansurah, Dakahlia
  • Registered: 07/23/2019
  • Posts: 23

Topic: How to clean the database from transactions?

How can I delete all transactions in the program so that the invoice number resets to 1, while keeping the data of items, categories, suppliers, customers, and quantities?

  • From: USA, CA, Valencia
  • Registered: 12/31/2017
  • Posts: 80

Re: How to clean the database from transactions?

I would copy the database then clear the tables you want cust_trans table bank_trans table etc
or create a new one then import the tables (probably more work)
PHPmysql is good and easy way to edit mysql tables