Dear Experts,
I created the query below to draw inventory items transferred onto a service card into invoice rows:
SELECT T1.[ItemCode], T1.[TransToTec] FROM OSCL T0 INNER JOIN SCL2 T1 ON T0.callID = T1.SrcvCallID WHERE T0.[callID] =[%0] GROUP BY T1.[ItemCode], T1.[TransToTec] ORDER BY T1.[ItemCode]
This works fine except that I want it to update the quantity field of the invoice with the respective quantities transferred to the technician.
Can anyone help?
Thank you.
John