<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/4.2.2">
</HEAD>
<BODY>
Hello micker,<BR>
<BR>
Is something like this would be what you are looking for ?<BR>
<BR>
SELECT DISTINCT(t.description) as "Description",a.*<BR>
FROM vtiger_invoice as a <BR>
inner join vtiger_crmentity as t on t.crmid=a.invoiceid<BR>
left outer join vtiger_salesorder as so on so.salesorderid=a.salesorderid <BR>
left outer join vtiger_account as d on d.accountid=a.accountid<BR>
left join vtiger_groups as g on g.groupid=t.smownerid<BR>
left join vtiger_users as u on u.id=t.smownerid<BR>
left join vtiger_invoicebillads as b on a.invoiceid=b.invoicebilladdressid<BR>
left join vtiger_invoiceshipads as c on a.invoiceid=c.invoiceshipaddressid<BR>
left join vtiger_inventoryproductrel as ip on a.invoiceid = ip.id<BR>
left join vtiger_products as p on p.productid = ip.productid<BR>
left join vtiger_contactdetails as f on a.contactid=f.contactid<BR>
WHERE t.deleted=0 <BR>
ORDER BY CAST(a.invoice_no AS UNSIGNED) ASC<BR>
<BR>
mathdesc<BR>
<BR>
Le lundi 23 juin 2014 à 00:20 -0700, micker a écrit :
<BLOCKQUOTE TYPE=CITE>
<PRE>
hello any idea ?
--
View this message in context: <A HREF="http://vtiger-crm.2324883.n4.nabble.com/VM-develloper-description-in-invoice-tp10998p11096.html">http://vtiger-crm.2324883.n4.nabble.com/VM-develloper-description-in-invoice-tp10998p11096.html</A>
Sent from the vtigercrm-developers mailing list archive at Nabble.com.
_______________________________________________
<A HREF="http://www.vtiger.com/">http://www.vtiger.com/</A>
</PRE>
</BLOCKQUOTE>
<BR>
</BODY>
</HTML>