[Vtigercrm-developers] Webservice Query then Update on Inventory modules will delete ALL LineItems

Martin Allen martin.allen at exe-squared.co.uk
Wed May 12 14:08:45 GMT 2021

Just raised this as an issue, but wanted to make people aware of it - https://code.vtiger.com/vtiger/vtigercrm/issues/1604

If you use the Webservice query operation (or Server API vtws_query) on an Inventory module (Quotes, Invoices, Sales Order..) then using the data returned by the query, do an update operation (or server API vtws_update) - it will delete ALL LineItems from the record, which then automatically changes the values on the record to 0.

The solution is to do a 'retrieve' using the id returned by the query, and then use this data to pass through to the update operation instead (the retrieve data returned includes an Array of 'LineItems' which is missing from the query data.

Hopefully this stops someone else having the same problem...

Martin Allen

[cid:image001.png at 01D74740.9287EEA0]

01392 690659 (Direct)
01392 248692 (Main Office)

The information in this email is confidential If you are not the intended recipient, you must not read or use that information. This email and any attachments are believed to be virus free however no responsibility is accepted by Exe Squared Ltd for any loss or damage arising in any way from receipt or use thereof. Exe Squared Ltd Company Reg Number 12185709, is based at Silverdown Park, Fair Oak Close, Exeter Airport Business Park EX5 2UX.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210512/2bf751a3/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 11949 bytes
Desc: image001.png
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210512/2bf751a3/attachment-0001.png>

More information about the vtigercrm-developers mailing list