I could swear that there is a document out there discussing removing the tildes
for reporting in Report Builder.
You might need to talk to one of the Vantage "old-timers" in Minneapolis.
____________________Reply Separator____________________
Subject: [Vantage] Re: RB - Split Commissions & Sales Rep List
Author: <vantage@yahoogroups.com>
Date: 8/21/2001 10:23 AM
This problem with the tildes is known by Epicor. I worked with tech
support for a while on this problem. I was eventually told that it would
be "corrected in a future release". Take that as you will. Are you on
version 5? We are on 4 and I gave up trying to separate the reps in the
SalesRepList field. All of our reps have a four character code, but there
was no pattern to the tildes. The number of tildes between the two reps in
the list would vary from one to four.
Gary Grenier
IT Manager
Bell Manufacturing Co.
ggrenier@...
From: Todd Caughey <caugheyt@...>
Subject: RB - Split Commissions & Sales Rep List
..questions about the SalesRepList field on
the Order Header:
1. When I print it the reps are seperated by the tilde character (~). I
finally figured out how to parse out the rep codes but had to create a
string field for CHR(126) rather than use '~' in the ENTRY function. Just
curious why this character can't be used in a direct string (inside quotes
that is). Also the data dictionary says the list is seperated by commas
but
this does not seem to be the case...
-Todd Caughey
Harvey Vogel Mfg. Co.
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/
for reporting in Report Builder.
You might need to talk to one of the Vantage "old-timers" in Minneapolis.
____________________Reply Separator____________________
Subject: [Vantage] Re: RB - Split Commissions & Sales Rep List
Author: <vantage@yahoogroups.com>
Date: 8/21/2001 10:23 AM
This problem with the tildes is known by Epicor. I worked with tech
support for a while on this problem. I was eventually told that it would
be "corrected in a future release". Take that as you will. Are you on
version 5? We are on 4 and I gave up trying to separate the reps in the
SalesRepList field. All of our reps have a four character code, but there
was no pattern to the tildes. The number of tildes between the two reps in
the list would vary from one to four.
Gary Grenier
IT Manager
Bell Manufacturing Co.
ggrenier@...
From: Todd Caughey <caugheyt@...>
Subject: RB - Split Commissions & Sales Rep List
..questions about the SalesRepList field on
the Order Header:
1. When I print it the reps are seperated by the tilde character (~). I
finally figured out how to parse out the rep codes but had to create a
string field for CHR(126) rather than use '~' in the ENTRY function. Just
curious why this character can't be used in a direct string (inside quotes
that is). Also the data dictionary says the list is seperated by commas
but
this does not seem to be the case...
-Todd Caughey
Harvey Vogel Mfg. Co.
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/