I am having issues getting custom reports to pull expected sales when including conditions with item categories. Here is a basic example of what I am seeing:
If I run a custom report for the last 7 days using a simple condition of "sales person" is "Ashley". It will pull up the sales as expected. (see screenshot)
You can see the items sold and the category of each in the picture above. Now if I just add an AND condition to this same report stating that the "Item Category" "IS NOT" "Little Fox Creations" (which you can see that none of the items sold in the first screenshot were in that category) It will not pull up the same sale that meets both conditions (see second screenshot).
As I said this is a simple example. My main goal is to generate a report that pulls all sales made by a specific employee that contain items in a parent category or any of it's children categories.
SW Version: PHPPOS 17.7 download version
Thanks you for helping with this issue. Let me know if you need any more information from me.
Please sign in to leave a comment.