http://in.compucrete.com/index.php?action=history&feed=atom&title=Fixing_a_Double_AR_void_InvoiceFixing a Double AR void Invoice - Revision history2026-05-15T15:14:23ZRevision history for this page on the wikiMediaWiki 1.40.0http://in.compucrete.com/index.php?title=Fixing_a_Double_AR_void_Invoice&diff=208&oldid=prevWikiAdmin: 1 revision imported2023-07-14T12:58:49Z<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<tr class="diff-title" lang="en">
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>WikiAdminhttp://in.compucrete.com/index.php?title=Fixing_a_Double_AR_void_Invoice&diff=207&oldid=prevChanson: /* Example of fixing a double void */2018-10-03T18:38:25Z<p><span dir="auto"><span class="autocomment">Example of fixing a double void</span></span></p>
<p><b>New page</b></p><div><br />
==Example of fixing a double void==<br />
<br />
<br />
This example we are unvoiding session 291763<br />
<br />
first document original invoices: (select <code>void_inv_session_no, from artinv where session_no = 291763</code>)<br />
Results:<br />
SESSION TRNS<br />
291743 957<br />
291743 1014<br />
<br />
We can use this trick to come up with a value equal to SESSION*10000+TRANS for later when we need to list these:<br />
29174300957,<br />
29174301014<br />
<br />
<br />
Now Delete:<br />
<pre><br />
delete from glttrx where session_no = 291763<br />
delete from arttaxtrx where session_no = 291763<br />
delete from artcshhd where session_no = 291763<br />
update artprtrx set reconciled_flag='Y' where session_no = 291763<br />
DELETE from artprtrx where session_no = 291763<br />
update artslsdt set reconciled_flag='Y' where session_no = 291763<br />
DELETE from artslshd where session_no = 291763<br />
DELETE from artinv where session_no = 291763<br />
</pre><br />
<br />
and update original invoice to unpaid and non-void:<br />
<pre><br />
select * from artinv where (session_no*100000+trans_no) in ( 29174300957, 29174301014)<br />
<br />
update artinv set void_flag='N', CREDIT_AMOUNT=0 , LAST_POST_DATE=NULL<br />
where (session_no*100000+trans_no) in ( 29174300957, 29174301014)<br />
</pre><br />
<br />
<br />
The customer can now void as desired.</div>Chanson