juiced

Reason it stopped working is... the "total" value is no longer a numeric value it's a result of the prefix, value and suffix which is why it wouldnt calculate so we have to retrieve that value from the database. However it's not retrieving the suffix for the currency so maybe dont use it? for now anyway.

But also in version 4 the template file has been changed to invoicepdf.tpl Simply "copy / paste" the content from pdfconfig in between the {php} {/php} tags + do the above change and it should be fine.

the above is for html version For PDF version.... Look for $result = select_query("tblinvoices","SUM(total)","userid='".$clientsdetails["userid"]."' AND status='Unpaid' AND id<'".$invoiceid."'"); $data = mysql_fetch_array($result); $balancebroughtforward = format_as_currency($data[0]); $grandtotal = format_as_currency($data[0])+$total; Replace with $result = select_query("tblinvoices","SUM(total)","userid='".$clientsdetails["userid"]."' AND status='Unpaid' AND id<'".$invoiceid."'"); $result2 = select_query("tblinvoices","SUM(total)","userid='".$clientsdetails['userid']."' AND status='Unpaid' AND id='".$invoiceid."'"); $data = mysql_fetch_array($result); $data2 = mysql_fetch_array($result2); $balancebroughtforward = format_as_currency($data[0]); $grandtotal = format_as_currency($data[0]+$data2[0]);

To fix the total issue in V4... in html look for {php} $invoiceid = $this->_tpl_vars['invoiceid']; $clientsdetails = $this->_tpl_vars['clientsdetails']; $total = $this->_tpl_vars['total']; /*echo '<pre>' . print_r($clientsdetails) . '</pre>'; echo 'userid=' . $clientsdetails["userid"] . ' AND status="Unpaid" AND id<' . $invoiceid;*/ $result = select_query("tblinvoices","SUM(total)","userid='".$clientsdetails['userid']."' AND status='Unpaid' AND id<'".$invoiceid."'"); $data = mysql_fetch_array($result); $balancebroughtforward = format_as_currency($data[0]); $grandtotal = format_as_currency($data[0])+$total; $this->assign('balancebroughtforward',$balancebroughtforward); $this->assign('grandtotal',$grandtotal); {/php} Replace with {php} $invoiceid = $this->_tpl_vars['invoiceid']; $clientsdetails = $this->_tpl_vars['clientsdetails']; $total = $this->_tpl_vars['total']; /*echo '<pre>' . print_r($clientsdetails) . '</pre>'; echo 'userid=' . $clientsdetails["userid"] . ' AND status="Unpaid" AND id<' . $invoiceid;*/ $result = select_query("tblinvoices","SUM(total)","userid='".$clientsdetails['userid']."' AND status='Unpaid' AND id<'".$invoiceid."'"); $result2 = select_query("tblinvoices","SUM(total)","userid='".$clientsdetails['userid']."' AND status='Unpaid' AND id='".$invoiceid."'"); $data = mysql_fetch_array($result); $data2 = mysql_fetch_array($result2); $balancebroughtforward = format_as_currency($data[0]); $grandtotal = format_as_currency($data[0]+$data2[0]); $this->assign('balancebroughtforward',$balancebroughtforward); $this->assign('grandtotal',$grandtotal); {/php}

Hi Guys, Sorry i've not been recieving emails of these posts and hadnt check in a while hence the non reply. I noticed V4 is different and therefore our template needs ammendments, I'll get onto this shortly and will post updates here. Cheers

Statement module being built now, probably 5 days away.

Currenlty.... no.

Hi SoftDux Our invoice template doubles as a statement. It shows the "balance brought forward" of older unpaid invoices and will add to the total amount due in the invoice. So whenever a new invoice is created it also acts as a statement. I do plan on making a module to run statements shortly. I hope this was helpful.

New Quote PDF Template for the new quote system in V3.8.1

PM me for details Creative

Hi AndrewMKP The description field now drops down line so doesnt run over anymore. And for an if statement for the discount you would do something like if ($item["discount"]>0) { $pdf->MultiCell(15,$cellheight,$item["discount"],1,'C','',0); } else { } Something like that, ive not tested it i've just written it. And you'd do something similair for the coloumn header as well Thanks

Basically we've developed a custom set of templates and we're showcasing them here in the showcase section.

New Quote template to match the invoice template we made. Same deal, fully customisable.

Am looking at doing that now. Is there any more interest? the more the better that way it's cheaper!!

New invoice / statement template for WHMCS It doubles as a statement and brings unpaid balances forward (makes life easier)

New invoice template for WHMCS that doubles as a statement. Great for customers and for your accounts controller. http://www.justjuiced.co.nz/invoice/

Hi, i'm looking around for a better stats system for our server. We currently have webalizer, which is too bland for our customers. We've used Awstats before, which is good, but not very professional looking and customers get confused. Anyone know of any other good ones? dont care if it's free or paid, just looking for one thats clean, fast, easy & accurate

nice colours, although looks like a header footer integration.

mint design mate. well done.

Hi guys, i must be having a blonde day. because i've got the Beta, installed & setup correctly, now however, how do we configure the software client side to check the license in whmcs? is there another module somewhere we should be building into the software?

Thanks Joe123

have you checked that your package names are all setup properly, ip addresses correct, admin users / passes set right?

This is what you want to remove if ($status=="Cancelled") { $pdf->SetXY(90,80); $statustext = $_LANG["invoicescancelled"]; $pdf->SetTextColor(245,245,245); } elseif ($status=="Unpaid") { $pdf->SetXY(120,80); $statustext = $_LANG["invoicesunpaid"]; $pdf->SetTextColor(204,0,0); } elseif ($status=="Paid") { $pdf->SetXY(120,80); $statustext = $_LANG["invoicespaid"]; $pdf->SetTextColor(153,204,0); }

currently cant be done, i think you'd need to submit a tick to Matt to develop the currency setup further.

yes, where it says Don't have a PayPal account? Use your credit card or bank account (where available). Continue if they click continue they'll be able to enter credit card details and process their transaction