Dear Friends,
My query is about how to get list of quotation Whose target document is not created yet .
I can sort list for open quotations from queryd but partial open quotation are still there.
Please check
SELECT T0.[DocNum],T0.[CardName],T3.Name,T3.cellolar,T0.[DocDate], T2.[Dscription], T2.[Quantity], T2.[Price] FROM OQUT T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode INNER JOIN QUT1 T2 ON T0.DocEntry = T2.DocEntry Inner join OCPR T3 on T0.cntctcode=T3.cntctcode WHERE T1.[SlpName] =[%0] And T0.[DocStatus] =[%1]