By using this website, you agree to our Terms of Use (click here)
Hi All,
I'm confused by a simple condition I setup.
I'm working with just the INLocationStatus table, and I setup the following filter:
INLocationStatus.InventoryID contains SM
(I also tried starts with, 'SM', and a few other variations).
When I run the GI it's empty, but if I remove the condition, I have a ton of results.
Any idea why a filter would cause this?
Thanks!
You set SM as a hard condition, like if you were looking for a system code. I have a feeling you want ='SM' which is a text string.
Are you filtering on-the-fly in the screen? Or are you filtering using the CONDITIONS tab on the Generic Inquiry (SM208000) screen?
Another reason might be that you're using INLocationStatus.InventoryID which is a meaningless database key value. You might need to join over to InventoryItem and pull the InventoryItem.InventoryCD value in order to filter on it.
I loaded up your inquiry and I set your SM to ='SC', because my item items ID's start with "SC". I got a list of my ID's, such as:
Thanks Michael, good to know I'm not crazy.
Tim - I am trying to filter with the conditions tab.
I think I've isolated it to a specific problem...
If I use contains, it does not work. If I use equals, it works. Odd?
So for our part 931700-RING, if if I say equals 931700-RING, I get a result. If I say contains RING, I get nothing.
Based on Tim's advice, I'm looking just at the InventoryItem table and adding a condition for InventoryCD.
Thanks,
Matt
Online Members
