Report Filter Issue
I'm trying to run a report to determine what we need to reorder, but despite having filters to weed out orders we designate as "Vendor Return", these orders are still pulling through. I've tried setting up filters so that anything with Manual Order = Vendor Return is ignored, Discount Reason = Vendor Return is ignored, and these orders still keep pulling through. Any suggestions?
-
Hi Caroline
In theory that looks fine - Have you validated that the data is correct ( rather than the filter being broken)?
Remember these fields are also case sensitive - that has tripped us up a few times.
Perhaps you could throw together a quick report to look at only "sales by item" "order . manual order type" = "Vendor Return" and see if that returns what you would expect?
I hope this helps!
Alisdair
-
OK, so after looking at your primary query again, the issue is the OR operator you're using to try to exclude both Vender Return orders and PR orders. See, that operator is making a split, so your query is processing everything up to the first or as one AND statement, and everything after the OR as another AND statement.
The way you have your query written, you should be able to change that OR to an AND to also exclude manual_order_type = PR orders.
-
Hi all,
Manual Order Type is an attribute that we set up to help us classify our orders (Employee, Vendor Return, Test, etc) since there are certain things we don't want showing up when we run sales data.
I've tried copying and pasting the phrase directly from the attributes page, but that doesn't seem to be working either. I'll trying running a separate query on just those order types.
Please sign in to leave a comment.
Comments
7 comments