Purchaser and Location rarely the same

OK, I'll give it a try.
Order Management Memos, Category for Site Address, maybe job and project.
Some report builder reports using memo's say filtering for site then listing
all orders and items issued by contractor that ordered from you. O'well I
tried. Could do the same in VBFORMS.

Patrick

-----Original Message-----
From: David M Gartner [mailto:dgartner@...]
Sent: Friday, March 22, 2002 1:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Purchaser and Location rarely the same


Does any else have the dilemma of a contractor, receiver of the quote and
invoice, buying the product and installing it at another location owned by
the final customer? We need to follow the final customer and are curious if
others "solved" this problem.


An example:
EPG Companies sells pumps and control panels to a contractor who then
installs the products at a landfill. The owner of the landfill may never
contact us during the initial install, but normally we know the landfill.
The final location is the landfill.

We will never hear from the contractor regarding this job if everything goes
smoothly. They may work again at another site or even the same one. A
different contractor may install additional equipment at the same site at a
later date as well.

We would like to be able to search / generate a list of equipment at a site.
It would be nice to search by either job number, project number, site name,
or site address.

Just to add another smaller wrinkle. The name and address can change over
time.

Thanks in advance for the group's help.


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Does any else have the dilemma of a contractor, receiver of the quote and
invoice, buying the product and installing it at another location owned by
the final customer? We need to follow the final customer and are curious if
others "solved" this problem.


An example:
EPG Companies sells pumps and control panels to a contractor who then
installs the products at a landfill. The owner of the landfill may never
contact us during the initial install, but normally we know the landfill.
The final location is the landfill.

We will never hear from the contractor regarding this job if everything goes
smoothly. They may work again at another site or even the same one. A
different contractor may install additional equipment at the same site at a
later date as well.

We would like to be able to search / generate a list of equipment at a site.
It would be nice to search by either job number, project number, site name,
or site address.

Just to add another smaller wrinkle. The name and address can change over
time.

Thanks in advance for the group's help.


[Non-text portions of this message have been removed]