Remote Details:-
id:-talbros
p:-manager@123
eid:-finance@talbrosaxles.com
SLD P:-sap@123
sq P:-tel@2012
id:-talbros
p:-manager@123
eid:-finance@talbrosaxles.com
SLD P:-sap@123
sq P:-tel@2012
Friday, 9 August 2019
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 )
Subscribe to:
Comments
(
Atom
)