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

micker micker at free.fr
Mon Jun 30 07:25:19 GMT 2014

i try 

mat wrote
> SELECT DISTINCT(ip.comment) 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

but nothing

View this message in context: http://vtiger-crm.2324883.n4.nabble.com/VM-develloper-description-in-invoice-tp10998p11187.html
Sent from the vtigercrm-developers mailing list archive at Nabble.com.

More information about the vtigercrm-developers mailing list