How to show Invoice Notes on Invoice Email Reminder Template

[davoram]

Hi,

 

Is there a way to show Invoice Notes ( as in the pdf invoice ) on the invoice email templates?

 

Thanks

[sparky]

Yes it can be done.

go to email templates in admin and click the image to edit the template

click the disable rich text editor button and insert this code where you need it and save.

 

<p><br /><strong>Invoice Notes</strong></p>
<p>{php}$inv_id = $this->_tpl_vars['invoice_id'];$result = select_query("tblinvoices","",array("tblinvoices.id"=>$inv_id));$data = mysql_fetch_array($result);$this->assign('invoice_notes',$data['notes']);{/php}{$invoice_notes}</p>
<p>------------------------------------------------------</p> 

If you try and edit it again you will need to change the

> 

back to

>

because tinymce will convert it when it opens the file.

[davoram]

Thanks!

 

It work perfectly!

 

It is strange to have to code this it should be a standard feature.

 

 

Thanks again.

[BuffaloWeb]

what would I need to use if I wanted to pull in the "notes" field from the table "tblhosting" for the associated package that is being invoiced?