Skip to Content
0
Former Member
Feb 12, 2011 at 07:19 AM

How to septate out documents

28 Views

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]