<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Removing all transactions]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=1324&amp;type=atom" />
	<updated>2013-10-25T16:47:01Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=1324</id>
		<entry>
			<title type="html"><![CDATA[Re: Removing all transactions]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=18216#p18216" />
			<content type="html"><![CDATA[<p>Maybe you can&nbsp; Void a Transaction in Setup / Maintenance. You select the transaction type, query and delete.</p>]]></content>
			<author>
				<name><![CDATA[bmontenegro]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=18477</uri>
			</author>
			<updated>2013-10-25T16:47:01Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=18216#p18216</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Removing all transactions]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=5922#p5922" />
			<content type="html"><![CDATA[<p>Helle.</p><p>In fact I backup the database containing all the transactions.</p><p>I then edited the resulting sql file and removed the non desired Insert statements.<br />I then restore the database.</p><p>It seems to work well.</p><p>Thanks,</p><p>Gaston</p>]]></content>
			<author>
				<name><![CDATA[huotg01]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=983</uri>
			</author>
			<updated>2010-05-18T21:50:13Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=5922#p5922</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Removing all transactions]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=5914#p5914" />
			<content type="html"><![CDATA[<p>Presumably it would be possible to write a module/function to backup financial transactions to file and delete them from the database - perhaps deleting only those within a range of dates?&nbsp; Could be useful to expunge records older than a few years and would have the side-effect of allowing users to configure FrontAccounts to their detailed requirements before entering any live data.</p><p>I suppose it would entail:<br />Start a transaction<br />If a complete reset is required<br />&nbsp; log and set opening document numbers</p><p>For records between start date and end date<br />&nbsp; backup and delete debtor transactions, details and tax<br />&nbsp; backup and delete supplier transactions, invoice items and invoice tax<br />&nbsp; backup and delete POs, details and purchase data<br />&nbsp; backup and delete WOs and associated data<br />&nbsp; backup and delete Goods Received<br />&nbsp; backup and delete stock levels<br />&nbsp; backup and delete stock movements<br />&nbsp; backup and delete supplier allocations<br />&nbsp; backup and delete bank, GL and budget transactions</p><p>commit the transaction</p><p>Non-trivial - particularly the design and testing phases to make sure that no aspect of the system was compromised.</p>]]></content>
			<author>
				<name><![CDATA[Worrab]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=875</uri>
			</author>
			<updated>2010-05-18T10:21:02Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=5914#p5914</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Removing all transactions]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=5909#p5909" />
			<content type="html"><![CDATA[<p>You can eventually upload any chart of accounts you want to use into company/0/backup folder, and restore database form it.The effect is exactly as using the selected COA during installation. But any other configurations like users creation you have to do anyway.</p><p>Janusz</p>]]></content>
			<author>
				<name><![CDATA[itronics]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=89</uri>
			</author>
			<updated>2010-05-18T07:59:25Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=5909#p5909</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Removing all transactions]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=5897#p5897" />
			<content type="html"><![CDATA[<p>I just checked and...</p><p>Do I really have to start over ? creating users and others structure or is there somthing I can do to make it simple ?</p><p>Thanks</p>]]></content>
			<author>
				<name><![CDATA[huotg01]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=983</uri>
			</author>
			<updated>2010-05-16T21:02:46Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=5897#p5897</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Removing all transactions]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=5894#p5894" />
			<content type="html"><![CDATA[<p>I was expecting to be able to delete all, but it is ok.</p><p>Therefore I will start a new company&nbsp; and use a pre-defined chart (I notice a french canadian one) ?</p><p>By the way, I&#039;m testing FrontAccounting for the accounting of our association, and I have to tell you that it is a great product, really.</p><p>Thanks,</p><p>Gaston</p>]]></content>
			<author>
				<name><![CDATA[huotg01]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=983</uri>
			</author>
			<updated>2010-05-16T20:44:02Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=5894#p5894</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Removing all transactions]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=5891#p5891" />
			<content type="html"><![CDATA[<p>To have serious data, you should start with an empty Chart of Accounts, as en_US-new.sql or one of the charts in the download section.</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2010-05-16T20:36:36Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=5891#p5891</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Removing all transactions]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=5889#p5889" />
			<content type="html"><![CDATA[<p>I just installed FrontAccounting with some demo data.</p><p>I then made many changes in the parameters, groups, names, etc.</p><p>Now I would like to keep the structural changes, and remove all transactions in order to do real work.</p><p>Is it possible, or do I have to start &quot;fresh&quot; ?</p><p>Thanks</p>]]></content>
			<author>
				<name><![CDATA[huotg01]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=983</uri>
			</author>
			<updated>2010-05-16T20:31:38Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=5889#p5889</id>
		</entry>
</feed>
