<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Void bank deposite transaction]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=6569</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=6569&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Void bank deposite transaction.]]></description>
		<lastBuildDate>Mon, 05 Dec 2016 16:35:03 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Void bank deposite transaction]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=26962#p26962</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Mon, 05 Dec 2016 16:35:03 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=26962#p26962</guid>
		</item>
		<item>
			<title><![CDATA[Void bank deposite transaction]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=26961#p26961</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (galjabiri)]]></author>
			<pubDate>Mon, 05 Dec 2016 15:55:07 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=26961#p26961</guid>
		</item>
	</channel>
</rss>
