Hi,
i' ve a problem with a query: i want to see only serial number with a Credit notes but i'm not able to complete them: this is the query
SELECT T0.[ItemCode], T0.[ItemName], T1.[IntrSerial] FROM SRI1 T0 INNER JOIN OSRI T1 ON T0.SysSerial = T1.SysSerial WHERE T0.[BaseType] = 14 and T1.[Status] = '0'
Help me thanks.
regards