Adding Cust. BILL-TO Phone No. in Sales Order - where is it?

Whoops... now that I've done that I get Error 0.


--- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...> wrote:
> Ben,
> You will need to set up ODBC on the workstation (I am guessing you
have that
> done by the sounds), and you will need to remove the leading ;
from the last
> three or four lines in the .mfg file the users use to launch
Vantage (and
> restart Vantage). They contain the ODBC login information.
> If I am not mistaken the Error 599 will clear up then.
> Good luck,
> Aaron Hoyt
> Vantage Plastics
> A couple of added note for speed.
> Filter the subreport by your company id hard coded, and make sure
you are
> linking the Company field in the links via ODBC. Oh, and if there
is any
> reason you might not want the subreport to show in some
situations, add
> those into the suppress if section for the subreport. Also, make
sure you
> have plenty of ODBC servers setup in your Progress Explorer.
>
> -----Original Message-----
> From: bbelzer42 [mailto:bbelzer@t...]
> Sent: Monday, January 31, 2005 4:25 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Adding Cust. BILL-TO Phone No. in Sales
Order -
> where is it?
>
>
>
>
> Aaron,
>
> I did what you said, and I have a small subreport now with the
field
> I want in it. I linked them, yet now when I try to print I get
> error 599. I think thats the error for "Error connecting to SQL
> Server"
>
> Have you run across this? Did I do it incorrectly?
>
> Thanks,
> Ben
>
> --- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...>
wrote:
> > Sue,
> > Create a Subreport in the SOForm. Link by using the order
> number. In the
> > subreport link via ODBC to the Vantage Progress DB. Bring in the
> OrderHed
> > table and then link that to the Customer table via CustNum. In
> the Customer
> > Table you will find the BTPhonNum.
> > This is a bit of a pain if you have not used ODBC to improve
> the "Vantage
> > Standard Exported DBFs" that most all of us have complaints about
> missing
> > data, but once you have done this a time or two, it's really no
> big thing.
> > Good Luck,
> > Aaron Hoyt
> > Vantage Plastics
> >
> > -----Original Message-----
> > From: Susan Iverson [mailto:siverson@j...]
> > Sent: Friday, January 28, 2005 1:02 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Adding Cust. BILL-TO Phone No. in Sales
Order -
> where
> > is it?
> >
> >
> >
> > Sales would like to have the BILL-TO PHONE NUMBER added to their
> Crystal
> > SALES ORDERS. I looked at the tables and all I can find is the
> Bill-To
> > Fax and Bill-To Email address fields - but no Bill-To PHONE. Am I
> blind
> > or has Epicor hidden it in another obscure table to torment us?
> >
> >
> >
> > Sue
> >
> > Vantage 6.1 on Progress database Win2000 server.
> >
> >
> >
> > [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
> > Yahoo! Groups Links
>
>
>
>
>
> 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
> Yahoo! Groups Links
Sales would like to have the BILL-TO PHONE NUMBER added to their Crystal
SALES ORDERS. I looked at the tables and all I can find is the Bill-To
Fax and Bill-To Email address fields - but no Bill-To PHONE. Am I blind
or has Epicor hidden it in another obscure table to torment us?



Sue

Vantage 6.1 on Progress database Win2000 server.



[Non-text portions of this message have been removed]
I think this is located in the customer contact table.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Susan Iverson [mailto:siverson@...]
Sent: Friday, January 28, 2005 1:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order - where is
it?



Sales would like to have the BILL-TO PHONE NUMBER added to their Crystal
SALES ORDERS. I looked at the tables and all I can find is the Bill-To Fax
and Bill-To Email address fields - but no Bill-To PHONE. Am I blind or has
Epicor hidden it in another obscure table to torment us?



Sue

Vantage 6.1 on Progress database Win2000 server.



[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
The ship-to fax field is in the OrderHed table - but no ship-to phone.
It doesn't make sense.



Sue



-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Friday, January 28, 2005 10:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order -
where is it?



I think this is located in the customer contact table.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Susan Iverson [mailto:siverson@...]
Sent: Friday, January 28, 2005 1:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order - where
is
it?



Sales would like to have the BILL-TO PHONE NUMBER added to their Crystal
SALES ORDERS. I looked at the tables and all I can find is the Bill-To
Fax
and Bill-To Email address fields - but no Bill-To PHONE. Am I blind or
has
Epicor hidden it in another obscure table to torment us?



Sue

Vantage 6.1 on Progress database Win2000 server.



[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/.
<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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it be
copied in any way. If received in error, please delete and notify the
sender via e-mail or sales@... quoting the name of the sender.
Messages sent via this medium may be subject to delays, non-delivery and
unauthorized alteration. This e-mail has been prepared using information
believed by the author to be reliable and accurate. Unless expressly
stated otherwise, this e-mail does not form part of a legally binding
contract or agreement between recipient and Innovative Office Products,
Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments. It is, therefore, your responsibility to scan
attachments (if any).



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/.
<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




_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



[Non-text portions of this message have been removed]
Ship to information is also in the contact table.
I think you have to join orderhed company, custnum, shiptonum to shipto
table then you can join contacts to the shipto and I think you finally have
the shipping contact for the order.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Susan Iverson [mailto:siverson@...]
Sent: Friday, January 28, 2005 2:18 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order - where
is it?



The ship-to fax field is in the OrderHed table - but no ship-to phone. It
doesn't make sense.



Sue



-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Friday, January 28, 2005 10:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order - where
is it?



I think this is located in the customer contact table.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Susan Iverson [mailto:siverson@...]
Sent: Friday, January 28, 2005 1:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order - where is
it?



Sales would like to have the BILL-TO PHONE NUMBER added to their Crystal
SALES ORDERS. I looked at the tables and all I can find is the Bill-To Fax
and Bill-To Email address fields - but no Bill-To PHONE. Am I blind or has
Epicor hidden it in another obscure table to torment us?



Sue

Vantage 6.1 on Progress database Win2000 server.



[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/.
<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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views
of the sender and not necessarily the views of the company. The email and
any files transmitted with it are confidential to the intended recipient at
the e-mail address to which it has been addressed. It may not be disclosed
or used by any other than that addressee, nor may it be copied in any way.
If received in error, please delete and notify the sender via e-mail or
sales@... quoting the name of the sender. Messages sent via this
medium may be subject to delays, non-delivery and unauthorized alteration.
This e-mail has been prepared using information believed by the author to be
reliable and accurate. Unless expressly stated otherwise, this e-mail does
not form part of a legally binding contract or agreement between recipient
and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or
attachments. It is, therefore, your responsibility to scan attachments (if
any).



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/.
<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




_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
No, I will never use epicor custom programming they have enough problems
supporting the core product I cannot even imagine the problems with custom
code. I think this is just linking several tables. Good luck.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Pablo Garza [mailto:pgarza@...]
Sent: Friday, January 28, 2005 6:00 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order - where
is it?



We went through the same exercise with Epicor. The phone number is
non-exsitent. After a few exchanges, they finally agreed to build in a
custom code so that we could have our customer phone numbers appear on sales
orders. You may have to do the same.


Vantage 5.2 Win 2000 Server

Pablo Garza
VP Operations
Dix Metals, Inc
<mailto:pgarza@...> pgarza@...


-----Original Message-----
From: Susan Iverson [mailto:siverson@...]
Sent: Friday, January 28, 2005 10:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order - where is
it?


Sales would like to have the BILL-TO PHONE NUMBER added to their Crystal
SALES ORDERS. I looked at the tables and all I can find is the Bill-To Fax
and Bill-To Email address fields - but no Bill-To PHONE. Am I blind or has
Epicor hidden it in another obscure table to torment us?



Sue

Vantage 6.1 on Progress database Win2000 server.



[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
To all,
Here is how we got around a similar problem. When we did year end
inventory, we wanted the Unit of Measure on the inventory tag.
Instead of going to Custom Programming, we created an Access database
with one table, and two fields: part number, and Inventory Unit of
Measure. We then linked to this file with Crystal. The only downside
is, that the data in the access table only refreshes when we run the
export. But for year end, it didn't matter much because we updated it
just prior to printing the tags. You may be able to automate the
export to a daily basis. The workstations used to print tags also had
to be configured just a little bit. We had to add another SYSTEM DSN
in the ODBC administrator for the access database.

Hope this helps!

Andrew

Vantage 5.1

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
> No, I will never use epicor custom programming they have enough
problems
> supporting the core product I cannot even imagine the problems with
custom
> code. I think this is just linking several tables. Good luck.
>
> Frank Zeigafuse
> Innovative Office Products
> General Manager
> Direct Phone: 610-559-6369
> Email: fzeigafuse@L...
>
>
>
> -----Original Message-----
> From: Pablo Garza [mailto:pgarza@d...]
> Sent: Friday, January 28, 2005 6:00 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Adding Cust. BILL-TO Phone No. in Sales
Order - where
> is it?
>
>
>
> We went through the same exercise with Epicor. The phone number is
> non-exsitent. After a few exchanges, they finally agreed to build
in a
> custom code so that we could have our customer phone numbers appear
on sales
> orders. You may have to do the same.
>
>
> Vantage 5.2 Win 2000 Server
>
> Pablo Garza
> VP Operations
> Dix Metals, Inc
> <mailto:pgarza@d...> pgarza@d...
>
>
> -----Original Message-----
> From: Susan Iverson [mailto:siverson@j...]
> Sent: Friday, January 28, 2005 10:02 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order -
where is
> it?
>
>
> Sales would like to have the BILL-TO PHONE NUMBER added to their
Crystal
> SALES ORDERS. I looked at the tables and all I can find is the
Bill-To Fax
> and Bill-To Email address fields - but no Bill-To PHONE. Am I blind
or has
> Epicor hidden it in another obscure table to torment us?
>
>
>
> Sue
>
> Vantage 6.1 on Progress database Win2000 server.
>
>
>
> [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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
> <http://groups.yahoo.com/group/vantage/>
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [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
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
> <www.LCDarms.com> -- Ergonomic mounting solutions for monitors
and keyboards
>
> This e-mail is from Innovative Office Products, Inc. but expresses
the views of the sender and not necessarily the views of the company.
The email and any files transmitted with it are confidential to the
intended recipient at the e-mail address to which it has been
addressed. It may not be disclosed or used by any other than that
addressee, nor may it be copied in any way. If received in error,
please delete and notify the sender via e-mail or sales@L... quoting
the name of the sender. Messages sent via this medium may be subject
to delays, non-delivery and unauthorized alteration. This e-mail has
been prepared using information believed by the author to be reliable
and accurate. Unless expressly stated otherwise, this e-mail does not
form part of a legally binding contract or agreement between
recipient and Innovative Office Products, Inc.
>
> Warning: Although Innovative Office Products, Inc. has taken
reasonable precautions to ensure no viruses are present in this
email, we cannot accept responsibility for any loss or damage arising
from the use of this email or attachments. It is, therefore, your
responsibility to scan attachments (if any).
Sue,
Create a Subreport in the SOForm. Link by using the order number. In the
subreport link via ODBC to the Vantage Progress DB. Bring in the OrderHed
table and then link that to the Customer table via CustNum. In the Customer
Table you will find the BTPhonNum.
This is a bit of a pain if you have not used ODBC to improve the "Vantage
Standard Exported DBFs" that most all of us have complaints about missing
data, but once you have done this a time or two, it's really no big thing.
Good Luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: Susan Iverson [mailto:siverson@...]
Sent: Friday, January 28, 2005 1:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order - where
is it?



Sales would like to have the BILL-TO PHONE NUMBER added to their Crystal
SALES ORDERS. I looked at the tables and all I can find is the Bill-To
Fax and Bill-To Email address fields - but no Bill-To PHONE. Am I blind
or has Epicor hidden it in another obscure table to torment us?



Sue

Vantage 6.1 on Progress database Win2000 server.



[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
Yahoo! Groups Links
Aaron,

I did what you said, and I have a small subreport now with the field
I want in it. I linked them, yet now when I try to print I get
error 599. I think thats the error for "Error connecting to SQL
Server"

Have you run across this? Did I do it incorrectly?

Thanks,
Ben

--- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...> wrote:
> Sue,
> Create a Subreport in the SOForm. Link by using the order
number. In the
> subreport link via ODBC to the Vantage Progress DB. Bring in the
OrderHed
> table and then link that to the Customer table via CustNum. In
the Customer
> Table you will find the BTPhonNum.
> This is a bit of a pain if you have not used ODBC to improve
the "Vantage
> Standard Exported DBFs" that most all of us have complaints about
missing
> data, but once you have done this a time or two, it's really no
big thing.
> Good Luck,
> Aaron Hoyt
> Vantage Plastics
>
> -----Original Message-----
> From: Susan Iverson [mailto:siverson@j...]
> Sent: Friday, January 28, 2005 1:02 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order -
where
> is it?
>
>
>
> Sales would like to have the BILL-TO PHONE NUMBER added to their
Crystal
> SALES ORDERS. I looked at the tables and all I can find is the
Bill-To
> Fax and Bill-To Email address fields - but no Bill-To PHONE. Am I
blind
> or has Epicor hidden it in another obscure table to torment us?
>
>
>
> Sue
>
> Vantage 6.1 on Progress database Win2000 server.
>
>
>
> [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
> Yahoo! Groups Links
Ben,
You will need to set up ODBC on the workstation (I am guessing you have that
done by the sounds), and you will need to remove the leading ; from the last
three or four lines in the .mfg file the users use to launch Vantage (and
restart Vantage). They contain the ODBC login information.
If I am not mistaken the Error 599 will clear up then.
Good luck,
Aaron Hoyt
Vantage Plastics
A couple of added note for speed.
Filter the subreport by your company id hard coded, and make sure you are
linking the Company field in the links via ODBC. Oh, and if there is any
reason you might not want the subreport to show in some situations, add
those into the suppress if section for the subreport. Also, make sure you
have plenty of ODBC servers setup in your Progress Explorer.

-----Original Message-----
From: bbelzer42 [mailto:bbelzer@...]
Sent: Monday, January 31, 2005 4:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Adding Cust. BILL-TO Phone No. in Sales Order -
where is it?




Aaron,

I did what you said, and I have a small subreport now with the field
I want in it. I linked them, yet now when I try to print I get
error 599. I think thats the error for "Error connecting to SQL
Server"

Have you run across this? Did I do it incorrectly?

Thanks,
Ben

--- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...> wrote:
> Sue,
> Create a Subreport in the SOForm. Link by using the order
number. In the
> subreport link via ODBC to the Vantage Progress DB. Bring in the
OrderHed
> table and then link that to the Customer table via CustNum. In
the Customer
> Table you will find the BTPhonNum.
> This is a bit of a pain if you have not used ODBC to improve
the "Vantage
> Standard Exported DBFs" that most all of us have complaints about
missing
> data, but once you have done this a time or two, it's really no
big thing.
> Good Luck,
> Aaron Hoyt
> Vantage Plastics
>
> -----Original Message-----
> From: Susan Iverson [mailto:siverson@j...]
> Sent: Friday, January 28, 2005 1:02 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Adding Cust. BILL-TO Phone No. in Sales Order -
where
> is it?
>
>
>
> Sales would like to have the BILL-TO PHONE NUMBER added to their
Crystal
> SALES ORDERS. I looked at the tables and all I can find is the
Bill-To
> Fax and Bill-To Email address fields - but no Bill-To PHONE. Am I
blind
> or has Epicor hidden it in another obscure table to torment us?
>
>
>
> Sue
>
> Vantage 6.1 on Progress database Win2000 server.
>
>
>
> [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
> Yahoo! Groups Links





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
Yahoo! Groups Links