Hi Guys...
We need a report for pending Orders and pending Quantities for Sales.
And for this i used a query .
SELECT T0.DocNum as 'SO No', T0.DocDate as 'SO Date', T0.CardCode, T0.CardName, T1.ItemCode, T1.Dscription, T1.Quantity AS 'SO Qty', (T1.Quantity-T1.OpenQty) AS 'Delivered Qty', T1.OpenQty AS 'Balance Qty' FROM ORDR T0 INNER JOIN RDR1 T1 ON T1.DocEntry = T0.DocEntry INNER JOIN ITM1 T2 ON T2.ItemCode = T1.ItemCode WHERE T1.LineStatus = 'O' AND T0.DocDate BETWEEN '[%0]' AND '[%1]' and ((T1.Quantity-T1.OpenQty) != 0 )
But i need the report like
Sales Quotation No ,Sales Quotation Date,Sales Order No,Sales Order Date,Delivery No,Delivery Date,Invoice No,Invoice Date,
Customer Name,Item Code,Item Des, and Pending Quantity.
Thanks & Regards,
Vamsi