I am creating a BAQ to pull parts for a Dashboard that tells the user how many parts to order. I have the filters set in place, but it is still pulling the records that I do not want. Can anyone make sense of this?
You have a LOT of criteria… you may want to use the parenthesis in there to group your “ands” and “ors”.
Something like this?? Not sure what combos you want/need.
5 Likes
Or use the IN constant list to replace the OR statements.
Plus the Plant = will override the Plant <> so you will always get PYAN
4 Likes
The parentheses worked. Thank you so much for that. Don’t know why I didn’t see that. Makes sense now.
1 Like
I did use this too and it worked. Both solutions accomplish the same thing, but the list was easier to just Paste Update. Thank you!
Just curious if you went the BAQ route because you don’t have PO suggestions available? I’m pretty sure you can run generate PO suggestions without having MRP running. Then you would set your buyers based on part class or part - they would automatically get suggestions for what to buy. It would also take into consideration days of supply and other parameters not in the BAQ.
Oddly enough, we do have PO Suggestions available. I do not know why we are not doing that on this specific instance. I will ask and get back as to why we don’t use that.