[Vtigercrm-developers] [VM develloper] description in invoice

[mat]

Hello  micker,

Is something like this would be what you are looking for ?

SELECT DISTINCT(t.description) as "Description",a.*
FROM vtiger_invoice as a 
		inner join vtiger_crmentity as t on  t.crmid=a.invoiceid
		left outer join vtiger_salesorder as so on
so.salesorderid=a.salesorderid 
		left outer join vtiger_account as d on d.accountid=a.accountid
		left join vtiger_groups as g on g.groupid=t.smownerid
		left join vtiger_users as u on u.id=t.smownerid
		left join vtiger_invoicebillads as b on
a.invoiceid=b.invoicebilladdressid
		left join vtiger_invoiceshipads as c on
a.invoiceid=c.invoiceshipaddressid
		left join vtiger_inventoryproductrel as ip on a.invoiceid = ip.id
		left join vtiger_products as p on p.productid = ip.productid
		left join vtiger_contactdetails as f on a.contactid=f.contactid
WHERE t.deleted=0 
ORDER BY CAST(a.invoice_no AS UNSIGNED) ASC

mathdesc

Le lundi 23 juin 2014 à 00:20 -0700, micker a écrit :

> hello any idea ?
> 
> 
> 
> --
> View this message in context: http://vtiger-crm.2324883.n4.nabble.com/VM-develloper-description-in-invoice-tp10998p11096.html
> Sent from the vtigercrm-developers mailing list archive at Nabble.com.
> _______________________________________________
> http://www.vtiger.com/


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140624/8330cf9f/attachment-0001.html>