New on the forum… had a question regarding the customer list that the system returns by default (Customer Maintenance → Customer Search → Search all) vs a query I created. When I do the default search, the system is returning 727 customers. I see that some of these customers do not belong to a “group.” I have included “groups” and “types” in my query but it is not showing the customers that do not belong to a group. What am I missing?
You need to change the join between Customer and Customer Group to an outer join.
Do you know SQL? If not, I would recommend finding some way to learn the basics. I do not know of any resources, but I am sure a search would return something.