My World
Tuesday, 6 August 2019
NON MOVEING ITEM LAST 30 DAYS
NON MOVEING ITEM LAST 30 DAYS
SElect ItemCode,Whscode, OnHand from oitw t1 where t1.OnHand<>'0' AND t1.WhsCode ='I_POSTIH'
and ItemCode not in (Select v1.itemcode from OINM v1 where v1.TransType in('67','20','202') and v1.DocDate>GETDATE()-30 )
No comments :
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments ( Atom )
No comments :
Post a Comment