Filter for Item Movement Report

Dec 11, 2007 5 Replies
B

I am trying to filter a report so it gives me the item movements for 10 items for a given date range excluding the Inventory Wizard Type.



I have done the following which works for one Item DATE Between 11/1/2007 AND 12/1/2007 AND Item Lookup Code = 087123000917 AND Type Invetory Wizard



If I then add the following I get no results OR DATE Between 11/1/2007 AND 12/1/2007 AND Item Lookup Code = 087123000184 AND Type Invetory Wizard



However if I do the following filter I get results but with the Invetory Wizard Types DATE Between 11/1/2007 AND 12/1/2007 AND Item Lookup Code = 087123000917 OR DATE Between 11/1/2007 AND 12/1/2007 AND Item Lookup Code = 087123000184



Any Ideas? The Item Invetory Report is perfect but we just want to do more than one item at a time.


Vote
Twitter Facebook LinkedIn
C

Try listing the items first using OR , then the other criteria, like...

Item Lookup Code = 234523 OR Item Lookup Code = 234251 OR Item Lookup Code = 3453452 OR Item Lookup Code = 435532 OR Item Lookup Code = 2345329 AND DATE Between 11/1/2007 AND 12/1/2007 AND Type Invetory Wizard

Are you runn> I am trying to filter a report so it gives me the item movements for 10 items

Vote
Twitter Facebook LinkedIn
B

I tried what you suggested it did not work but If I did the following I get results:

Item Lookup Code = 234523 OR Item Lookup Code = 234251 OR Item Lookup Code = 3453452 OR Item Lookup Code = 435532 OR Item Lookup Code = 2345329 AND DATE Between 11/1/2007 AND 12/1/2007

As soon as I add the second AND statement I get no records returned.

Thanks

Vote
Twitter Facebook LinkedIn
B

Item Lookup Code = 234523 AND Date Between 11/1/2007 AND 12/1/2007 AND Type Inventory Wizard OR Item Lookup Code = 234251 AND Date Between 11/1/2007 AND 12/1/2007 AND Type Inventory Wizard OR Item Lookup Code = 3453452

AND Date Between 11/1/2007 AND 12/1/2007 AND Type Inventory Wizard

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required