cancel
Showing results for 
Search instead for 
Did you mean: 

Reporting on Marketing Qualified Lead, what tables are used

former_member666435
Participant
0 Kudos
138

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

Accepted Solutions (0)

Answers (2)

Answers (2)

kothandaraman_nagarajan
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Participant
0 Kudos

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
Participant
0 Kudos

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