<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>That worked! Thanks!<br>
</p>
<div class="moz-cite-prefix">On 2018-11-27 11:01 a.m., Sam Tetherow
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:c69b1294-4b6e-fd26-08dc-67de75f0918a@shwisp.net">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<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 size="+1" color="#ff0000">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" moz-do-not-send="true">freeside-users@freeside.biz</a>
<a class="moz-txt-link-freetext" href="http://mail.freeside.biz/cgi-bin/mailman/listinfo/freeside-users" moz-do-not-send="true">http://mail.freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-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>
<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">
<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">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>
</body>
</html>