<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Void bank deposite transaction]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=6569&amp;type=atom" />
	<updated>2016-12-05T16:35:03Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=6569</id>
		<entry>
			<title type="html"><![CDATA[Re: Void bank deposite transaction]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=26962#p26962" />
			<content type="html"><![CDATA[<p>Please make sure that you are using the <a href="https://github.com/FrontAccountingERP/FA/archive/master.zip">latest stable FA version</a> as your issues may have been resolved since the official release.</p><p>Line 218 of <strong>admin/void_transaction.php</strong> throws up this error when the <strong>exist_transaction()</strong> function (also in the same file) tested in the immediate <strong>if </strong>above it returns <strong>false</strong>. </p><p>This happens when the function <strong>get_voided_entry()</strong> (defined in <strong>admin/db/voiding_db.inc</strong>) returns a valid result (1 or more rows). </p><p>This latter function extracts:<br /></p><div class="codebox"><pre><code>SELECT * FROM voided WHERE type=$type AND id=$type_no;</code></pre></div><p>This ensures that the said entry was not voided earlier.</p><p>Therefore make sure that you have not attempted to void the same entry more than once.</p><p>Additionally, for the said error to crop up, as you are voiding a Bank Deposit entry, the function <strong>exists_bank_trans()</strong> (defined in <strong>gl/includes/db/gl_db_bank_trans.inc</strong>) must return <strong>false</strong>, that is that if there was no such entry available.</p><p>The sql executed here is:<br /></p><div class="codebox"><pre><code>SELECT trans_no FROM bank_trans WHERE type=$type AND trans_no=$type_no;</code></pre></div><p>There will be such errors if there is a primary key violation in uniquely identifying such transactions....<br />Also note that the table <strong>bank_trans</strong> has NULL-able fields <strong>type</strong> and <strong>trans_no</strong> and if they have null values in some of their records, it may cause issues.<br />@joe: please check - should those fields be NOT NULL for best practices or are NULL values possible in FA for these fields?</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2016-12-05T16:35:03Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=26962#p26962</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Void bank deposite transaction]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=26961#p26961" />
			<content type="html"><![CDATA[<p>Hello<br />I try to void bank deposite transaction <br />I got this message </p><p>The entered transaction does not exist or cannot be voided.</p><br /><p>And the transaction could not void</p><p>Any assistance is appreciated</p>]]></content>
			<author>
				<name><![CDATA[galjabiri]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=40503</uri>
			</author>
			<updated>2016-12-05T15:55:07Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=26961#p26961</id>
		</entry>
</feed>
