<div dir="ltr">Sorry. I think that you was using the default vtiger PDF module. To achieve that, I only add the fields to table vtiger_inventoryproductrel but also in table vtiger_list. With this two, vtiger pdfmaker show the option to add this fields in your template without the need of change anything in code.<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El lun, 17 abr 2023 a las 3:31, Ing. Matus Sopko (<<a href="mailto:sopko@its4you.sk">sopko@its4you.sk</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
You can develop own customfnction to get quantity_pending value from
vtiger_inventoryproductrel table.<br>
<br>
<a href="https://it-solutions4you.com/manuals/vtiger7/pdfmaker/#custom-functions" target="_blank">https://it-solutions4you.com/manuals/vtiger7/pdfmaker/#custom-functions</a><br>
<br>
<pre cols="72">S pozdravom / Best regards / Mit freundlichen Grüßen
Matus SOPKO
IT-Solutions4You s.r.o.
</pre>
<div>Dňa 17. 4. 2023 o 9:07 Jorge Eduardo
Olaya Perdomo napísal(a):<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)">Thank
you<br>
<br>
I understood him that the proposed solution is to update
pdfmaker, with the current version it is not possible to add
more fields as I am trying to do, taking into account that I
am trying to do it directly in the source code.<br>
</div>
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">El dom, 16 abr 2023 a la(s)
22:10, Alexander Allen (<a href="mailto:alexander.allenz@gmail.com" target="_blank">alexander.allenz@gmail.com</a>)
escribió:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hola
Jorge. Me refiero a este módulo adicional. Te consulté porque
es mucho más práctico que el template predeterminado de
vtiger. Puede que te sirva
<div><br>
</div>
<div><a href="https://it-solutions4you.com/manuals/vtiger7/pdfmaker/" target="_blank">https://it-solutions4you.com/manuals/vtiger7/pdfmaker/</a></div>
<div><br>
</div>
<div>Tienen una versión gratuita que considero que puede
servirte. Por eso era mi pregunta si lo habías utilizado <br>
<br>
El domingo, 16 de abril de 2023, Jorge Eduardo Olaya Perdomo
<<a href="mailto:jorgeeolayap@gmail.com" target="_blank">jorgeeolayap@gmail.com</a>>
escribió:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)">Thank
you Alexander for answering.<br>
<br>
If I have used it, I fail to see the scope of your
question.<br>
<br>
If I place myself in a profile of a normal user, I
understand how the tool works.<br>
<br>
I am trying to understand the code to be able to add
two fields that are in the vtiger_inventoryproductrel
table which are quantity_pending and quantity_sent and
add them to the quote template<br>
</div>
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">El dom, 16 abr 2023 a
la(s) 20:54, Alexander Allen (<a href="mailto:alexander.allenz@gmail.com" target="_blank">alexander.allenz@gmail.com</a>)
escribió:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Have you use Vtiger
PDFMaker from it4you? <br>
<br>
El domingo, 16 de abril de 2023, Jorge Eduardo Olaya
Perdomo <<a href="mailto:jorgeeolayap@gmail.com" target="_blank">jorgeeolayap@gmail.com</a>>
escribió:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br clear="all">
</div>
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)">
<p>There
is a module for vtiger that is pdfmaker In
this module you can make templates and
parameterize the combinable fields</p>
<p>I
want to add two more variables to this list of
variables</p>
<p>In
the pdfmaker script there are these lines</p>
<p>$Product_Fields["PRODUCTQUANTITY"]
= vtranslate("LBL_VARIABLE_QUANTITY",
"PDFMaker");
$Product_Fields["PRODUCTUSAGEUNIT"] =
vtranslate("LBL_VARIABLE_USAGEUNIT",
"PDFMaker");
$Product_Fields["PRODUCTLISTPRICE"] =
vtranslate("LBL_VARIABLE_LISTPRICE",
"PDFMaker"); $Product_Fields["PRODUCTTOTAL"] =
vtranslate("LBL_PRODUCT_TOTAL", "PDFMaker");
$Product_Fields["PRODUCTDISCOUNT"] =
vtranslate("LBL_VARIABLE_DISCOUNT",
"PDFMaker");
$Product_Fields["PRODUCTDISCOUNTPERCENT"] =
vtranslate("LBL_VARIABLE_DISCOUNT_PERCENT",
"PDFMaker");
$Product_Fields["PRODUCTSTOTALAFTERDISCOUNT"]
=
vtranslate("LBL_VARIABLE_PRODUCTTOTALAFTERDISCOUNT",
"PDFMaker");
$Product_Fields["PRODUCTVATPERCENT"] =
vtranslate("LBL_PRODUCT_VAT_PERCENT",
"PDFMaker"); $Product_Fields["PRODUCTVATSUM"]
= vtranslate("LBL_PRODUCT_VAT_SUM",
"PDFMaker");
$Product_Fields["PRODUCTTOTALSUM"] =
vtranslate("LBL_PRODUCT_TOTAL_VAT",
"PDFMaker"); $result["SELECT_PRODUCT_FIELD"] =
$Product_Fields;</p>
<p>I
added</p>
<p>$Product_Fields["PRODUCTQUANTITYPENDING"]
= vtranslate("LBL_VARIABLE_QUANTITYPENDING",
"PDFMaker");
$Product_Fields["PRODUCTQUANTITYSEND"] =
vtranslate("LBL_VARIABLE_QUANTITYSEND",
"PDFMaker");</p>
<p>but
in the template it does not match me</p>
<p>How
do I get it to combine?</p>
</div>
<div class="gmail_default" style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div>
<div dir="ltr">
<div dir="ltr">
<div style="font-size:13px;font-family:georgia,serif;color:rgb(51,102,102)">---------------------------------------------------------------</div>
<div style="font-size:13px;font-family:georgia,serif;color:rgb(51,102,102)"><br>
</div>
<div><font style="font-family:georgia,serif;font-size:13px" color="#336666"> Jorge Eduardo Olaya
Perdomo </font><font style="font-family:georgia,serif;font-size:13px" color="#336666"><br>
</font><a href="mailto:jorgeeolayap@gmail.com" target="_blank"><font face="georgia, serif" color="#336633">jorgeeolayap@</font>gmail.com</a><br>
<font style="font-family:georgia,serif;font-size:12.8px" color="#336666"><span style="font-size:13px">Celular:
3223426320</span><br>
</font><span style="font-family:georgia,serif;font-size:12.8px"><font color="#336666">Código postal: 730005</font></span></div>
</div>
</div>
</div>
</div>
</blockquote>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote>
</div>
</blockquote>
</div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div>