Sales Rep Booked Order Report

Yahoo Archive
1
I would parse the info into an Access Table then report on that. I
haven't done it from the Order Side, but I do have some reports from
the Invoice Tables where I have done that. The reports were a breeze
to write once I transformed the data into a more useful table.

Let me know if you need some hints going this direction.

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...> wrote:
> You will have to break up the sales rep field. It consists of 5
repids
> separated by ~ that is Chr(126). If you use Crystal I might be
able to give
> you to formula to break out the IDs. I found it much more
difficult to
> break out the rates and amounts, but I believe that can be done
also. Maybe
> another on this list can help you with those if needed.
> If you would like the formula, let me know.
> Aaron Hoyt
> Vantage Plastics
>
> -----Original Message-----
> From: midwestsigncompany [mailto:tdavis@s...]
> Sent: Monday, December 27, 2004 4:07 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Sales Rep Booked Order Report
>
>
>
>
> Has anyone developed a booked orders report by Sale Rep by month?
> We need a report to show us how much each sales rep has book for
> each month. This helps monitor their performance and determine sales
> management commissions. The trick for us if that our sales rep are
> all part of one big territory. I am having difficulty pulling the
> sales rep information from the OrderHed table. Any ideas would be
> great!
>
>
>
>
>
>
> 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
2
Has anyone developed a booked orders report by Sale Rep by month?
We need a report to show us how much each sales rep has book for
each month. This helps monitor their performance and determine sales
management commissions. The trick for us if that our sales rep are
all part of one big territory. I am having difficulty pulling the
sales rep information from the OrderHed table. Any ideas would be
great!
3
You will have to break up the sales rep field. It consists of 5 repids
separated by ~ that is Chr(126). If you use Crystal I might be able to give
you to formula to break out the IDs. I found it much more difficult to
break out the rates and amounts, but I believe that can be done also. Maybe
another on this list can help you with those if needed.
If you would like the formula, let me know.
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: midwestsigncompany [mailto:tdavis@...]
Sent: Monday, December 27, 2004 4:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Rep Booked Order Report




Has anyone developed a booked orders report by Sale Rep by month?
We need a report to show us how much each sales rep has book for
each month. This helps monitor their performance and determine sales
management commissions. The trick for us if that our sales rep are
all part of one big territory. I am having difficulty pulling the
sales rep information from the OrderHed table. Any ideas would be
great!






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