Hi Kitty,

The Export Special Prices template can be configured to export only the Customer number and none of the other columns. You can then modify the Excel sheet to get what you want, depending on the version of Excel. I see in Excel 2010 that there is a function to Remove Duplicates on the 'Data' tab. Doing this with just the Customer number field will delete all records but one for each customer. This could be setup with an Excel macro, after the export has been completed, to make it more automatic.

If all you want is a list of customer that have special prices without any extra modifications, then you will need to follow the route that Doug suggested and create a customized GridView inquiry or Crystal Report. There is no standard report or process that currently exists in OrderEntry to do what you are looking for.