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

[Angelo Paglialonga]

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?

_______________

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 09:06, Matus Sopko <sopko at its4you.sk> ha scritto:
> 
>  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/
> 
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220311/700db6dd/attachment.html>