Hi experts,


i am working on whinr110 table in lnfp7. what query shuld i write to calculate slow moving item.

Means i need to print item having only status or whinr110.kost=2.
if the same item having another entry like issue or Inventory Adjustment those item i dont want.

suppose

Item Transtion Date Status quantity
1012 1-1-2012 receipt 50
1012 2-1-2012 issue 10

1015 3-1-2012 receipt 20


1065 4-1-2012 reciept 10
1065 5-1-2012 issue 20

***************************************************


I need to fatch only 1015.

Hi experts,


i am working on whinr110 table in lnfp7. what query shuld i write to calculate slow moving item.

Means i need to print item having only status or whinr110.kost=2.
if the same item having another entry like issue or Inventory Adjustment those item i dont want.

suppose

Item Transtion Date Status quantity
1012 1-1-2012 receipt 50
1012 2-1-2012 issue 10

1015 3-1-2012 receipt 20


1065 4-1-2012 reciept 10
1065 5-1-2012 issue 20

***************************************************


I need to fatch only 1015.

Hello,

use lattr.print for whinr110.kost=2 true/false in reportscript !

Regards

Rather than delete or close a thread could you post your solution. It might help someone in the future with the same problem.

select *
from whinr110
where whinr110.kost=2 and
not exists (select whinr110.item
from whinr110
wehre whinr110.kost<>2
and whinr110.item= :whinr110.item)[/INDENT][/INDENT]
selectdo
endselect

OR


select *
from whinr110
where whinr110.kost=2
and whinr110.item not in (select whinr110.item
from whinr110
wehre whinr110.kost<>2)
selectdo
endselect