physical count sheet shows wrong departments and catagories

I am using rms version 1.2. When I try to produce an physical inventory count sheet using the filter, the departments and categories are mixed up. I set the filter as inactive= no and category name= (category). Some of the filters show completely blank and other categories show products that are in totally different departments and categories. However if I look at the product properties they all have the correct departments and properties. What is going on and how do you fix this???