<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Ok interesting points, so how can we track line item changes to handle updating products stock? I know deleting an order affects stock, adding it too, but what about modifying an order lines?<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 11 mar 2022, alle ore 09:06, Matus Sopko <sopko@its4you.sk> ha scritto:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
But lineitem are very dynamic, you can change<br>
<ul>
<li>price</li>
<li>quantity</li>
<li>sequence</li>
<li>Product/Service from lineitem to another<br>
</li>
<li>add new Product/Service into lineitem </li>
<li>delete existing Product/Service from lineitem </li>
</ul>
<p>with all conbinations. <br>
</p>
<p>This is not like track one statisc field from Accounts.</p>
<p><br>
</p>
<pre class="moz-signature" cols="72">S pozdravom / Best regards / Mit freundlichen Grüßen
Matus SOPKO
</pre>
<div class="moz-cite-prefix">Dňa 11. 3. 2022 o 8:47 Angelo
Paglialonga napísal(a):<br>
</div>
<blockquote type="cite" cite="mid:078312EA-22EE-4F9C-A5E3-1A8C196176B7@angelopaglialonga.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
Well in my opinion there should be a lineitem save event and
tracking history like for accounts fields. 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: <a class="moz-txt-link-freetext" href="https://www.angelopaglialonga.com">https://www.angelopaglialonga.com</a></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 11 mar 2022, alle ore 08:31,
Matus Sopko <a class="moz-txt-link-rfc2396E" href="mailto:sopko@its4you.sk"><sopko@its4you.sk></a> ha scritto:<br>
<br>
</blockquote>
</div>
<blockquote type="cite">
<div dir="ltr">
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
Yes, you are right. The "Update" process is done with Delete
and Insert lineitems again.<br>
I'm thinking about how to check if Productblock(lineitems) was
changed.<br>
Maybe this control is more difficult like delete and insert
again.<br>
<pre class="moz-signature" cols="72">S pozdravom / Best regards / Mit freundlichen Grüßen
Ing. Matus SOPKO
IT-Solutions4You s.r.o.
Kancelária: Slovenská 69
Sídlo: Frantiskanske nam.5
080 01 Prešov
SLOVAKIA
Tel./ Fax +421/ 51/ 7732370
email: <a class="moz-txt-link-abbreviated moz-txt-link-freetext" href="mailto:sopko@its4you.sk" moz-do-not-send="true">sopko@its4you.sk</a>
<a class="moz-txt-link-freetext" href="http://www.its4you.sk" moz-do-not-send="true">http://www.its4you.sk</a>
skype: matussopko</pre>
<div class="moz-cite-prefix">Dňa 11. 3. 2022 o 3:28 Rubén A.
Estrada Orozco napísal(a):<br>
</div>
<blockquote type="cite" cite="mid:CAKjsHQ_k2q+DeoDaNajPpSeMih0XH5heuyaysTZjRt3N-xq_dw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
<div dir="ltr">Today I noticed that every time you edit an
inventory module record, its corresponding line items in
the vtiger_inventoryproductrel are deleted and created
again even if you don't change anything about line items.
You can see that, because the "lineitem_id" in the
vtiger_inventoryproductrel table changes and the previous
ones get deleted.
<div><br>
</div>
<div>For example, if you edit the subject of a quote, the
line items are deleted and created again. Isn't that
sort of inefficient? Or can it be considered a
negligible waste of resources?
<div><br>
</div>
<div>
<div>
<div>
<div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">Saludos
<div><br>
</div>
<div>Rubén</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/" moz-do-not-send="true">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<span>_______________________________________________</span><br>
<span><a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></span></div>
</blockquote>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<span>_______________________________________________</span><br><span>http://www.vtiger.com/</span></div></blockquote></body></html>