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