I wanted to do a search that pull out all current customers customers, their state, sales rep and company name. When I created a new customer search it pulled out more than just customers it also picked up leads, contacts ect. Is there any way for it to grab just current customers? Also I was not able to pull out the customer id in the search which is what I needed to figure out the company since not all of the records had the name filled out. It also made it harder trying to import it back in not to be able to have this field so not sure if it override something it wasn't suppose to...
What I was trying to do was update new sales reps based on state and I had a list of ones that didn't need to change. Is there an easier way to export/import this back in (by means of using different fields perhaps?)