I have a friend for whom I am working on Floreant. She has the same issue. I have done this by hand using SQL Workbench to connect to the Derby database and running delete commands.
The problem is running them in the right order (I.E. you need to delete all items from the ticket before you can delete the ticket). I plan on writing an SQL script that does everything in the proper order, but I have not gotten around to it yet (Relatively low priority vs getting everything working =) ). I will post back here once I write the script.
Just make sure you do a
and then delete all transactions,ticket,ticket_item, drawer_pull_report , etc.etc. tables.