Price Breaks

Has anyone seen a problem where a price does not pull in from the price list
in the job material, but does pull in on the PO? Any idea what could cause
this? (5.00.333)
I know it is right in front of me, but I cannot find the table that
Price Breaks are stored in. I found all of the Price List tables but the
Price Break Table/Tables elude me. Can anyone help? I also seem to
remember a discussion where you can find that info from within the entry
screen by some key command or something? Is that true, if so how?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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



Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Price Breaks



I know it is right in front of me, but I cannot find the table that
Price Breaks are stored in. I found all of the Price List tables but the
Price Break Table/Tables elude me. Can anyone help? I also seem to
remember a discussion where you can find that info from within the entry
screen by some key command or something? Is that true, if so how?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* 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]
PLPartBrk only contains Price List Items.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

PLPARTBRK



Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Price Breaks



I know it is right in front of me, but I cannot find the table that
Price Breaks are stored in. I found all of the Price List tables but the
Price Break Table/Tables elude me. Can anyone help? I also seem to
remember a discussion where you can find that info from within the entry
screen by some key command or something? Is that true, if so how?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* 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









This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
Todd,

Data out of the plpartbrk table. There is also a group price break
table. What screen do you see your price breaks in?

Company

Discountpercent

Listcode

Partnum

Quantity

Unitprice















0

1



1

745



0

1



5

692



0

1



10

652



0

1



1

781



0

1



5

725



0

1



10

684



0

1



1

817



0

1



5

760



0

1



10

716





Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks



PLPartBrk only contains Price List Items.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

PLPARTBRK



Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Price Breaks



I know it is right in front of me, but I cannot find the table that
Price Breaks are stored in. I found all of the Price List tables but the
Price Break Table/Tables elude me. Can anyone help? I also seem to
remember a discussion where you can find that info from within the entry
screen by some key command or something? Is that true, if so how?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


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









This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.


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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* 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]
If you're looking for price breaks from vendors it's in VendPBrk.

Liz

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Todd Hofert
Sent: Thursday, September 22, 2005 07:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks


PLPartBrk only contains Price List Items.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

PLPARTBRK



Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Price Breaks



I know it is right in front of me, but I cannot find the table that
Price Breaks are stored in. I found all of the Price List tables but the
Price Break Table/Tables elude me. Can anyone help? I also seem to
remember a discussion where you can find that info from within the entry
screen by some key command or something? Is that true, if so how?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[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




SPONSORED LINKS

Manufacturing software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu> &k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man> &k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf> &k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur> &k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man> &k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac> &k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.


* 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









This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.


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




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Online+database+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Online+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Online+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Online+database+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Online+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw> management software Online <http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Online+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA> database software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]
I am on 6.1.528 and I am going to Order Management/Master File
Maintenance/Price Break.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 10:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

Todd,

Data out of the plpartbrk table. There is also a group price break
table. What screen do you see your price breaks in?

Company

Discountpercent

Listcode

Partnum

Quantity

Unitprice















0

1



1

745



0

1



5

692



0

1



10

652



0

1



1

781



0

1



5

725



0

1



10

684



0

1



1

817



0

1



5

760



0

1



10

716





Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks



PLPartBrk only contains Price List Items.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

PLPARTBRK



Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Price Breaks



I know it is right in front of me, but I cannot find the table that
Price Breaks are stored in. I found all of the Price List tables but the
Price Break Table/Tables elude me. Can anyone help? I also seem to
remember a discussion where you can find that info from within the entry
screen by some key command or something? Is that true, if so how?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


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









This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.


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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* 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









This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
Found a couple of them. Still looking.



Part/Cust Part Group/Cust
Group



PLPartBrk CustGrupPriceLst
PLGrpBrk



Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 11:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks



I am on 6.1.528 and I am going to Order Management/Master File
Maintenance/Price Break.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 10:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

Todd,

Data out of the plpartbrk table. There is also a group price break
table. What screen do you see your price breaks in?

Company

Discountpercent

Listcode

Partnum

Quantity

Unitprice















0

1



1

745



0

1



5

692



0

1



10

652



0

1



1

781



0

1



5

725



0

1



10

684



0

1



1

817



0

1



5

760



0

1



10

716





Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks



PLPartBrk only contains Price List Items.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

PLPARTBRK



Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Price Breaks



I know it is right in front of me, but I cannot find the table that
Price Breaks are stored in. I found all of the Price List tables but the
Price Break Table/Tables elude me. Can anyone help? I also seem to
remember a discussion where you can find that info from within the entry
screen by some key command or something? Is that true, if so how?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


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









This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.


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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


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









This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.


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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* 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]
If anyone wants to know, the Price Break info is stored in the "Oprice"
table. Who'd a thunk it?

Thanks for those of you who tried to figure it out.

Todd Hofert
IT Director
Spartan Graphics, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 11:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

Found a couple of them. Still looking.



Part/Cust Part Group/Cust
Group



PLPartBrk CustGrupPriceLst
PLGrpBrk



Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 11:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks



I am on 6.1.528 and I am going to Order Management/Master File
Maintenance/Price Break.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 10:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

Todd,

Data out of the plpartbrk table. There is also a group price break
table. What screen do you see your price breaks in?

Company

Discountpercent

Listcode

Partnum

Quantity

Unitprice















0

1



1

745



0

1



5

692



0

1



10

652



0

1



1

781



0

1



5

725



0

1



10

684



0

1



1

817



0

1



5

760



0

1



10

716





Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks



PLPartBrk only contains Price List Items.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

PLPARTBRK



Judd

Custom Hoists, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Price Breaks



I know it is right in front of me, but I cannot find the table that
Price Breaks are stored in. I found all of the Price List tables but the
Price Break Table/Tables elude me. Can anyone help? I also seem to
remember a discussion where you can find that info from within the entry
screen by some key command or something? Is that true, if so how?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


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









This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.


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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


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









This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.


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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* 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









This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
OK, Next problem. This table stores the discount percents and the
discount price amounts as 0;0;0;0;0. In other words it looks like you
can have up to five breaks per record and they are all stored in the
same field, separated by semi colons. My typical breaks show as
13.38;0;0;0;0 or 5.9;0;0;0;0 for percentages or for dollar amount breaks
they show as 34.56;0;0;0;0. I want my report to list them as 13.38% and
$34.56 respectively. Can anyone offer advice how to "trim" the extra ;0
characters out of the data? I have tried using trim a number of
different ways but the length of the data varies so trim isn't working.
Or I should say I don't know how to make it work.

TIA
Todd Hofert
IT Director
Spartan Graphics, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 3:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

If anyone wants to know, the Price Break info is stored in the "Oprice"
table. Who'd a thunk it?

Thanks for those of you who tried to figure it out.

Todd Hofert
IT Director
Spartan Graphics, Inc.





This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
Which reporting tool are you using?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Todd Hofert
Sent: Thursday, September 22, 2005 4:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

OK, Next problem. This table stores the discount percents and the
discount price amounts as 0;0;0;0;0. In other words it looks like you
can have up to five breaks per record and they are all stored in the
same field, separated by semi colons. My typical breaks show as
13.38;0;0;0;0 or 5.9;0;0;0;0 for percentages or for dollar amount breaks
they show as 34.56;0;0;0;0. I want my report to list them as 13.38% and
$34.56 respectively. Can anyone offer advice how to "trim" the extra ;0
characters out of the data? I have tried using trim a number of
different ways but the length of the data varies so trim isn't working.
Or I should say I don't know how to make it work.

TIA
Todd Hofert
IT Director
Spartan Graphics, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 3:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

If anyone wants to know, the Price Break info is stored in the "Oprice"
table. Who'd a thunk it?

Thanks for those of you who tried to figure it out.

Todd Hofert
IT Director
Spartan Graphics, Inc.





This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.



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
Crystal ... sorry

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sarah.vareschi@...
Sent: Thursday, September 22, 2005 4:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

Which reporting tool are you using?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 4:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

OK, Next problem. This table stores the discount percents and the
discount price amounts as 0;0;0;0;0. In other words it looks like you
can have up to five breaks per record and they are all stored in the
same field, separated by semi colons. My typical breaks show as
13.38;0;0;0;0 or 5.9;0;0;0;0 for percentages or for dollar amount breaks
they show as 34.56;0;0;0;0. I want my report to list them as 13.38% and
$34.56 respectively. Can anyone offer advice how to "trim" the extra ;0
characters out of the data? I have tried using trim a number of
different ways but the length of the data varies so trim isn't working.
Or I should say I don't know how to make it work.

TIA
Todd Hofert
IT Director
Spartan Graphics, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 3:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

If anyone wants to know, the Price Break info is stored in the "Oprice"
table. Who'd a thunk it?

Thanks for those of you who tried to figure it out.

Todd Hofert
IT Director
Spartan Graphics, Inc.





This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.



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










This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
I'm a MS Access person - I don't use crystal very often... however, if your
number will always be the *1st and ONLY* in the string, than in crystal you
can use the replace function (i.e.
REPLACE(Oprice.DiscountPercents,";0;0;0;0","")) - then convert to a number.

However, this is not a very good solution b/c it won't work for more than
one # in the list... there' probably a better way with crystal - but I don't
use it enough to know it... sorry...

If you were using MS Access, you could write a function that uses an array
to parse out each piece...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Todd Hofert
Sent: Thursday, September 22, 2005 4:56 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

Crystal ... sorry

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sarah.vareschi@...
Sent: Thursday, September 22, 2005 4:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

Which reporting tool are you using?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 4:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

OK, Next problem. This table stores the discount percents and the
discount price amounts as 0;0;0;0;0. In other words it looks like you
can have up to five breaks per record and they are all stored in the
same field, separated by semi colons. My typical breaks show as
13.38;0;0;0;0 or 5.9;0;0;0;0 for percentages or for dollar amount breaks
they show as 34.56;0;0;0;0. I want my report to list them as 13.38% and
$34.56 respectively. Can anyone offer advice how to "trim" the extra ;0
characters out of the data? I have tried using trim a number of
different ways but the length of the data varies so trim isn't working.
Or I should say I don't know how to make it work.

TIA
Todd Hofert
IT Director
Spartan Graphics, Inc.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 3:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks

If anyone wants to know, the Price Break info is stored in the "Oprice"
table. Who'd a thunk it?

Thanks for those of you who tried to figure it out.

Todd Hofert
IT Director
Spartan Graphics, Inc.





This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.



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










This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.



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
Could you use the 'split' function in crystal and then report on the
array.

--- In vantage@yahoogroups.com, sarah.vareschi@n... wrote:
> I'm a MS Access person - I don't use crystal very often... however,
if your
> number will always be the *1st and ONLY* in the string, than in
crystal you
> can use the replace function (i.e.
> REPLACE(Oprice.DiscountPercents,";0;0;0;0","")) - then convert to a
number.
>
> However, this is not a very good solution b/c it won't work for
more than
> one # in the list... there' probably a better way with crystal -
but I don't
> use it enough to know it... sorry...
>
> If you were using MS Access, you could write a function that uses
an array
> to parse out each piece...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Todd Hofert
> Sent: Thursday, September 22, 2005 4:56 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Price Breaks
>
> Crystal ... sorry
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of sarah.vareschi@n...
> Sent: Thursday, September 22, 2005 4:21 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Price Breaks
>
> Which reporting tool are you using?
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Todd Hofert
> Sent: Thursday, September 22, 2005 4:16 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Price Breaks
>
> OK, Next problem. This table stores the discount percents and the
> discount price amounts as 0;0;0;0;0. In other words it looks like
you
> can have up to five breaks per record and they are all stored in the
> same field, separated by semi colons. My typical breaks show as
> 13.38;0;0;0;0 or 5.9;0;0;0;0 for percentages or for dollar amount
breaks
> they show as 34.56;0;0;0;0. I want my report to list them as 13.38%
and
> $34.56 respectively. Can anyone offer advice how to "trim" the
extra ;0
> characters out of the data? I have tried using trim a number of
> different ways but the length of the data varies so trim isn't
working.
> Or I should say I don't know how to make it work.
>
> TIA
> Todd Hofert
> IT Director
> Spartan Graphics, Inc.
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Todd Hofert
> Sent: Thursday, September 22, 2005 3:51 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Price Breaks
>
> If anyone wants to know, the Price Break info is stored in
the "Oprice"
> table. Who'd a thunk it?
>
> Thanks for those of you who tried to figure it out.
>
> Todd Hofert
> IT Director
> Spartan Graphics, Inc.
>
>
>
>
>
> This e-mail and any attachments may contain confidential and
privileged
> information. If you are not the intended recipient, please notify
the
> sender immediately by return e-mail, delete this e-mail and destroy
any
> copies. Any dissemination or use of this information by a person
other
> than the intended recipient is unauthorized and may be illegal.
>
>
>
> 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
>
>
>
>
>
>
>
>
>
>
> This e-mail and any attachments may contain confidential and
privileged
> information. If you are not the intended recipient, please notify
the
> sender immediately by return e-mail, delete this e-mail and destroy
any
> copies. Any dissemination or use of this information by a person
other
> than the intended recipient is unauthorized and may be illegal.
>
>
>
> 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