Update CRM Qty in Stock based on ZCreator subform
Hi,
I went through the CRM update record tutorial, but wasn't successful in creating what I need.
I created a form "Store_Records", and a subform "Store_Items", in the subform there is a CRM field related to products to select a product from CRM and a number field "Issued_Qty".
I need to update the "Qty in Stock" under CRM module "Products" based on the issued qty for each selected product.
Example: If I select 3 items type A, I need to subtract 3 from the current Qty in Stock in CRM. Need to do this for each row selected product on my subform.
Any wizard can help me with this?
Thanks,