This stuff has no bearing on us because we already have CR6, but I do have
an idea that seems simple enough to take care of the people who don't have
CR6.
Maybe a new table ("ISP" or something) could be added to the Emerald db that
contains at least the following columns (at least in the US):
Company varchar(50)
Address1 varchar(50)
Address2 varchar(50)
City varchar(50)
State varchar(20)
Zip varchar(10)
Email varchar(50)
Phone varchar(20)
SupportURL varchar(50)
And have IEA take whatever Invoice.rpt file they distribute and either make
a copy of it or modify it so that the above information is displayed on it
in some way so that the companies that don't have a way of editing the
reports at least have their company's info on the invoice for when they
mail/email it out. This would work for all companies and wouldn't be
customized in any way for one individual company.
Obviously, anyone with CR6 can remove the information off of the Invoice.rpt
file if they didn't want it, and could also not bother creating the new
table in Emerald unless they had some other use for it.
So my suggestion is for IEA to write/release a short SQL script to generate
a generic "ISP" table for the Emerald db and insert those columnnames into a
revised invoice.rpt file so that the output looks organized in some way,
maybe something like:
ISP Name Phone: 850-555-1212
123 Main St. Email: support@whatever.com
PO Box 1234 Support: http://support.whatever.com
Tallahassee, FL 32301
Josh Hillman
hillman@talstar.com