Skip to Content

Filtering By Item Properties

Oct 02, 2017 at 02:36 PM


avatar image

Hello Experts,

I am wanting to just show items that have property 20 Selected in Item Master Data - is this possible to do?

SELECT t3.slpname as "Sales Rep", t0.Cardcode as "Customer#", t0.Cardname as "Customer Name", t0.DocNum as "SO #", t1.ItemCode, t0.DocDate, t0.DocDueDate, t1.OpenQty, t1.OpenQty*T1.price AS 'Open Value', t2.onhand FROM dbo.ORDR t0 INNER JOIN dbo.RDR1 t1 on t1.docentry = t0.docentry INNER JOIN OITM t2 on t1.itemcode=t2.itemcode Inner join oslp t3 on t0.slpcode = t3.slpcode WHERE t1.LineStatus = 'O' AND t1.OpenQty > 0

Many thanks,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Zapata Oscar Oct 02, 2017 at 04:13 PM

Hell@ James:

Only add this code at the end of your query.

AND t2.QryGroup20='Y'


Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thank you Zapata - very much appreciated.


You're welcome.