Skip to Content
0
Feb 04, 2011 at 08:31 AM

User Defined Values Setup (formatted searches)

33 Views

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