Are Gridview Filters limited to 50 lines?

I think the limit is related more to the maximum number of nested IF() clauses or characters, not lines.

When Filters get this complex, it's often well worth while to look for alternative ways to select the records you want to consider.

What is the Filter trying to accomplish?

We thought the same after exceeding the limit so we've reverted to an alternative.

The issue now is that we added a new item today and it won't show up on Gridview. We're using "I/C Item Locations Master". The item is active at one location. What are we doing wrong?

The only filter we have on this is: {UPC} = "ABC"

I suppose I have corrupt data since it's telling me that I can't make it inactive because there are quantities on hand when there isn't.

This would have happened in the last 8 hours?

Yes. DataCare will likely rebuild it tonight. I'm hoping we can get through the rest of the day.

Can you send me the View?

I added another item and it's in the view. There's a problem only with one item added today, but other items added today are okay.

Does the item appear in the GridView view with the filter disabled? Just so we know whether to focus on the data or the GV filter.

No. It won't appear with or without filter.