Mark Invoice Paid ( SQL )

[stormrider]

Hello,

 

How can i mark an invoice paid using SQL?

 

Should i only change the status to Paid or do i have to do anything else?

 

Thanks,

 

Fernando.

[Matt]

If you do that, none of the operations that occur when marking an invoice paid will occur. You should use the API if you want that to happen.

 

Matt

[stormrider]

Hello Matt,

 

Thanks for your answer. I have found this on the manual:

 

Mark Invoice Paid

$query_string .= "action=addinvoicepayment&invoiceid=1&transid=453685410&amount=40&gateway=paypalinvoices";

 

Server Create

$query_string .= "action=servercreate&accountid=1";

 

But, will this send the payment confirmation and welcome e-mail to the user?

 

Thanks.

[BionHostStan]

just wonderin.. what r u using this for?

[stormrider]

Hello,

 

I have two payment gateways. Both of them gives me a URL to view which payment where made. I'm trying to automatically confirm payments and, if the account wasn't created, create it.

[Matt]

Just use the API to mark the invoice paid. WHMCS will handle the rest.

 

Matt

[stormrider]

Hello Matt,

 

What's the right format to the amount? I tried 29.40 but it only applied 29 to the user's invoice.

[stormrider]

Matt,

 

Is there a way to use decimal numbers?

[Matt]

It should be possible to include decimal numbers. You might need to urlencode it I guess.

 

Matt