[6.1] Customer Required Specs on POs to Our Vendors

Yahoo Archive
1
If the verbage is the same for all PN's of a customer you wouldn't
want to maintain it on a PN by PN basis anyway. Bite the bullet and
jump into ODBC. I'm using it a ton and haven't had issues since
moving to the SQL92 version.

Brian

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...> wrote:
> Might work too but probably not here. A quick RB check shows our
Part Descs now vary from 1 to 271 char in length. PartDesc is a X
(1000) memo field so would choke CR and we can't trim it to 255
(withou changing the long ones now in use). As it is we have a
number of descriptions over 150 characters which does not leave much
to work with. If I could truncate the descriptions to 255 I would
probably prefix the specs section with a "marker" string (like [S])
and search for that as a variable starting point but this opens a can
or worms everywhere else needing to have the description chopped off
where we don't want the specs to show (invoices, etc...).
> -Todd C.
>
> -----Original Message-----
> From: Shirley Graver [mailto:shirleyg@R...]
> Sent: Friday, September 02, 2005 11:21 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: [6.1] Customer Required Specs on POs to
Our Vendors
>
>
> Here's another Idea, determine a max size you use for your part
description
> (say 35 characters) The as Lydia suggested, put your specs in the
extended
> part description. Then created a calculated field using MID(
string, 35,
> 255). This would pull out the next 220 characters of description
into its
> own field that you can place anywhere on your form.
>
> Shirley
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Lydia Coffman
> Sent: Friday, September 02, 2005 11:27 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Re: [6.1] Customer Required Specs on POs to
Our
> Vendors
>
> Just a thought here -- what about the extended description of the
part?
> Are you already using that for something else? Seems like you
could open
> that description up on the PO (to 5 lines or whatever)and truncate
it if
> there is nothing in there.
>
> Might be worth a try.
> Lydia
>
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Friday, September 02, 2005 8:19 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: [6.1] Customer Required Specs on POs to Our
> Vendors
>
>
> Todd,
>
> Couldn't you enter the verbage in the Customer VB form field and
add
> a subreport with JobProd, OrderHed, and Customer tables? The
> subreport would be linked by the Job # in JobProd to the Job# in
> PORel.dbf.
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...>
wrote:
> > They are the same for every part for that customer (part to
> customer is 99% one-for-one relation here as I expect it is for you
> too). Preferable would be to trigger block of specs on PO to our
> vendors for any job related to that customer - for all parts. But
if
> there is a way to code the specs on the parts we can live with that
> as being easier to remember to do than job notes on each job (as we
> are doing now and often forgetting). I was really hoping there was
> some table somewhere that I have been missing that carrys at least
> part specs through to the PO or worst case I can grab with ODBC.
> >
> > Another thought......maybe I will create DBFs with PO print
preview
> and have a distributed report for each customer that has the specs
> bolted in as an .bmp image file the user can maintain with Windows-
> Paint. We only have 5-6 such customers. This would suffice until
we
> eventually get to 8.0.
> >
> > Thanks,
> > -Todd
> >
> > -----Original Message-----
> >
>
>
> 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
>
> * 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/> .
>
> _____
>
>
> Tracking #: EDCDCAE343CEA74A83404545F4CC8BDE18E4692E
>
>
> [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
>
>
>
>
> SPONSORED LINKS
> Membership <http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Membership+database+software&w2
=Database+mortgage+software&w3=Pda+database+software&w4=Database+manag
ement+software&w5=Database+marketing+software&w6=Online+database+softw
are&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw> database software
Database <http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Membership+database+software&w2=D
atabase+mortgage+software&w3=Pda+database+software&w4=Database+managem
ent+software&w5=Database+marketing+software&w6=Online+database+softwar
e&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg> mortgage software Pda
<http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Membership+database+software&w2=Databa
se+mortgage+software&w3=Pda+database+software&w4=Database+management+s
oftware&w5=Database+marketing+software&w6=Online+database+software&c=6
&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw> database software
> Database <http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Membership+database+software&w2
=Database+mortgage+software&w3=Pda+database+software&w4=Database+manag
ement+software&w5=Database+marketing+software&w6=Online+database+softw
are&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg> management software
Database <http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Membership+database+software&w2=
Database+mortgage+software&w3=Pda+database+software&w4=Database+manage
ment+software&w5=Database+marketing+software&w6=Online+database+softwa
re&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ> marketing software
Online <http://groups.yahoo.com/gads?
t=ms&k=Online+database+software&w1=Membership+database+software&w2=Dat
abase+mortgage+software&w3=Pda+database+software&w4=Database+managemen
t+software&w5=Database+marketing+software&w6=Online+database+software&
c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw> 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]
2
An opportunity to share your unique and creative solutions....

We are increasingly seeing requirements from customers that we include on our POs to vendors (material or subcontract) various specification statements. Mostly for anything military related. These vary by customer with some required for every part for the customer. Our jobs are each exclusively for one customer but POs to vendors are linked only to the job and not the SO so customer is not available to test for. This leaves the inclusion of the specs in job notes up to manual process by falible humans.

Things like:
MIL-STD 1684
PA-2632 II(d)
PA-2632 III
MIL-I-45208 Rev A.AM.1

What we need is as automated a way as possible to get each specific customer's specs requirements (specification number alone is OK as long as we attach the verbage for it) on to the face of the PO. Is there any facility in Vantage to handle this? Or anyone out there who has faced the same need and found an acceptable solution? We could perhaps do it by on the part if necessary if that will work so that every PO related to that part gets the correct specs statements - or gets them into the job's memo that that prints on the PO. All with as little human intervention on each PO as possible. Oh, and I completely reject a monster formula field in the Crystal PO report that tests for each customer and adds text. The system users need to maintain this via Vantage not me via CR developer.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.







[Non-text portions of this message have been removed]
3
We're right in there with you. We had a third party create a "subtier
shipping request" form, but you still have to know what you are doing and
for whom. Let us know if you do get this automated.

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, September 01, 2005 3:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Customer Required Specs on POs to Our Vendors


An opportunity to share your unique and creative solutions....

We are increasingly seeing requirements from customers that we include on
our POs to vendors (material or subcontract) various specification
statements. Mostly for anything military related. These vary by customer
with some required for every part for the customer. Our jobs are each
exclusively for one customer but POs to vendors are linked only to the job
and not the SO so customer is not available to test for. This leaves the
inclusion of the specs in job notes up to manual process by falible humans.

Things like:
MIL-STD 1684
PA-2632 II(d)
PA-2632 III
MIL-I-45208 Rev A.AM.1

What we need is as automated a way as possible to get each specific
customer's specs requirements (specification number alone is OK as long as
we attach the verbage for it) on to the face of the PO. Is there any
facility in Vantage to handle this? Or anyone out there who has faced the
same need and found an acceptable solution? We could perhaps do it by on
the part if necessary if that will work so that every PO related to that
part gets the correct specs statements - or gets them into the job's memo
that that prints on the PO. All with as little human intervention on each
PO as possible. Oh, and I completely reject a monster formula field in the
Crystal PO report that tests for each customer and adds text. The system
users need to maintain this via Vantage not me via CR developer.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.







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




SPONSORED LINKS
Membership database software Database mortgage software Pda database
software
Database management software Database marketing software Online
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]
4
It would be nice if vantage had the capability to add a specification
just like an ABOM Material item to the Partmaster, but with 0 qty per
usage so it didn't drive requirements in the system. You could maintain
revisions on the spec as well.



_____

From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, September 01, 2005 2:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Customer Required Specs on POs to Our Vendors



An opportunity to share your unique and creative solutions....

We are increasingly seeing requirements from customers that we include
on our POs to vendors (material or subcontract) various specification
statements. Mostly for anything military related. These vary by
customer with some required for every part for the customer. Our jobs
are each exclusively for one customer but POs to vendors are linked
only to the job and not the SO so customer is not available to test for.
This leaves the inclusion of the specs in job notes up to manual process
by falible humans.

Things like:
MIL-STD 1684
PA-2632 II(d)
PA-2632 III
MIL-I-45208 Rev A.AM.1

What we need is as automated a way as possible to get each specific
customer's specs requirements (specification number alone is OK as long
as we attach the verbage for it) on to the face of the PO. Is there any
facility in Vantage to handle this? Or anyone out there who has faced
the same need and found an acceptable solution? We could perhaps do it
by on the part if necessary if that will work so that every PO related
to that part gets the correct specs statements - or gets them into the
job's memo that that prints on the PO. All with as little human
intervention on each PO as possible. Oh, and I completely reject a
monster formula field in the Crystal PO report that tests for each
customer and adds text. The system users need to maintain this via
Vantage not me via CR developer.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.







[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

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>



_____

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



_____


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.clearswift.com
**********************************************************************




[Non-text portions of this message have been removed]
5
We have faced something similar recently, but I don't know if this is applicable to your situation.

We have a vender from which we purchase some critical parts. Every PO that goes to this customer must have verbiage on the PO stating to the effect "A singed certification of compliance must accompany each part stating the part meets the specifications required". We accomplished this by adding the statement in the "Comments" for the vendor in Vantage. We then made a very minor change to the POform in CR (adding the pub.vendor table thru ODBC) and then adding the "vendor.comment" field in the lower page header section of the POform. It is only displayed when there is something in the comments for the vendor. Works well for us.

Hope this helps.

Dale Norris
IT Manager
Bullen Ultrasonics Inc.

>>> cmuhlestein@... 9/1/2005 5:15 PM >>>

It would be nice if vantage had the capability to add a specification
just like an ABOM Material item to the Partmaster, but with 0 qty per
usage so it didn't drive requirements in the system. You could maintain
revisions on the spec as well.



_____

From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, September 01, 2005 2:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Customer Required Specs on POs to Our Vendors



An opportunity to share your unique and creative solutions....

We are increasingly seeing requirements from customers that we include
on our POs to vendors (material or subcontract) various specification
statements. Mostly for anything military related. These vary by
customer with some required for every part for the customer. Our jobs
are each exclusively for one customer but POs to vendors are linked
only to the job and not the SO so customer is not available to test for.
This leaves the inclusion of the specs in job notes up to manual process
by falible humans.

Things like:
MIL-STD 1684
PA-2632 II(d)
PA-2632 III
MIL-I-45208 Rev A.AM.1

What we need is as automated a way as possible to get each specific
customer's specs requirements (specification number alone is OK as long
as we attach the verbage for it) on to the face of the PO. Is there any
facility in Vantage to handle this? Or anyone out there who has faced
the same need and found an acceptable solution? We could perhaps do it
by on the part if necessary if that will work so that every PO related
to that part gets the correct specs statements - or gets them into the
job's memo that that prints on the PO. All with as little human
intervention on each PO as possible. Oh, and I completely reject a
monster formula field in the Crystal PO report that tests for each
customer and adds text. The system users need to maintain this via
Vantage not me via CR developer.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.







[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

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>

Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>



_____

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



_____


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.clearswift.com
**********************************************************************




[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












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

Are the specs the same for every part of a specific customer, or do
they vary by PN?

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...> wrote:
> An opportunity to share your unique and creative solutions....
>
> We are increasingly seeing requirements from customers that we
include on our POs to vendors (material or subcontract) various
specification statements. Mostly for anything military related.
These vary by customer with some required for every part for the
customer. Our jobs are each exclusively for one customer but POs to
vendors are linked only to the job and not the SO so customer is not
available to test for. This leaves the inclusion of the specs in job
notes up to manual process by falible humans.
>
> Things like:
> MIL-STD 1684
> PA-2632 II(d)
> PA-2632 III
> MIL-I-45208 Rev A.AM.1
>
> What we need is as automated a way as possible to get each specific
customer's specs requirements (specification number alone is OK as
long as we attach the verbage for it) on to the face of the PO. Is
there any facility in Vantage to handle this? Or anyone out there
who has faced the same need and found an acceptable solution? We
could perhaps do it by on the part if necessary if that will work so
that every PO related to that part gets the correct specs statements -
or gets them into the job's memo that that prints on the PO. All
with as little human intervention on each PO as possible. Oh, and I
completely reject a monster formula field in the Crystal PO report
that tests for each customer and adds text. The system users need to
maintain this via Vantage not me via CR developer.
>
> Thanks,
> Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
7
They are the same for every part for that customer (part to customer is 99% one-for-one relation here as I expect it is for you too). Preferable would be to trigger block of specs on PO to our vendors for any job related to that customer - for all parts. But if there is a way to code the specs on the parts we can live with that as being easier to remember to do than job notes on each job (as we are doing now and often forgetting). I was really hoping there was some table somewhere that I have been missing that carrys at least part specs through to the PO or worst case I can grab with ODBC.

Another thought......maybe I will create DBFs with PO print preview and have a distributed report for each customer that has the specs bolted in as an .bmp image file the user can maintain with Windows-Paint. We only have 5-6 such customers. This would suffice until we eventually get to 8.0.

Thanks,
-Todd

-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Friday, September 02, 2005 8:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [6.1] Customer Required Specs on POs to Our Vendors


Todd,

Are the specs the same for every part of a specific customer, or do
they vary by PN?

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...> wrote:
> An opportunity to share your unique and creative solutions....
>
> We are increasingly seeing requirements from customers that we
include on our POs to vendors (material or subcontract) various
specification statements. Mostly for anything military related.
These vary by customer with some required for every part for the
customer. Our jobs are each exclusively for one customer but POs to
vendors are linked only to the job and not the SO so customer is not
available to test for. This leaves the inclusion of the specs in job
notes up to manual process by falible humans.
>
> Things like:
> MIL-STD 1684
> PA-2632 II(d)
> PA-2632 III
> MIL-I-45208 Rev A.AM.1
>
> What we need is as automated a way as possible to get each specific
customer's specs requirements (specification number alone is OK as
long as we attach the verbage for it) on to the face of the PO. Is
there any facility in Vantage to handle this? Or anyone out there
who has faced the same need and found an acceptable solution? We
could perhaps do it by on the part if necessary if that will work so
that every PO related to that part gets the correct specs statements -
or gets them into the job's memo that that prints on the PO. All
with as little human intervention on each PO as possible. Oh, and I
completely reject a monster formula field in the Crystal PO report
that tests for each customer and adds text. The system users need to
maintain this via Vantage not me via CR developer.
>
> Thanks,
> Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
>
>
>
>
>
> [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



* 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]
8
Todd,

Couldn't you enter the verbage in the Customer VB form field and add
a subreport with JobProd, OrderHed, and Customer tables? The
subreport would be linked by the Job # in JobProd to the Job# in
PORel.dbf.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...> wrote:
> They are the same for every part for that customer (part to
customer is 99% one-for-one relation here as I expect it is for you
too). Preferable would be to trigger block of specs on PO to our
vendors for any job related to that customer - for all parts. But if
there is a way to code the specs on the parts we can live with that
as being easier to remember to do than job notes on each job (as we
are doing now and often forgetting). I was really hoping there was
some table somewhere that I have been missing that carrys at least
part specs through to the PO or worst case I can grab with ODBC.
>
> Another thought......maybe I will create DBFs with PO print preview
and have a distributed report for each customer that has the specs
bolted in as an .bmp image file the user can maintain with Windows-
Paint. We only have 5-6 such customers. This would suffice until we
eventually get to 8.0.
>
> Thanks,
> -Todd
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Friday, September 02, 2005 8:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: [6.1] Customer Required Specs on POs to Our
Vendors
>
>
> Todd,
>
> Are the specs the same for every part of a specific customer, or do
> they vary by PN?
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...>
wrote:
> > An opportunity to share your unique and creative solutions....
> >
> > We are increasingly seeing requirements from customers that we
> include on our POs to vendors (material or subcontract) various
> specification statements. Mostly for anything military related.
> These vary by customer with some required for every part for the
> customer. Our jobs are each exclusively for one customer but POs
to
> vendors are linked only to the job and not the SO so customer is
not
> available to test for. This leaves the inclusion of the specs in
job
> notes up to manual process by falible humans.
> >
> > Things like:
> > MIL-STD 1684
> > PA-2632 II(d)
> > PA-2632 III
> > MIL-I-45208 Rev A.AM.1
> >
> > What we need is as automated a way as possible to get each
specific
> customer's specs requirements (specification number alone is OK as
> long as we attach the verbage for it) on to the face of the PO. Is
> there any facility in Vantage to handle this? Or anyone out there
> who has faced the same need and found an acceptable solution? We
> could perhaps do it by on the part if necessary if that will work
so
> that every PO related to that part gets the correct specs
statements -
> or gets them into the job's memo that that prints on the PO. All
> with as little human intervention on each PO as possible. Oh, and
I
> completely reject a monster formula field in the Crystal PO report
> that tests for each customer and adds text. The system users need
to
> maintain this via Vantage not me via CR developer.
> >
> > Thanks,
> > Todd Caughey
> > Harvey Vogel Mfg. Co.
> >
> >
> >
> >
> >
> >
> >
> > [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
>
>
>
> * 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]
9
That would work too. The question would be.."to ODBC or to not ODBC". To date no users here have ODBC. Distributed reports though are common. But the writing is on the wall and ODBC will be everywhere soon enough to replace RB so I might go ahead and bite the bullet with this project.

Thanks,
-Todd

-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Friday, September 02, 2005 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [6.1] Customer Required Specs on POs to Our Vendors


Todd,

Couldn't you enter the verbage in the Customer VB form field and add
a subreport with JobProd, OrderHed, and Customer tables? The
subreport would be linked by the Job # in JobProd to the Job# in
PORel.dbf.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...> wrote:
> They are the same for every part for that customer (part to
customer is 99% one-for-one relation here as I expect it is for you
too). Preferable would be to trigger block of specs on PO to our
vendors for any job related to that customer - for all parts. But if
there is a way to code the specs on the parts we can live with that
as being easier to remember to do than job notes on each job (as we
are doing now and often forgetting). I was really hoping there was
some table somewhere that I have been missing that carrys at least
part specs through to the PO or worst case I can grab with ODBC.
>
> Another thought......maybe I will create DBFs with PO print preview
and have a distributed report for each customer that has the specs
bolted in as an .bmp image file the user can maintain with Windows-
Paint. We only have 5-6 such customers. This would suffice until we
eventually get to 8.0.
>
> Thanks,
> -Todd
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Friday, September 02, 2005 8:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: [6.1] Customer Required Specs on POs to Our
Vendors
>
>
> Todd,
>
> Are the specs the same for every part of a specific customer, or do
> they vary by PN?
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...>
wrote:
> > An opportunity to share your unique and creative solutions....
> >
> > We are increasingly seeing requirements from customers that we
> include on our POs to vendors (material or subcontract) various
> specification statements. Mostly for anything military related.
> These vary by customer with some required for every part for the
> customer. Our jobs are each exclusively for one customer but POs
to
> vendors are linked only to the job and not the SO so customer is
not
> available to test for. This leaves the inclusion of the specs in
job
> notes up to manual process by falible humans.
> >
> > Things like:
> > MIL-STD 1684
> > PA-2632 II(d)
> > PA-2632 III
> > MIL-I-45208 Rev A.AM.1
> >
> > What we need is as automated a way as possible to get each
specific
> customer's specs requirements (specification number alone is OK as
> long as we attach the verbage for it) on to the face of the PO. Is
> there any facility in Vantage to handle this? Or anyone out there
> who has faced the same need and found an acceptable solution? We
> could perhaps do it by on the part if necessary if that will work
so
> that every PO related to that part gets the correct specs
statements -
> or gets them into the job's memo that that prints on the PO. All
> with as little human intervention on each PO as possible. Oh, and
I
> completely reject a monster formula field in the Crystal PO report
> that tests for each customer and adds text. The system users need
to
> maintain this via Vantage not me via CR developer.
> >
> > Thanks,
> > Todd Caughey
> > Harvey Vogel Mfg. Co.
> >
> >
> >
> >
> >
> >
> >
> > [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
>
>
>
> * 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




SPONSORED LINKS
Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg> mortgage software Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw> database software
Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ> marketing software Online <http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw> 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]
10
Might work too but probably not here. A quick RB check shows our Part Descs now vary from 1 to 271 char in length. PartDesc is a X(1000) memo field so would choke CR and we can't trim it to 255 (withou changing the long ones now in use). As it is we have a number of descriptions over 150 characters which does not leave much to work with. If I could truncate the descriptions to 255 I would probably prefix the specs section with a "marker" string (like [S]) and search for that as a variable starting point but this opens a can or worms everywhere else needing to have the description chopped off where we don't want the specs to show (invoices, etc...).
-Todd C.

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Friday, September 02, 2005 11:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: [6.1] Customer Required Specs on POs to Our Vendors


Here's another Idea, determine a max size you use for your part description
(say 35 characters) The as Lydia suggested, put your specs in the extended
part description. Then created a calculated field using MID( string, 35,
255). This would pull out the next 220 characters of description into its
own field that you can place anywhere on your form.

Shirley

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lydia Coffman
Sent: Friday, September 02, 2005 11:27 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: [6.1] Customer Required Specs on POs to Our
Vendors

Just a thought here -- what about the extended description of the part?
Are you already using that for something else? Seems like you could open
that description up on the PO (to 5 lines or whatever)and truncate it if
there is nothing in there.

Might be worth a try.
Lydia


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Friday, September 02, 2005 8:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [6.1] Customer Required Specs on POs to Our
Vendors


Todd,

Couldn't you enter the verbage in the Customer VB form field and add
a subreport with JobProd, OrderHed, and Customer tables? The
subreport would be linked by the Job # in JobProd to the Job# in
PORel.dbf.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...> wrote:
> They are the same for every part for that customer (part to
customer is 99% one-for-one relation here as I expect it is for you
too). Preferable would be to trigger block of specs on PO to our
vendors for any job related to that customer - for all parts. But if
there is a way to code the specs on the parts we can live with that
as being easier to remember to do than job notes on each job (as we
are doing now and often forgetting). I was really hoping there was
some table somewhere that I have been missing that carrys at least
part specs through to the PO or worst case I can grab with ODBC.
>
> Another thought......maybe I will create DBFs with PO print preview
and have a distributed report for each customer that has the specs
bolted in as an .bmp image file the user can maintain with Windows-
Paint. We only have 5-6 such customers. This would suffice until we
eventually get to 8.0.
>
> Thanks,
> -Todd
>
> -----Original Message-----
>


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

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

_____


Tracking #: EDCDCAE343CEA74A83404545F4CC8BDE18E4692E


[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




SPONSORED LINKS
Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg> mortgage software Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw> database software
Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ> marketing software Online <http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw> 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]