Page 1 of 1

Exporting customer list

PostPosted: Tue Apr 25, 2006 10:40 am
by robc
Does anyone know the steps for pulling a customer list (and putting in Excel) of those who were in the shop 6-7 months ago but haven't been back. Thanks for your help!

------------------
** Rob, Editor Dealersedge/WD&S **
Help is only a message post away!
robc@dealersedge.com


Exporting customer list

PostPosted: Tue Apr 25, 2006 11:58 am
by partstom
If you are ADP you can use Executive Assistant, there is a canned query all set up in it.

Tom

Exporting customer list

PostPosted: Wed Apr 26, 2006 9:23 am
by homesleym
In ADP won't the below item in the -S HISTORY file give you that?

"CUST LAST SVC DATE"

or maybe this though not quite the same?:

"S-LTDATE" in VEHICLES file.

[This message has been edited by homesleym (edited 04-26-2006).]


Exporting customer list

PostPosted: Wed Apr 26, 2006 11:21 pm
by jazdale
homesleym
I think VEHICLES would be better than the HISTORY file.
There is only one VEHICLES item per car, but there can be several HISTORY items per car.

Exporting customer list

PostPosted: Fri Apr 28, 2006 6:03 am
by homesleym
good point Jazdale. Thanks

------------------