Report builder returning incorrect data Vantage 4.0

I've noticed that before and found a way to link correctly- I think
it had to do with the index function. If you would like an example
let me know and I'll try to dig up that report.

Lonnie

--- In vantage@y..., Carol Engen <cengen@w...> wrote:
> Unless your Customer always has the same Rep, you can not link
Customer to
> Rep and get accurate information. If the Customer is set up for
Jane and
> the Sales Order says Steve, you will get Jane.
>
> Reports can be written to extract reps from the bucket (27~19~99)
as shown
> in the OrderHead.SalesRepList. But only if your SalesRep ID's are
always a
> specified digit length. (for us it's 2 only because we converted
that
> way...I would recommend from 4 to the full allowed length of that
field if
> starting anew to allow room for growth)
>
> -----Original Message-----
> From: Terry Williams [SMTP:tlw@c...]
> Sent: Tuesday, July 31, 2001 4:17 PM
> To: vantage@y...
> Subject: RE: [Vantage] Report builder returning
incorrect
> data Vantage 4.0
>
> If you're linking the salesrep table to the customer and
sales rep
> has not
> been specified in the customer maintenance record you will
get
> unknown. You
> 'll need to go after the sales reps on the order header.
>
> Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty
St.
> Ext.
> Meadville, PA 16335 p.8143336331 x236 f.8143372548
> tlw@c...
> <mailto:tlw@c...> www.chipsco.com <http://www.chipsco.com/>
>
> -----Original Message-----
> From: sales@l... [mailto:sales@l...]
> Sent: Tuesday, July 31, 2001 3:54 PM
> To: vantage@y...
> Subject: [Vantage] Report builder returning incorrect data
Vantage
> 4.0
>
> I've built a report linking Order Detail to Order Header to
Customer
> (inner joins)to SalesRep (left outer join). For some reason
the
> report
> returns the UNKNOWN value for the SalesRep info on some
records (not
> all) even though all SalesRep data has been entered on the
Vantage
> Order screens at the order entry level. Anybody know why this
is
> happening?
> Thanks in advance for your help. Steve Shapiro
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
>
<http://rd.yahoo.com/M=210948.1523299.3088501.1269402/D=egroupweb/S=1
7050071
>
> 83:HM/A=733441/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-3936-
1039-2?mpt=
> 996609267>
>
>
> 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
>
> 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]
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> 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
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
I've built a report linking Order Detail to Order Header to Customer
(inner joins)to SalesRep (left outer join). For some reason the report
returns the UNKNOWN value for the SalesRep info on some records (not
all) even though all SalesRep data has been entered on the Vantage
Order screens at the order entry level. Anybody know why this is
happening?
Thanks in advance for your help. Steve Shapiro
If you're linking the salesrep table to the customer and sales rep has not
been specified in the customer maintenance record you will get unknown. You
'll need to go after the sales reps on the order header.

Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335 p.8143336331 x236 f.8143372548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: sales@... [mailto:sales@...]
Sent: Tuesday, July 31, 2001 3:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report builder returning incorrect data Vantage 4.0

I've built a report linking Order Detail to Order Header to Customer
(inner joins)to SalesRep (left outer join). For some reason the report
returns the UNKNOWN value for the SalesRep info on some records (not
all) even though all SalesRep data has been entered on the Vantage
Order screens at the order entry level. Anybody know why this is
happening?
Thanks in advance for your help. Steve Shapiro





Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=210948.1523299.3088501.1269402/D=egroupweb/S=17050071
83:HM/A=733441/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=
996609267>


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

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]
Unless your Customer always has the same Rep, you can not link Customer to
Rep and get accurate information. If the Customer is set up for Jane and
the Sales Order says Steve, you will get Jane.

Reports can be written to extract reps from the bucket (27~19~99) as shown
in the OrderHead.SalesRepList. But only if your SalesRep ID's are always a
specified digit length. (for us it's 2 only because we converted that
way...I would recommend from 4 to the full allowed length of that field if
starting anew to allow room for growth)

-----Original Message-----
From: Terry Williams [SMTP:tlw@...]
Sent: Tuesday, July 31, 2001 4:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report builder returning incorrect
data Vantage 4.0

If you're linking the salesrep table to the customer and sales rep
has not
been specified in the customer maintenance record you will get
unknown. You
'll need to go after the sales reps on the order header.

Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St.
Ext.
Meadville, PA 16335 p.8143336331 x236 f.8143372548
tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: sales@... [mailto:sales@...]
Sent: Tuesday, July 31, 2001 3:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report builder returning incorrect data Vantage
4.0

I've built a report linking Order Detail to Order Header to Customer
(inner joins)to SalesRep (left outer join). For some reason the
report
returns the UNKNOWN value for the SalesRep info on some records (not
all) even though all SalesRep data has been entered on the Vantage
Order screens at the order entry level. Anybody know why this is
happening?
Thanks in advance for your help. Steve Shapiro





Yahoo! Groups Sponsor


<http://rd.yahoo.com/M=210948.1523299.3088501.1269402/D=egroupweb/S=17050071

83:HM/A=733441/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=
996609267>


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

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]


------------------------ Yahoo! Groups Sponsor

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

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/