<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Hi Ruben , I think you could make a sql query joining Leads and accounts with same email and Converted flag set to 1.<div>@alan if you have a suggestion you could propose a merge request what do you think?<br><br><div dir="ltr"><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="background-color: rgba(255, 255, 255, 0); word-wrap: break-word; "><div class="ApplePlainTextBody" style="font-family: Helvetica; font-size: 14px; -webkit-text-size-adjust: auto;">_______________<br><br>Angelo Paglialonga<br>Consulente per soluzioni CRM ad alto ROI.<br><br>Telefono: 3386077866<br>Skype: angelo.paglialonga<br>Web: https://www.angelopaglialonga.com</div><div class="ApplePlainTextBody" style="font-family: Helvetica; font-size: 14px; -webkit-text-size-adjust: auto;"><br></div></div></span></div></span></div></span></div></span></div></span></span></span></span></span></span></span></span></span></span></span></div></span></div></span></div></span></div><div dir="ltr"><br><blockquote type="cite">Il giorno 4 gen 2022, alle ore 08:29, Alan Lord <alanslists@gmail.com> ha scritto:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><span>Not as standard I believe.</span><br><span></span><br><span>In the past I have modified a customers' system to add a lead_id column to the vtiger_account table and used an event handler (or I hacked the lead conversion process itself) to pass this information on.</span><br><span></span><br><span>This would be a useful addition to any vtiger I think.</span><br><span></span><br><span>HTH</span><br><span></span><br><span>Al</span><br><span></span><br><span></span><br><span>On 04/01/2022 03:00, Rubén A. Estrada Orozco wrote:</span><br><blockquote type="cite"><span>Hi everyone,</span><br></blockquote><blockquote type="cite"><span>When you convert a lead into an account, the lead "disappears" from the leads module. In the database, however, the lead is still there with the flag "converted" equals to 1.</span><br></blockquote><blockquote type="cite"><span>I have a large database and would like to determine the leads that originated certain accounts. Is that possible? I thought maybe there was an leadid field somewhere in the account, but couldn't find it.</span><br></blockquote><blockquote type="cite"><span>Any ideas?</span><br></blockquote><blockquote type="cite"><span>BTW Happy New Year!</span><br></blockquote><blockquote type="cite"><span>Saludos</span><br></blockquote><blockquote type="cite"><span>Rubén</span><br></blockquote><blockquote type="cite"><span>_______________________________________________</span><br></blockquote><blockquote type="cite"><span>http://www.vtiger.com/</span><br></blockquote><span>_______________________________________________</span><br><span>http://www.vtiger.com/</span></div></blockquote></div></body></html>