<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Show voided transactions in audit trail]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=6994</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=6994&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Show voided transactions in audit trail.]]></description>
		<lastBuildDate>Wed, 11 Oct 2017 15:03:17 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Show voided transactions in audit trail]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=28988#p28988</link>
			<description><![CDATA[<p>i want to remove the transaction itself not only zero it out, because i do not want the voided transaction appear in customer report or any other report .</p>]]></description>
			<author><![CDATA[null@example.com (AsimACC)]]></author>
			<pubDate>Wed, 11 Oct 2017 15:03:17 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=28988#p28988</guid>
		</item>
		<item>
			<title><![CDATA[Re: Show voided transactions in audit trail]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=28760#p28760</link>
			<description><![CDATA[<p>Helpful. Thanks.</p>]]></description>
			<author><![CDATA[null@example.com (davidkumi)]]></author>
			<pubDate>Thu, 28 Sep 2017 11:13:51 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=28760#p28760</guid>
		</item>
		<item>
			<title><![CDATA[Re: Show voided transactions in audit trail]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=28754#p28754</link>
			<description><![CDATA[<p>This variable will be removed. It is not used any more. The Audit Trail shows the voided items as zero amounts.</p><p>Unfortunately <a href="https://sourceforge.net/p/frontaccounting/git/commit_browser">Sourceforge Git</a> is down at present (Works now). <s>But this will be committed asap.</s><br /><a href="https://github.com/FrontAccountingERP/FA/commit/f425362379fe66e2b0f17b6e4f09d8d9bdf6c5f2">Committed</a>.</p><p>/Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Wed, 27 Sep 2017 22:40:03 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=28754#p28754</guid>
		</item>
		<item>
			<title><![CDATA[Re: Show voided transactions in audit trail]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=28753#p28753</link>
			<description><![CDATA[<p>I will have a look at this.</p><p>Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Wed, 27 Sep 2017 17:15:44 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=28753#p28753</guid>
		</item>
		<item>
			<title><![CDATA[Re: Show voided transactions in audit trail]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=28746#p28746</link>
			<description><![CDATA[<p><strong>$show_voided_gl_trans</strong> was used in FA 2.3.x in only one place in the <strong>gl/includes/db/gl_db_trans.inc</strong> file&#039;s function <strong>get_gl_transactions()</strong> in lines 121-122:<br /></p><div class="codebox"><pre><code>    if (isset($show_voided_gl_trans) &amp;&amp; $show_voided_gl_trans == 0)
        $sql .= &quot; AND &quot;.TB_PREF.&quot;gl_trans.amount &lt;&gt; 0&quot;; </code></pre></div><p>The equivalent function of the same name in the same file in FA 2.4.2 (has an extra <strong>person_id</strong> parameter that defaults to null) does not use the said variable which is not used anywhere in the entire FA 2.4.x codebase and is also not used in any of the extensions in the official repo.</p><p>None of the extensions in FA 2.3.x use the said variable too.</p><p>Either we incorporate the said variable, <strong>$show_voided_gl_trans</strong> in it&#039;s FA 2.4.x avatar ($SysPrefs-&gt;...) or ditch it in it&#039;s entirety now.</p><p>@joe: which way?</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Wed, 27 Sep 2017 16:23:32 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=28746#p28746</guid>
		</item>
		<item>
			<title><![CDATA[Re: Show voided transactions in audit trail]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=28745#p28745</link>
			<description><![CDATA[<p>I edited reporting/rep710.php</p><p>I added a.description to the $sql variable like so...</p><div class="codebox"><pre><code>$sql = &quot;SELECT a.*, 
        SUM(IF(ISNULL(g.amount), NULL, IF(g.amount &gt; 0, g.amount, 0))) AS amount,
        u.user_id, a.description, 
        UNIX_TIMESTAMP(a.stamp) as unix_stamp ...</code></pre></div><p>Changed the columns widths as follows</p><div class="codebox"><pre><code>    //$cols = array(0, 60, 120, 180, 240, 340, 400, 460, 520);
    $cols = array(-10, 40, 80, 120, 170, 250, 280, 500, 560);</code></pre></div><p>altered the &quot;action&quot; column as follows:</p><div class="codebox"><pre><code>        if (!$myrow[&#039;description&#039;]){
        if ($myrow[&#039;gl_seq&#039;] == null)
            $action = _(&#039;Updated&#039;);
        else
            $action = _(&#039;Created&#039;);     
        } else {
            $action = $myrow[&#039;description&#039;];   
        }
        $rep-&gt;TextCol(6, 7, $action);</code></pre></div><p>Also in admin/db/voiding_db.inc, I changed </p><div class="codebox"><pre><code>    //add_audit_trail($type, $type_no, $date_, _(&quot;Voided.&quot;).&quot;\n&quot;.$memo_);
    add_audit_trail($type, $type_no, $date_, _(&quot;Voided.&quot;).&quot; &quot;.$memo_);</code></pre></div><p>This gave me my desired result - Voided transactions are now lablled &quot;Voided&quot; and any memo also displays.</p>]]></description>
			<author><![CDATA[null@example.com (davidkumi)]]></author>
			<pubDate>Wed, 27 Sep 2017 16:20:01 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=28745#p28745</guid>
		</item>
		<item>
			<title><![CDATA[Re: Show voided transactions in audit trail]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=28742#p28742</link>
			<description><![CDATA[<p>And what does this line in config.php do?</p><div class="codebox"><pre><code>    $show_voided_gl_trans = 1;</code></pre></div><p>I changed to 0 and 1 but don&#039;t seem to see any difference anywhere.</p>]]></description>
			<author><![CDATA[null@example.com (davidkumi)]]></author>
			<pubDate>Wed, 27 Sep 2017 12:16:16 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=28742#p28742</guid>
		</item>
		<item>
			<title><![CDATA[Show voided transactions in audit trail]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=28741#p28741</link>
			<description><![CDATA[<p>Hi all,</p><p>how can I show voided transactions in audit trail? Instead of &quot;CHANGED&quot; and&nbsp; &quot;CLOSED&quot; in the action section of the audit trail report, how can we have it read &quot;VOIDED&quot; for voided transactions?</p><p>Advance thanks.</p>]]></description>
			<author><![CDATA[null@example.com (davidkumi)]]></author>
			<pubDate>Wed, 27 Sep 2017 11:34:53 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=28741#p28741</guid>
		</item>
	</channel>
</rss>
