Thank You Rodrigo...Also i have another doubt. I want to Sync local sales order database with Vtiger server Database. For that i know, i want to use web services. So, Shall i want to create Local DB tables as same as Server DB( with same no.of fields,same filed name).Otherwise can i create only mandatory fields in local database and sync with Server DB?<br>
<br><div class="gmail_quote">On Mon, Jul 30, 2012 at 5:50 PM, Rodrigo Souza <span dir="ltr"><<a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<font><font face="verdana,sans-serif">Hi,</font></font><div><font><font face="verdana,sans-serif"><br></font></font></div><div><font><font face="verdana,sans-serif">The table that stores this information is vtiger_inventoryproductrel, where the ID field relates to the SalesOrderID </font></font><span style="font-family:verdana,sans-serif">field.</span></div>
<div><font><font face="verdana,sans-serif"><br></font></font></div><div><font><font face="verdana,sans-serif"><br clear="all"></font></font>Atte,<br><b>Rodrigo Souza de Oliveira</b><div><b>Consultor de TI<br></b>Hostplan Informática Ltda<br>
<div>Telefones: <a href="tel:%2821%29%209217-7909" value="+12192177909" target="_blank">(21) 9217-7909</a> e/ou (21) 8153-5287<div>website: <a href="http://www.hostplan.com.br" target="_blank">www.hostplan.com.br</a><br>
e-mail/msn: <a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a><br>
<img src="http://www.hostplan.com.br/logo.jpg" height="137" width="200"><br></div></div></div><br>
<br><br><div class="gmail_quote">2012/7/30 ram prasad <span dir="ltr"><<a href="mailto:ramtrg@gmail.com" target="_blank">ramtrg@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div class="h5">
Hi <div><br></div><div> I am creating Sales Order capturing java script application. I am not able to find In which table,the Selected Products(selected when sales order form filling) are stored in vtiger Database. Also in Sales order module web service "products" parameter is not available. Help me to store products while sales order capturing.</div>
<span><font color="#888888">
<div><br clear="all"><div><br></div>-- <br><font face="comic sans ms,sans-serif"><span style="color:rgb(153,0,0)">BY</span><br><br><span style="color:rgb(0,102,0)">R.RAMPRASAD</span></font><br>
<br>
</div>
</font></span><br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><font face="comic sans ms,sans-serif"><span style="color:rgb(153,0,0)">BY</span><br>
<br><span style="color:rgb(0,102,0);background-color:rgb(255,255,255)">R.RAMPRASAD</span></font><br><br>