[freeside-users] "Pending payment" prevents further action on customer account.

[Ernie Dunbar]

That worked! Thanks!

On 2018-11-27 11:01 a.m., Sam Tetherow wrote:
>
> Didn't see anyone reply to this.  You should be able to use the 
> following SQL to update the cust_pay_pending table
>
> update cust_pay_pending set status='done', statustext='declined: 
> recovery from Freeside Failur' where status='declined';
>
>
> On 11/15/2018 04:25 PM, Ernie Dunbar wrote:
>>
>> Hi everyone.
>>
>> 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.
>>
>> When I try to process their payment, I get the following error message:
>>
>> A payment is already being processed for this customer (paypendingnum 
>> 35934); CC transaction aborted.
>>
>> How do I cancel the payment being processed so that I can start 
>> charging the customer again?
>>
>> -- 
>>
>>
>>
>> Ernie Dunbar
>> *
>> **System Administrator*
>> Information Technology Department
>>
>>
>>
>> Vancouver: (604) 482-1190
>> Calgary: (403) 537-6254
>> Winnipeg: (204) 815-5662
>> Toll Free: (866) 798-0906
>> Fax : (604) 482-1191
>> /
>> //www.lightspeed.ca/
>>
>>
>>
>> */
>> CONFIDENTIALITY NOTICE:
>> /*/The contents of this email message and any attachments are 
>> intended solely for the addressee(s) and
>> may contain confidential and/or privileged information and may be 
>> legally protected from disclosure. If
>> you are not the intended recipient of this message or their agent, or 
>> if this message has been
>> addressed to you in error, please immediately alert the Internet 
>> Lightspeed by reply email and then
>> delete this message and any attachments. If you are not the intended 
>> recipient, you are hereby
>> notified that any use, dissemination, copying, or storage of this 
>> message or its attachments is strictly
>> prohibited by law./
>>
>>
>>
>> _______________________________________________
>> freeside-users mailing list
>> freeside-users at freeside.biz
>> http://mail.freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://mail.freeside.biz/cgi-bin/mailman/listinfo/freeside-users
-- 



Ernie Dunbar
*
**System Administrator*
Information Technology Department



Vancouver: (604) 482-1190
Calgary: (403) 537-6254
Winnipeg: (204) 815-5662
Toll Free: (866) 798-0906
Fax : (604) 482-1191
/
//www.lightspeed.ca/



*/
CONFIDENTIALITY NOTICE:
/*/The contents of this email message and any attachments are intended 
solely for the addressee(s) and
may contain confidential and/or privileged information and may be 
legally protected from disclosure. If
you are not the intended recipient of this message or their agent, or if 
this message has been
addressed to you in error, please immediately alert the Internet 
Lightspeed by reply email and then
delete this message and any attachments. If you are not the intended 
recipient, you are hereby
notified that any use, dissemination, copying, or storage of this 
message or its attachments is strictly
prohibited by law./

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.freeside.biz/pipermail/freeside-users/attachments/20181127/d55a8713/attachment.html>