<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — DATA INTEGRITY: gl_trans still contains non zero voided items]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=10718</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=10718&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in DATA INTEGRITY: gl_trans still contains non zero voided items.]]></description>
		<lastBuildDate>Mon, 30 Mar 2026 09:00:29 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: DATA INTEGRITY: gl_trans still contains non zero voided items]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43859#p43859</link>
			<description><![CDATA[<p>When you Edit Bank Payment or Bank Deposit, FA voids previous entry and creates new entry.<br />Void sets all values to ZERO and mark the entry as voided.</p><p>May be during this process anomaly occured and marking entry voided failed.</p><p>If this happens regularly then this needs to be debug in depth.</p>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Mon, 30 Mar 2026 09:00:29 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43859#p43859</guid>
		</item>
		<item>
			<title><![CDATA[DATA INTEGRITY: gl_trans still contains non zero voided items]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43849#p43849</link>
			<description><![CDATA[<p>I discovered today that my gl_trans table had both a Bank Payment and a Bank Deposit that had non zero values but the void_transaction screen showed as non-existent.&nbsp; &nbsp;Discovered while trying to reconcile bank accounts.</p><p>bank_account_reconcile did NOT list the items, so I searched the GL Enquiry for transactions in case they were registered against wrong GLs.</p><p>gl_account_inquiry listed these items with the non zero values (the values I was expecting - but with extra lines)</p><p>gl_trans_view.php opened the items, displayed looking like a Journal Entry rather than the normal Payment/Deposit pop ups.</p><p>gl_journal.php?ModifyGL=yes opened into the Bank Deposit or Bank Payment editored, but all lines were of zero value, and the date was today&#039;s date.&nbsp; Altering and saving resulted in the next screen saying transaction 0 was updated.</p><p>I am currently on 2.4.19 but was on 2.4.1 until a month or so ago, so this data corruption could be from a while ago.</p><p>PROPOSAL:<br />1) A report that cross references the various tables that store this data and reports mis-matches.<br />2) an editor to clean these up - either a &quot;force&quot; for void or similar zero everything.&nbsp; I haven&#039;t worked through this yet as EOY tax reporting is less than a week away.</p>]]></description>
			<author><![CDATA[null@example.com (fraserks)]]></author>
			<pubDate>Wed, 25 Mar 2026 21:04:01 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43849#p43849</guid>
		</item>
	</channel>
</rss>
