<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="">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>_______________<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><br class=""></div><br class="Apple-interchange-newline">
</div>
<div><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></body></html>