<html><head></head><body><div>On Thu, 2018-07-19 at 08:08 -0400, Dhaniels Nieto wrote:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><pre>There's no query to totally clean the database, i have a lot of customer </pre><pre>that can't be deleted, just cancelled,</pre><pre>and same with packages, i want to start from zero.</pre></blockquote><div>Hello Dhaniels,</div><div><br></div><div>Most things in Freeside cannot be deleted as it will break historical reporting and is in general bad accounting practice. Imagine trying to run a historical report on customers that had a specific package but the package was deleted, there would not be anything to run the report on.</div><div><br></div><div>If you want to start from scratch you will need to be sure to make a backup in case this turns out to not be what you want to do, stop all of the Freeside services as well as Apache, drop the freeside database, follow the Freeside installation guide from the step where the database gets created and continue to the end of the install guide to get the initial structure and data in place.</div><div><br></div><div>Cheers,</div><div><br></div><div><span><pre>-- <br></pre><div>Nathan Kennedy</div><div>Contracted Professional IT</div><div>(360) 637-1090</div><div>https://www.nkent.us/</div></span></div></body></html>