<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Didn't see anyone reply to this. You should be able to use the
following SQL to update the cust_pay_pending table</p>
<p>update cust_pay_pending set status='done', statustext='declined:
recovery from Freeside Failur' where status='declined';<br>
</p>
<br>
<div class="moz-cite-prefix">On 11/15/2018 04:25 PM, Ernie Dunbar
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:d34e13ee-9847-3580-96d4-91e7192dd31a@lightspeed.ca">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<p>Hi everyone.</p>
<p>This month, we had a couple of customers who we can't enter
payments for, because in their Payment History, there is a
payment pending that has not been resolved.</p>
<p>When I try to process their payment, I get the following error
message:</p>
<p><font color="#ff0000" size="+1">A payment is already being
processed for this customer (paypendingnum 35934); CC
transaction aborted.</font> <br>
</p>
<p>How do I cancel the payment being processed so that I can start
charging the customer again?<br>
</p>
<div class="moz-signature">-- <br>
<p><img style="-webkit-user-select: none;"
src="https://www.lightspeed.ca/wp-content/uploads/2018/10/ILS-Logo-300-Light.png"
moz-do-not-send="true"> <br>
</p>
<font face="Arial"><br>
<font size="+1">Ernie Dunbar</font><br>
<b><br>
</b></font><font size="+1"><b><font face="Arial">System
Administrator</font></b></font><font face="Arial"><font
size="+1"><br>
</font></font><font face="Arial">Information Technology
Department</font><font face="Arial"><br>
<br>
<font size="-1"><br>
<br>
</font></font><font face="Arial">Vancouver: (604) 482-1190<br>
Calgary: (403) 537-6254<br>
Winnipeg: (204) 815-5662<br>
Toll Free: (866) 798-0906<br>
Fax : (604) 482-1191</font><font face="Arial"><br>
</font><i><font size="+2"><br>
</font></i><font face="Arial"><font face="Arial"><i><font
size="+2"><a class="moz-txt-link-abbreviated"
href="http://www.lightspeed.ca" moz-do-not-send="true">www.lightspeed.ca</a></font></i><br>
</font></font><font face="Arial"><br>
<br>
<br>
<b><font size="-2"><i><br>
CONFIDENTIALITY NOTICE:<br>
</i></font></b><font size="-2"><i>The contents of this
email message and any attachments are intended solely for
the addressee(s) and <br>
may contain confidential and/or privileged information and
may be legally protected from disclosure. If <br>
you are not the intended recipient of this message or
their agent, or if this message has been <br>
addressed to you in error, please immediately alert the
Internet Lightspeed by reply email and then <br>
delete this message and any attachments. If you are not
the intended recipient, you are hereby <br>
notified that any use, dissemination, copying, or storage
of this message or its attachments is strictly <br>
prohibited by law.</i></font><br>
<br>
</font></div>
<!--'"--><br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
freeside-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</a>
<a class="moz-txt-link-freetext" href="http://mail.freeside.biz/cgi-bin/mailman/listinfo/freeside-users">http://mail.freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a>
</pre>
</blockquote>
<br>
</body>
</html>