Wednesday, January 29, 2014

Dynamics GP - Remove Empty Item/Site assignments

select * from iv00102 where QTYONHND = 0 and ATYALLOC = 0 and qtysold=0 and lsordqty= 0 and QTYONORD = 0 and LOCNCODE <> ''

delete  from iv00102 where QTYONHND = 0 and ATYALLOC = 0 and qtysold=0  and lsordqty= 0 and QTYONORD = 0 and LOCNCODE <> ''

No comments:

Post a Comment