Quote Form Data Defintion

Yahoo Archive
1
Just another problem with no common denominator.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Friday, May 01, 2009 12:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Quote Form Data Defintion








You guys may be hitting on something...Ill look around to see if ive
done that in more than one RDD. Perhaps there is some other variable
that we haven't hit on yet that causes it to work in some instances but
not others..

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg. <http://www.dsmfg.com/> com/>

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Lynn
Sent: Friday, May 01, 2009 10:09 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Quote Form Data Defintion

I've had inconsistent results.

A couple of times , it would allow me to link a 3rd table to a 2nd
(newly-added) table. But most of the time, I get the same results as
Ross. The 3rd table returns no data.

I'm on 8.03.404.

Lynn

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> , "Rob
Bucek" <rbucek@...> wrote:
>
> I thought I did something like that from the RDD BOLForm (made a
> duplicate of and then..), I went BOLDtl to ShipHead, ShipHead to
> ShipDtl, and ShipDtl to Part. Works great....
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: 715-284-5376 ext 311
>
> FAX: 715-284-4084
>
> <http://www.dsmfg. <http://www.dsmfg.com/> com/ <http://www.dsmfg.
<http://www.dsmfg.com/> com/> >
>
> (Click the logo to view our site)
>
>
>
> ________________________________
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Ross Hughes
> Sent: Friday, May 01, 2009 9:47 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Quote Form Data Defintion
>
>
>
>
>
> I just ran in to that as well.
>
> What I concluded is that RDD will not allow a dual-chain manual
> relationship. It consistently will not provide data on second table in
> the
> manually-created relationship.
>
> I can always get data in the first table but not the second.
>
> A cheating (and inefficient) workaround (if the table is small) is to
> hang
> the table off the Company table (or another if you can reduce the
> dataset)
> and only relate the Company field (or others that assist in the
> reduction of
> data). Of course, this gives you the 10-pound XML file that you have
to
> filter off in Crystal.
>
> An option...not the best but I have used it in a pinch and it works.
>
> Maybe I am doing something wrong. Epicor support couldn't not get the
> data
> to return in the second table.
>
> Is anyone else getting data in the second added table?
>
> Ross
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Lynn
> Sent: Friday, May 01, 2009 9:08 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Quote Form Data Defintion
>
> According to the Vantage 8 data dictionary, QuoteCnt.ConNum and
> CustCnt.ConNum are system-generated numbers. If you relate those 2
> tables
> via the ConNum field, you would get unexpected results.
>
> For example, QuoteCnt.ConNum = 1 will be Jane Smith.
> But CustCnt.ConNum = 1 will be John Doe.
> They won't be the same person.
>
> I'm not sure what you are trying to show on your CR quote form.
>
> But, if you are simply trying to list all possible customer contacts
on
> your
> quote form, perhaps you really want to relate the QuoteHed to CustCnt
> using
> the fields: Company, CustNum, (& possibly ShipToNum).
>
> Lynn
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Charlie Wilson" <foamdesigncsw@> wrote:
> >
> > I'm working on adding a couple fields to the quote form data def. I
> had to
> > add a couple tables to get to the data I want. I added QuoteCnt and
> CustCnt.
> > I built a relationship from Quotehed to QuoteCnt using the QuoteNum
> field
> > and then one from QuoteCnt to CustCnt table using Custnum and
ConNum.
> I'm
> > getting data in the QuoteCnt table but the CustCnt table come up
> blank. I
> > have confirmed that there is relative data that should be there but
it
> isn't
> > showing up. Can anyone give me any advice as to what is going on
here?
> >
> >
> >
> > ~Charlie
> >
> >
> >
> >
> >
> > [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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
> <http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/> >
> (2) To search through old msg's goto:
> http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
<http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
> <http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
<http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages> >
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo
<http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
> <http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo
<http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo> > ! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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





[Non-text portions of this message have been removed]
2
I'm working on adding a couple fields to the quote form data def. I had to
add a couple tables to get to the data I want. I added QuoteCnt and CustCnt.
I built a relationship from Quotehed to QuoteCnt using the QuoteNum field
and then one from QuoteCnt to CustCnt table using Custnum and ConNum. I'm
getting data in the QuoteCnt table but the CustCnt table come up blank. I
have confirmed that there is relative data that should be there but it isn't
showing up. Can anyone give me any advice as to what is going on here?



~Charlie





[Non-text portions of this message have been removed]
3
According to the Vantage 8 data dictionary, QuoteCnt.ConNum and CustCnt.ConNum are system-generated numbers. If you relate those 2 tables via the ConNum field, you would get unexpected results.

For example, QuoteCnt.ConNum = 1 will be Jane Smith.
But CustCnt.ConNum = 1 will be John Doe.
They won't be the same person.

I'm not sure what you are trying to show on your CR quote form.

But, if you are simply trying to list all possible customer contacts on your quote form, perhaps you really want to relate the QuoteHed to CustCnt using the fields: Company, CustNum, (& possibly ShipToNum).

Lynn




--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...> wrote:
>
> I'm working on adding a couple fields to the quote form data def. I had to
> add a couple tables to get to the data I want. I added QuoteCnt and CustCnt.
> I built a relationship from Quotehed to QuoteCnt using the QuoteNum field
> and then one from QuoteCnt to CustCnt table using Custnum and ConNum. I'm
> getting data in the QuoteCnt table but the CustCnt table come up blank. I
> have confirmed that there is relative data that should be there but it isn't
> showing up. Can anyone give me any advice as to what is going on here?
>
>
>
> ~Charlie
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Well I thought if I used Custnum as well I would pull the correct contact is
this not correct?



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lynn
Sent: Friday, May 01, 2009 10:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Quote Form Data Defintion








According to the Vantage 8 data dictionary, QuoteCnt.ConNum and
CustCnt.ConNum are system-generated numbers. If you relate those 2 tables
via the ConNum field, you would get unexpected results.

For example, QuoteCnt.ConNum = 1 will be Jane Smith.
But CustCnt.ConNum = 1 will be John Doe.
They won't be the same person.

I'm not sure what you are trying to show on your CR quote form.

But, if you are simply trying to list all possible customer contacts on your
quote form, perhaps you really want to relate the QuoteHed to CustCnt using
the fields: Company, CustNum, (& possibly ShipToNum).

Lynn

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...> wrote:
>
> I'm working on adding a couple fields to the quote form data def. I had to
> add a couple tables to get to the data I want. I added QuoteCnt and
CustCnt.
> I built a relationship from Quotehed to QuoteCnt using the QuoteNum field
> and then one from QuoteCnt to CustCnt table using Custnum and ConNum. I'm
> getting data in the QuoteCnt table but the CustCnt table come up blank. I
> have confirmed that there is relative data that should be there but it
isn't
> showing up. Can anyone give me any advice as to what is going on here?
>
>
>
> ~Charlie
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
5
I just ran in to that as well.

What I concluded is that RDD will not allow a dual-chain manual
relationship. It consistently will not provide data on second table in the
manually-created relationship.

I can always get data in the first table but not the second.

A cheating (and inefficient) workaround (if the table is small) is to hang
the table off the Company table (or another if you can reduce the dataset)
and only relate the Company field (or others that assist in the reduction of
data). Of course, this gives you the 10-pound XML file that you have to
filter off in Crystal.

An option...not the best but I have used it in a pinch and it works.

Maybe I am doing something wrong. Epicor support couldn't not get the data
to return in the second table.

Is anyone else getting data in the second added table?

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lynn
Sent: Friday, May 01, 2009 9:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Quote Form Data Defintion

According to the Vantage 8 data dictionary, QuoteCnt.ConNum and
CustCnt.ConNum are system-generated numbers. If you relate those 2 tables
via the ConNum field, you would get unexpected results.

For example, QuoteCnt.ConNum = 1 will be Jane Smith.
But CustCnt.ConNum = 1 will be John Doe.
They won't be the same person.

I'm not sure what you are trying to show on your CR quote form.

But, if you are simply trying to list all possible customer contacts on your
quote form, perhaps you really want to relate the QuoteHed to CustCnt using
the fields: Company, CustNum, (& possibly ShipToNum).

Lynn




--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...> wrote:
>
> I'm working on adding a couple fields to the quote form data def. I had to
> add a couple tables to get to the data I want. I added QuoteCnt and
CustCnt.
> I built a relationship from Quotehed to QuoteCnt using the QuoteNum field
> and then one from QuoteCnt to CustCnt table using Custnum and ConNum. I'm
> getting data in the QuoteCnt table but the CustCnt table come up blank. I
> have confirmed that there is relative data that should be there but it
isn't
> showing up. Can anyone give me any advice as to what is going on here?
>
>
>
> ~Charlie
>
>
>
>
>
> [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/linksYahoo! Groups Links
6
Excellent thank you that works for me!



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Friday, May 01, 2009 10:47 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Quote Form Data Defintion








I just ran in to that as well.

What I concluded is that RDD will not allow a dual-chain manual
relationship. It consistently will not provide data on second table in the
manually-created relationship.

I can always get data in the first table but not the second.

A cheating (and inefficient) workaround (if the table is small) is to hang
the table off the Company table (or another if you can reduce the dataset)
and only relate the Company field (or others that assist in the reduction of
data). Of course, this gives you the 10-pound XML file that you have to
filter off in Crystal.

An option...not the best but I have used it in a pinch and it works.

Maybe I am doing something wrong. Epicor support couldn't not get the data
to return in the second table.

Is anyone else getting data in the second added table?

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Lynn
Sent: Friday, May 01, 2009 9:08 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Quote Form Data Defintion

According to the Vantage 8 data dictionary, QuoteCnt.ConNum and
CustCnt.ConNum are system-generated numbers. If you relate those 2 tables
via the ConNum field, you would get unexpected results.

For example, QuoteCnt.ConNum = 1 will be Jane Smith.
But CustCnt.ConNum = 1 will be John Doe.
They won't be the same person.

I'm not sure what you are trying to show on your CR quote form.

But, if you are simply trying to list all possible customer contacts on your
quote form, perhaps you really want to relate the QuoteHed to CustCnt using
the fields: Company, CustNum, (& possibly ShipToNum).

Lynn

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...> wrote:
>
> I'm working on adding a couple fields to the quote form data def. I had to
> add a couple tables to get to the data I want. I added QuoteCnt and
CustCnt.
> I built a relationship from Quotehed to QuoteCnt using the QuoteNum field
> and then one from QuoteCnt to CustCnt table using Custnum and ConNum. I'm
> getting data in the QuoteCnt table but the CustCnt table come up blank. I
> have confirmed that there is relative data that should be there but it
isn't
> showing up. Can anyone give me any advice as to what is going on here?
>
>
>
> ~Charlie
>
>
>
>
>
> [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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
7
I thought I did something like that from the RDD BOLForm (made a
duplicate of and then..), I went BOLDtl to ShipHead, ShipHead to
ShipDtl, and ShipDtl to Part. Works great....



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ross Hughes
Sent: Friday, May 01, 2009 9:47 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Quote Form Data Defintion





I just ran in to that as well.

What I concluded is that RDD will not allow a dual-chain manual
relationship. It consistently will not provide data on second table in
the
manually-created relationship.

I can always get data in the first table but not the second.

A cheating (and inefficient) workaround (if the table is small) is to
hang
the table off the Company table (or another if you can reduce the
dataset)
and only relate the Company field (or others that assist in the
reduction of
data). Of course, this gives you the 10-pound XML file that you have to
filter off in Crystal.

An option...not the best but I have used it in a pinch and it works.

Maybe I am doing something wrong. Epicor support couldn't not get the
data
to return in the second table.

Is anyone else getting data in the second added table?

Ross

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Lynn
Sent: Friday, May 01, 2009 9:08 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Quote Form Data Defintion

According to the Vantage 8 data dictionary, QuoteCnt.ConNum and
CustCnt.ConNum are system-generated numbers. If you relate those 2
tables
via the ConNum field, you would get unexpected results.

For example, QuoteCnt.ConNum = 1 will be Jane Smith.
But CustCnt.ConNum = 1 will be John Doe.
They won't be the same person.

I'm not sure what you are trying to show on your CR quote form.

But, if you are simply trying to list all possible customer contacts on
your
quote form, perhaps you really want to relate the QuoteHed to CustCnt
using
the fields: Company, CustNum, (& possibly ShipToNum).

Lynn

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Charlie Wilson" <foamdesigncsw@...> wrote:
>
> I'm working on adding a couple fields to the quote form data def. I
had to
> add a couple tables to get to the data I want. I added QuoteCnt and
CustCnt.
> I built a relationship from Quotehed to QuoteCnt using the QuoteNum
field
> and then one from QuoteCnt to CustCnt table using Custnum and ConNum.
I'm
> getting data in the QuoteCnt table but the CustCnt table come up
blank. I
> have confirmed that there is relative data that should be there but it
isn't
> showing up. Can anyone give me any advice as to what is going on here?
>
>
>
> ~Charlie
>
>
>
>
>
> [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/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links





[Non-text portions of this message have been removed]
8
I must be doing something wrong then. No sure what. I followed the
instructions provided.

Maybe there are varied limitations of different RDD's.

I have recently tried it on MtlTag and QuoteForm with no success. Version
803.407a.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Friday, May 01, 2009 10:03 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Quote Form Data Defintion

I thought I did something like that from the RDD BOLForm (made a
duplicate of and then..), I went BOLDtl to ShipHead, ShipHead to
ShipDtl, and ShipDtl to Part. Works great....



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ross Hughes
Sent: Friday, May 01, 2009 9:47 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Quote Form Data Defintion





I just ran in to that as well.

What I concluded is that RDD will not allow a dual-chain manual
relationship. It consistently will not provide data on second table in
the
manually-created relationship.

I can always get data in the first table but not the second.

A cheating (and inefficient) workaround (if the table is small) is to
hang
the table off the Company table (or another if you can reduce the
dataset)
and only relate the Company field (or others that assist in the
reduction of
data). Of course, this gives you the 10-pound XML file that you have to
filter off in Crystal.

An option...not the best but I have used it in a pinch and it works.

Maybe I am doing something wrong. Epicor support couldn't not get the
data
to return in the second table.

Is anyone else getting data in the second added table?

Ross

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Lynn
Sent: Friday, May 01, 2009 9:08 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Quote Form Data Defintion

According to the Vantage 8 data dictionary, QuoteCnt.ConNum and
CustCnt.ConNum are system-generated numbers. If you relate those 2
tables
via the ConNum field, you would get unexpected results.

For example, QuoteCnt.ConNum = 1 will be Jane Smith.
But CustCnt.ConNum = 1 will be John Doe.
They won't be the same person.

I'm not sure what you are trying to show on your CR quote form.

But, if you are simply trying to list all possible customer contacts on
your
quote form, perhaps you really want to relate the QuoteHed to CustCnt
using
the fields: Company, CustNum, (& possibly ShipToNum).

Lynn

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Charlie Wilson" <foamdesigncsw@...> wrote:
>
> I'm working on adding a couple fields to the quote form data def. I
had to
> add a couple tables to get to the data I want. I added QuoteCnt and
CustCnt.
> I built a relationship from Quotehed to QuoteCnt using the QuoteNum
field
> and then one from QuoteCnt to CustCnt table using Custnum and ConNum.
I'm
> getting data in the QuoteCnt table but the CustCnt table come up
blank. I
> have confirmed that there is relative data that should be there but it
isn't
> showing up. Can anyone give me any advice as to what is going on here?
>
>
>
> ~Charlie
>
>
>
>
>
> [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/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links





[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/linksYahoo! Groups Links
9
I've had inconsistent results.

A couple of times , it would allow me to link a 3rd table to a 2nd (newly-added) table. But most of the time, I get the same results as Ross. The 3rd table returns no data.

I'm on 8.03.404.

Lynn


--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> I thought I did something like that from the RDD BOLForm (made a
> duplicate of and then..), I went BOLDtl to ShipHead, ShipHead to
> ShipDtl, and ShipDtl to Part. Works great....
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: 715-284-5376 ext 311
>
> FAX: 715-284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site)
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Ross Hughes
> Sent: Friday, May 01, 2009 9:47 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Quote Form Data Defintion
>
>
>
>
>
> I just ran in to that as well.
>
> What I concluded is that RDD will not allow a dual-chain manual
> relationship. It consistently will not provide data on second table in
> the
> manually-created relationship.
>
> I can always get data in the first table but not the second.
>
> A cheating (and inefficient) workaround (if the table is small) is to
> hang
> the table off the Company table (or another if you can reduce the
> dataset)
> and only relate the Company field (or others that assist in the
> reduction of
> data). Of course, this gives you the 10-pound XML file that you have to
> filter off in Crystal.
>
> An option...not the best but I have used it in a pinch and it works.
>
> Maybe I am doing something wrong. Epicor support couldn't not get the
> data
> to return in the second table.
>
> Is anyone else getting data in the second added table?
>
> Ross
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Lynn
> Sent: Friday, May 01, 2009 9:08 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Quote Form Data Defintion
>
> According to the Vantage 8 data dictionary, QuoteCnt.ConNum and
> CustCnt.ConNum are system-generated numbers. If you relate those 2
> tables
> via the ConNum field, you would get unexpected results.
>
> For example, QuoteCnt.ConNum = 1 will be Jane Smith.
> But CustCnt.ConNum = 1 will be John Doe.
> They won't be the same person.
>
> I'm not sure what you are trying to show on your CR quote form.
>
> But, if you are simply trying to list all possible customer contacts on
> your
> quote form, perhaps you really want to relate the QuoteHed to CustCnt
> using
> the fields: Company, CustNum, (& possibly ShipToNum).
>
> Lynn
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Charlie Wilson" <foamdesigncsw@> wrote:
> >
> > I'm working on adding a couple fields to the quote form data def. I
> had to
> > add a couple tables to get to the data I want. I added QuoteCnt and
> CustCnt.
> > I built a relationship from Quotehed to QuoteCnt using the QuoteNum
> field
> > and then one from QuoteCnt to CustCnt table using Custnum and ConNum.
> I'm
> > getting data in the QuoteCnt table but the CustCnt table come up
> blank. I
> > have confirmed that there is relative data that should be there but it
> isn't
> > showing up. Can anyone give me any advice as to what is going on here?
> >
> >
> >
> > ~Charlie
> >
> >
> >
> >
> >
> > [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/linksYahoo
> <http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
10
The work around did the trick for me and I'm not ending up with really large
xml files so it will work.



The email address on the form for the contact shows the email for the
company not the email for the contact that is displayed so I switched it to
show the email for the contact instead of the company. SO simple yet so
hard.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lynn
Sent: Friday, May 01, 2009 11:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Quote Form Data Defintion








I've had inconsistent results.

A couple of times , it would allow me to link a 3rd table to a 2nd
(newly-added) table. But most of the time, I get the same results as Ross.
The 3rd table returns no data.

I'm on 8.03.404.

Lynn

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Rob
Bucek" <rbucek@...> wrote:
>
> I thought I did something like that from the RDD BOLForm (made a
> duplicate of and then..), I went BOLDtl to ShipHead, ShipHead to
> ShipDtl, and ShipDtl to Part. Works great....
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: 715-284-5376 ext 311
>
> FAX: 715-284-4084
>
> <http://www.dsmfg. <http://www.dsmfg.com/> com/>
>
> (Click the logo to view our site)
>
>
>
> ________________________________
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
> Of Ross Hughes
> Sent: Friday, May 01, 2009 9:47 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Re: Quote Form Data Defintion
>
>
>
>
>
> I just ran in to that as well.
>
> What I concluded is that RDD will not allow a dual-chain manual
> relationship. It consistently will not provide data on second table in
> the
> manually-created relationship.
>
> I can always get data in the first table but not the second.
>
> A cheating (and inefficient) workaround (if the table is small) is to
> hang
> the table off the Company table (or another if you can reduce the
> dataset)
> and only relate the Company field (or others that assist in the
> reduction of
> data). Of course, this gives you the 10-pound XML file that you have to
> filter off in Crystal.
>
> An option...not the best but I have used it in a pinch and it works.
>
> Maybe I am doing something wrong. Epicor support couldn't not get the
> data
> to return in the second table.
>
> Is anyone else getting data in the second added table?
>
> Ross
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Lynn
> Sent: Friday, May 01, 2009 9:08 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Quote Form Data Defintion
>
> According to the Vantage 8 data dictionary, QuoteCnt.ConNum and
> CustCnt.ConNum are system-generated numbers. If you relate those 2
> tables
> via the ConNum field, you would get unexpected results.
>
> For example, QuoteCnt.ConNum = 1 will be Jane Smith.
> But CustCnt.ConNum = 1 will be John Doe.
> They won't be the same person.
>
> I'm not sure what you are trying to show on your CR quote form.
>
> But, if you are simply trying to list all possible customer contacts on
> your
> quote form, perhaps you really want to relate the QuoteHed to CustCnt
> using
> the fields: Company, CustNum, (& possibly ShipToNum).
>
> Lynn
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ,
> "Charlie Wilson" <foamdesigncsw@> wrote:
> >
> > I'm working on adding a couple fields to the quote form data def. I
> had to
> > add a couple tables to get to the data I want. I added QuoteCnt and
> CustCnt.
> > I built a relationship from Quotehed to QuoteCnt using the QuoteNum
> field
> > and then one from QuoteCnt to CustCnt table using Custnum and ConNum.
> I'm
> > getting data in the QuoteCnt table but the CustCnt table come up
> blank. I
> > have confirmed that there is relative data that should be there but it
> isn't
> > showing up. Can anyone give me any advice as to what is going on here?
> >
> >
> >
> > ~Charlie
> >
> >
> >
> >
> >
> > [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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
> <http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> <http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo
> <http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo> ! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
11
We are running 407 but Ive had that in place since 400...



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ross Hughes
Sent: Friday, May 01, 2009 10:08 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Quote Form Data Defintion





I must be doing something wrong then. No sure what. I followed the
instructions provided.

Maybe there are varied limitations of different RDD's.

I have recently tried it on MtlTag and QuoteForm with no success.
Version
803.407a.

Ross

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Friday, May 01, 2009 10:03 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Quote Form Data Defintion

I thought I did something like that from the RDD BOLForm (made a
duplicate of and then..), I went BOLDtl to ShipHead, ShipHead to
ShipDtl, and ShipDtl to Part. Works great....

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> >

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ross Hughes
Sent: Friday, May 01, 2009 9:47 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Quote Form Data Defintion

I just ran in to that as well.

What I concluded is that RDD will not allow a dual-chain manual
relationship. It consistently will not provide data on second table in
the
manually-created relationship.

I can always get data in the first table but not the second.

A cheating (and inefficient) workaround (if the table is small) is to
hang
the table off the Company table (or another if you can reduce the
dataset)
and only relate the Company field (or others that assist in the
reduction of
data). Of course, this gives you the 10-pound XML file that you have to
filter off in Crystal.

An option...not the best but I have used it in a pinch and it works.

Maybe I am doing something wrong. Epicor support couldn't not get the
data
to return in the second table.

Is anyone else getting data in the second added table?

Ross

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Lynn
Sent: Friday, May 01, 2009 9:08 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Quote Form Data Defintion

According to the Vantage 8 data dictionary, QuoteCnt.ConNum and
CustCnt.ConNum are system-generated numbers. If you relate those 2
tables
via the ConNum field, you would get unexpected results.

For example, QuoteCnt.ConNum = 1 will be Jane Smith.
But CustCnt.ConNum = 1 will be John Doe.
They won't be the same person.

I'm not sure what you are trying to show on your CR quote form.

But, if you are simply trying to list all possible customer contacts on
your
quote form, perhaps you really want to relate the QuoteHed to CustCnt
using
the fields: Company, CustNum, (& possibly ShipToNum).

Lynn

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Charlie Wilson" <foamdesigncsw@...> wrote:
>
> I'm working on adding a couple fields to the quote form data def. I
had to
> add a couple tables to get to the data I want. I added QuoteCnt and
CustCnt.
> I built a relationship from Quotehed to QuoteCnt using the QuoteNum
field
> and then one from QuoteCnt to CustCnt table using Custnum and ConNum.
I'm
> getting data in the QuoteCnt table but the CustCnt table come up
blank. I
> have confirmed that there is relative data that should be there but it
isn't
> showing up. Can anyone give me any advice as to what is going on here?
>
>
>
> ~Charlie
>
>
>
>
>
> [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
<http://groups.yahoo.com/group/vantage/messages>
<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/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo>
<http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> > ! Groups Links

[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/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links





[Non-text portions of this message have been removed]
12
You guys may be hitting on something...Ill look around to see if ive
done that in more than one RDD. Perhaps there is some other variable
that we haven't hit on yet that causes it to work in some instances but
not others..



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Lynn
Sent: Friday, May 01, 2009 10:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Quote Form Data Defintion





I've had inconsistent results.

A couple of times , it would allow me to link a 3rd table to a 2nd
(newly-added) table. But most of the time, I get the same results as
Ross. The 3rd table returns no data.

I'm on 8.03.404.

Lynn

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Rob
Bucek" <rbucek@...> wrote:
>
> I thought I did something like that from the RDD BOLForm (made a
> duplicate of and then..), I went BOLDtl to ShipHead, ShipHead to
> ShipDtl, and ShipDtl to Part. Works great....
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: 715-284-5376 ext 311
>
> FAX: 715-284-4084
>
> <http://www.dsmfg.com/ <http://www.dsmfg.com/> >
>
> (Click the logo to view our site)
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Ross Hughes
> Sent: Friday, May 01, 2009 9:47 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Quote Form Data Defintion
>
>
>
>
>
> I just ran in to that as well.
>
> What I concluded is that RDD will not allow a dual-chain manual
> relationship. It consistently will not provide data on second table in
> the
> manually-created relationship.
>
> I can always get data in the first table but not the second.
>
> A cheating (and inefficient) workaround (if the table is small) is to
> hang
> the table off the Company table (or another if you can reduce the
> dataset)
> and only relate the Company field (or others that assist in the
> reduction of
> data). Of course, this gives you the 10-pound XML file that you have
to
> filter off in Crystal.
>
> An option...not the best but I have used it in a pinch and it works.
>
> Maybe I am doing something wrong. Epicor support couldn't not get the
> data
> to return in the second table.
>
> Is anyone else getting data in the second added table?
>
> Ross
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Lynn
> Sent: Friday, May 01, 2009 9:08 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Quote Form Data Defintion
>
> According to the Vantage 8 data dictionary, QuoteCnt.ConNum and
> CustCnt.ConNum are system-generated numbers. If you relate those 2
> tables
> via the ConNum field, you would get unexpected results.
>
> For example, QuoteCnt.ConNum = 1 will be Jane Smith.
> But CustCnt.ConNum = 1 will be John Doe.
> They won't be the same person.
>
> I'm not sure what you are trying to show on your CR quote form.
>
> But, if you are simply trying to list all possible customer contacts
on
> your
> quote form, perhaps you really want to relate the QuoteHed to CustCnt
> using
> the fields: Company, CustNum, (& possibly ShipToNum).
>
> Lynn
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Charlie Wilson" <foamdesigncsw@> wrote:
> >
> > I'm working on adding a couple fields to the quote form data def. I
> had to
> > add a couple tables to get to the data I want. I added QuoteCnt and
> CustCnt.
> > I built a relationship from Quotehed to QuoteCnt using the QuoteNum
> field
> > and then one from QuoteCnt to CustCnt table using Custnum and
ConNum.
> I'm
> > getting data in the QuoteCnt table but the CustCnt table come up
> blank. I
> > have confirmed that there is relative data that should be there but
it
> isn't
> > showing up. Can anyone give me any advice as to what is going on
here?
> >
> >
> >
> > ~Charlie
> >
> >
> >
> >
> >
> > [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
<http://groups.yahoo.com/group/vantage/messages>
> <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/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo>
> <http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> > ! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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