I would like to collect zip codes from each customer and print a report each month that shows what zip codes the customers are from. My customer is a museum and gets visitors from around the U.S. and the world, so it is not possible to create fake customers with the various zip codes as there are too many.
Throught the POS Options in the Manager, we were able to turn on "Prompt for details at POS". This gives the clerk a screen at the beginning of each transaction and we started typing in the zip code in the "Reference Number" block. I found a report in the Reports Library (that I modified) that allows us to print the contents of the Reference Number field in a Detailed Sales Report. At first this looked fine, but I realized that it was giving us the zip codes for each item that is sold, not on the sale. The report I am looking for needs to be tagged to the transaction and not to the individual items. If it's tagged to each item, it inflates the number of zip codes.
Does anyone know how to effectively record zip codes and then get a report of the number of customers and their zip codes? This is a common request from customers and it would surprise me if it wasn't already available through some feature in the program or as an inexpensive add-on.