<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Ciao Angelo,<div class="">This is interesting. I know for sure that the payment version of Vtiger let’s you do that. Now the question is how do we replicate this, your solution seems reasonable and could be fast to implement. We could cooperate sure, also we are both from Italy and speak Italian, communications could be easier.<div class=""><br class=""><div class="">
<div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div>Best Regards,<br class=""><b class="">Sukhdev Mohan</b> | <b class="">Software Developer</b></div></div><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">Il giorno 4 mag 2021, alle ore 09:28, info sito <<a href="mailto:info@angelopaglialonga.com" class="">info@angelopaglialonga.com</a>> ha scritto:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi <span class="">Sukhdev</span>!<br class=""><div class="">I would create line item fields possibly via vtlib , use js to load on document ready your new columns (reading them via ajax from table) and use an aftersave event to save new columns values via mysql query.</div><div class=""><br class=""></div><div class="">It you’re interested we could develop it together , what do you think?<br class=""><div class="">
<div class="">_______________<br class=""><br class="">Angelo Paglialonga<br class="">Consulente per soluzioni CRM ad alto ROI.<br class=""><br class="">Telefono: 3386077866<br class="">Skype: angelo.paglialonga<br class="">Web: <a href="https://www.angelopaglialonga.com/" class="">https://www.angelopaglialonga.com</a></div><div class=""><br class=""></div><br class="Apple-interchange-newline">
</div>
<div class=""><br class=""><blockquote type="cite" class=""><div class="">Il giorno 3 mag 2021, alle ore 17:36, Sukhdev Mohan <<a href="mailto:s.mohan@myti.it" class="">s.mohan@myti.it</a>> ha scritto:</div><br class="Apple-interchange-newline"><div class=""><div dir="auto" class="">Wow thanks<div dir="auto" class=""><br class=""></div><div dir="auto" class="">Will this work with quotes?</div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il lun 3 mag 2021, 17:34 Patrick Allen Zulueta <<a href="mailto:alexander.allenz@gmail.com" class="">alexander.allenz@gmail.com</a>> ha scritto:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">This works with vtiger 6 and Vtiger 7, sometimes gives error but in reports, not in salesorder/quotes, etc.<div class=""><br class=""></div><div class="">In Vtiger 7 change path vlayout by v7<br class=""><div class=""><br class=""></div><div class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">Here the successful VTIGER 6.5 code for adding custom field in the item line.</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">The example is for adding the column dept in the quote details (in the db the colum name is cf_quotes_dept)</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">Thanks to <a href="https://danssy.wordpress.com/2017/01/26/vtiger-6-5-add-column-to-item-details-in-invoice-salesorder-quotes/" target="_blank" rel="noreferrer" class="">https://danssy.wordpress.com/2017/01/26/vtiger-6-5-add-column-to-item-details-in-invoice-salesorder-quotes/</a> blog.</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">5 files have to be updated in VTIGER 6.5.</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">I will work soon on the VTIGER 7 code to set up the same field. I'll let you know. To follow .... </span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">Cathy</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">A. Add a column “cf_quotes_dept” to the vtiger_inventoryproductrel table. With a VARCHAR type.</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">B. Edit the layouts/vlayout/modules/Inventory/LineItemsContent.tpl</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">a) Add: </span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">b) Add: {assign var="dept" value="dept"|cat:$row_no}</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">C. Edit layouts/vlayout/modules/Inventory/LineItemsEdit.tpl</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">a) Add: </span><b style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">{vtranslate('LBL_DEPTLINE',$MODULE)}</b><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">D. Edit layouts/vlayout/modules/Inventory/LineItemsDetail.tpl:</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">a) Add: </span><b style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">Dept</b><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""> </span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">b) Add: {$LINE_ITEM_DETAIL["dept$INDEX"]} </span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">c) </span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">E. Edit include/utils/EditViewUtils.php</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">a) Add: $product_Detail[$i]['dept'.$i]=$dept</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">b) Add: $dept=$adb->query_result($result,$i-1,'cf_quotes_dept');</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">c) </span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">F. Edit include/utils/InventoryUtils.php</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">a) Add: $dept = vtlib_purify($_REQUEST['dept'.$i]);</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">b) Modifiy:</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">$query ="insert into vtiger_inventoryproductrel(id, productid, sequence_no, quantity, listprice, comment, description,cf_quotes_dept) values(?,?,?,?,?,?,?,?)";</span><br style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class=""><span style="font-size:14px;font-family:"lucida grande","Lucida Sans Unicode",tahoma,sans-serif" class="">$qparams = array($focus->id,$prod_id,$prod_seq,$qty,$listprice,$comment,$description,$dept);</span><span style="color:rgb(34,34,34);font-size:14px" class=""> </span></div><div class=""><font color="#222222" class=""><span style="font-size:14px" class=""><br class=""></span></font>El lunes, 3 de mayo de 2021, Sukhdev Mohan <<a href="mailto:s.mohan@myti.it" target="_blank" rel="noreferrer" class="">s.mohan@myti.it</a>> escribió:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word;line-break:after-white-space" class="">Hi,<div class=""><br class=""></div><div class="">How do you add new fields to line Item?</div><div class=""><br class=""><div class="">
<div dir="auto" style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none; word-wrap: break-word; line-break: after-white-space;" class=""><div dir="auto" style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none; word-wrap: break-word; line-break: after-white-space;" class=""><div dir="auto" style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none; word-wrap: break-word; line-break: after-white-space;" class=""><div dir="auto" style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none; word-wrap: break-word; line-break: after-white-space;" class=""><div dir="auto" style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none; word-wrap: break-word; line-break: after-white-space;" class=""><div class="">Best Regards,<br class=""><b class="">Sukhdev Mohan</b> | <b class="">Software Developer</b></div><div class=""><b class=""><br class=""></b></div></div><br class=""></div><br class=""></div><br class=""></div><br class=""></div><br class=""><br class="">
</div>
<br class=""></div></div></blockquote></div></div>
_______________________________________________<br class="">
<a href="http://www.vtiger.com/" rel="noreferrer noreferrer" target="_blank" class="">http://www.vtiger.com/</a></blockquote></div>
_______________________________________________<br class=""><a href="http://www.vtiger.com/" class="">http://www.vtiger.com/</a></div></blockquote></div><br class=""></div></div>_______________________________________________<br class=""><a href="http://www.vtiger.com/" class="">http://www.vtiger.com/</a></div></blockquote></div><br class=""></div></div></body></html>