[Vtigercrm-developers] lineitems in table vtiger_inventoryproductrel deleted and created in each edit

[Matus Sopko]

But lineitem  are very dynamic, you can change

  * price
  * quantity
  * sequence
  * Product/Service from lineitem to another
  * add new Product/Service into lineitem
  * delete existing Product/Service from lineitem

with all conbinations.

This is not like track one statisc field from Accounts.


S pozdravom / Best regards / Mit freundlichen Grüßen
Matus SOPKO

Dňa 11. 3. 2022 o 8:47 Angelo Paglialonga napísal(a):
> Well in my opinion there should be a lineitem save event and tracking 
> history like for accounts fields. What do you think?
>
> _______________
>
> Angelo Paglialonga
> Consulente per soluzioni CRM ad alto ROI.
>
> Telefono: 3386077866
> Skype: angelo.paglialonga
> Web: https://www.angelopaglialonga.com
>
>
>> Il giorno 11 mar 2022, alle ore 08:31, Matus Sopko <sopko at its4you.sk> 
>> ha scritto:
>>
>>  Yes, you are right. The "Update" process is done with Delete and 
>> Insert lineitems  again.
>> I'm thinking about how to check if Productblock(lineitems) was changed.
>> Maybe this control is more difficult like delete and insert again.
>> 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:sopko at its4you.sk
>> http://www.its4you.sk
>> skype: matussopko
>> Dňa 11. 3. 2022 o 3:28 Rubén A. Estrada Orozco napísal(a):
>>> 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.
>>>
>>> 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?
>>>
>>> Saludos
>>>
>>> Rubén
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>
>> _______________________________________________
>> http://www.vtiger.com/
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220311/3d75ce26/attachment-0001.html>