1. Home
  2. Point-Of-Sale Software
  3. Filter for Item Movement Report

Filter for Item Movement Report

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.

Reply to
Bart M
Loading thread data ...

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

Reply to
convoluted

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

Reply to
Bart M

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

Reply to
Barry L

Reply to
convoluted

Reply to
Barry L

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.