Martyn Posted December 5, 2007 Share Posted December 5, 2007 Even tho it stats "6 Unpaid" invocies, when clicked, invocies dont show up. anyhelp? regards 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted December 5, 2007 WHMCS CEO Share Posted December 5, 2007 This means that you don't have the gateway modules activated that these invoices are set to. Matt 0 Quote Link to comment Share on other sites More sharing options...
Martyn Posted December 6, 2007 Author Share Posted December 6, 2007 well i activated all payment modules, and it still didnt work, even tho i used paypal as main service before. also it wont let me insall 2CheckOut, weird stuff. 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted December 9, 2007 Share Posted December 9, 2007 mysql> select id,invoicenum,date,userid,paymentmethod from tblinvoices; will tell you what gateways are on the invoices or mysql> select id,invoicenum,date,userid,paymentmethod,status from tblinvoices where status="Unpaid"; will give you just the outstanding ones cross reference that to mysql> select id,gateway,type,setting from tblpaymentgateways where setting="active"; 0 Quote Link to comment Share on other sites More sharing options...
docblue Posted January 19, 2008 Share Posted January 19, 2008 I just had the same problem. After running the SQL statements above I saw the invoice number is blank. The ID should be the invoice number in `tblinvoices`. Is that the problem? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Developer WHMCS Andrew Posted January 19, 2008 WHMCS Developer Share Posted January 19, 2008 No, I dont think so. Is the payment gateway blank in the invoices? This was what happened with me 0 Quote Link to comment Share on other sites More sharing options...
docblue Posted January 19, 2008 Share Posted January 19, 2008 The gateway field in the tblpaymentgateways table says 'paypal' and the paymentmethod field in the tblinvoices table has 'paypalinvoices'. Should I change the payment method on the invoice to 'paypal'? 0 Quote Link to comment Share on other sites More sharing options...
urevised Posted January 19, 2008 Share Posted January 19, 2008 I had the same problem when importing from MB to WHMCS when i first moved here. I just had to get around it by adding manual ledger entries for all my income / expenses. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted January 19, 2008 WHMCS CEO Share Posted January 19, 2008 docblue said: Should I change the payment method on the invoice to 'paypal'? Yes, it must be set to PayPal. Run the following query: UPDATE tblinvoices SET paymentmethod='paypal' WHERE paymentmethod='paypalinvoices'; Matt 0 Quote Link to comment Share on other sites More sharing options...
docblue Posted January 19, 2008 Share Posted January 19, 2008 Thanks Matt, it worked. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.