cancel
Showing results for 
Search instead for 
Did you mean: 

Pending Quantity

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Vamsi,

You may check this thread first:

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordon,,

Really its solves the problem... thanks..

I will not be regularly using forum so not replied.

Former Member
0 Kudos

Hi,

do you mean this?

 

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)     Like '[%%_%%]'   )

Edited by: Doreen Cieslewski on Apr 27, 2010 5:52 PM

Edited by: Doreen Cieslewski on Apr 27, 2010 5:54 PM

Former Member
0 Kudos

Hi Doreen..

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.