Is There a Way to Sort and Print My 8-Year Contact List in P3?

[chefmeg]

Ok you computer savvy folks, I am trying to print my contact list in P3...it is 8 years worth and there looks to be no way for me to sort it so that only contacts with phone numbers come up.....it is 180 pages with everyone on there!
HELP!

 

[pamperedbecky]

Ok you computer savvy folks, I am trying to print my contact list in P3...it is 8 years worth and there looks to be no way for me to sort it so that only contacts with phone numbers come up.....it is 180 pages with everyone on there!
HELP!

I wish I knew how! I'd love this information too. There's GOT to be a way to do it.

 

[chefmeg]

right now, I am tryin to go through an Order History as it looks like the only place you can select phone number....I picked Stoneware as a catagory so we'll see what comes up! I think my laptop is in overload mode!

 

[chefann]

it's kinda hidden.Go to Reports > Shows > Customer List. Then pick a dollar amount of 0, and select Primary Phone only. Uncheck address.The problem is that if someone placed multiple orders, they'll be on the list more than once. But it's the only way I've found to do a customer list without addresses, only phone numbers.

 

[crystalscookingnow]

Why not export your contact list to something like excel, include phone numbers. Then when in excel (or equivalent) sort by customer name, then delete any duplicates.

I hate the report listing from P3 & do this all of the time. There is definitely a way that they could (and should!) clean up those reports to not have so much wasted white space. As a past reports developer, it drives me CRAZY!

 

[chefmeg]

Ok-that got it down to 165, but at tleast I have only people I can truly call!

Thanks Ann!! You know I love ya!

 

[chefann]

Why not export your contact list to something like excel, include phone numbers. Then when in excel (or equivalent) sort by customer name, then delete any duplicates.

I hate the report listing from P3 & do this all of the time. There is definitely a way that they could (and should!) clean up those reports to not have so much wasted white space. As a past reports developer, it drives me CRAZY!

There are a lot of reports I wish we could customize a little more. Like the customer report by order amount. I wish we could have the program add together someone's orders within a specified time period so that we could see who our top customers were without having to manually add the order amounts.

And I agree, as a former report person, it drives me crazy!

 

[chefmeg]

I took Crystal's advice and got the report down to 21 pages!

 

[pamperedbecky]

I took Crystal's advice and got the report down to 21 pages!

That's awesome! I will definitely have to try that when I have some time.

 

[crystalscookingnow]

Glad I could help! I wish that we could export the data that's on the reports. That would allow us to do what Ann was requesting (adding the same customer's multiple orders).

 

[chefann]

I know it's possible - I just don't know enough about client-server technologies (or the specific database that P3 saves the data in) to write it myself. But I wrote reports like that all the time in my previous job.

 

[DebbieJ]

Why not export your contact list to something like excel, include phone numbers. Then when in excel (or equivalent) sort by customer name, then delete any duplicates.

I hate the report listing from P3 & do this all of the time. There is definitely a way that they could (and should!) clean up those reports to not have so much wasted white space. As a past reports developer, it drives me CRAZY!

that drives me bonkers, too.