Sale Quotation

[Former Member]

Hi

I want to display a list of Document having open item quantity detail in Sale Quotation and Customer Group

docnum itemcode quantity open quantity

1 1 10 2

1 2 8 6

2 4 10 10

Thanks

[Former Member]

Closed.

[Former Member]

Hi,

Try this:

SELECT T0.DocNum, T1.ItemCode, T1.Quantity, T1.OpenQty

FROM dbo.OQUT T0

INNER JOIN dbo.QUT1 T1 ON T1.DocEntry=T0.DocEntry

WHERE T0.DocStatus = 'O'

Thanks,

Gordon

[Former Member]

Hi

In this i want to give user option to select Customer Group

Thanks

[Former Member]

Try:

SELECT T0.DocNum, T1.ItemCode, T1.Quantity, T1.OpenQty

FROM dbo.OQUT T0

INNER JOIN dbo.QUT1 T1 ON T1.DocEntry=T0.DocEntry

INNER JOIN dbo.OCRD T2 ON T2.CardCode=T0.CardCode

INNER JOIN dbo.OCRG T3 ON T3.GroupCode=T2.GroupCode AND T3.GroupType = 'C'

WHERE T0.DocStatus = 'O' and T3.GroupName = '[%0\]'