on 02-01-2010 9:31 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.