Reporting on Marketing Qualified Lead, what tables are used

[former_member666435]

Hi all,

I need to build an sql query to report on Marketing Qualified Leads, does anyone know where can i find this information in SAP Business One?

Warm Regards,

Daniel

[kothandaraman_nagarajan]

Try this simple query,

SELECT T0.[CardCode], T0.[CardName], count(T0.[DocNum]) as Count FROM OQUT T0 INNER JOIN OCRD T1 ON T0.[CardCode] = T1.[CardCode] WHERE T1.[CardType] = 'L' GROUP BY T0.[CardCode], T0.[CardName]

[kothandaraman_nagarajan]

Hi,

In general, we can use lead up to Sales order. Before converting to SO to DO, the lead should be converted to customer. Not sure about your definition of qualified lead.

So the tables involved for query is OCRD, OQUT,ORDR

Regards,

Nagarajan

[former_member666435]

Hi Nagarajan, in relation to lead what do you mean by it, is it the opportunity stages you are mentioning?

Warm Regards,

Daniel

[former_member666435]

also forgot to add the requirment is a count of Marketing Qualified Leads, this count will it be by a type of document like a sales quotation? Does it make sense?

Warm Regards,

Daniel