Skip to Content
0
Former Member
Feb 01, 2010 at 09:31 AM

Pending Quantity

624 Views

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