Sales commissions on Orders

Yahoo Archive
1
Yeah, I found it.. and that tilde separator is really problematic.
There's no way I'm going to be able to use a BAQ query and BAQ Report
Designer to create a report to query for individual sales reps since
there's no way to do a string search within a field in the BAQ.

So, I guess I'll have to do a query straight to the database through
ODBC I'm guessing.

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:
>
> In OrderHed there is a SalesRepList field that denotes the Sales
Rep Code.
> One thing to be aware of is that multiple Sales Reps can be entered
in Order
> Header \ Sales Person and they are delimited by a ~ (tilde) in that
field.
>
> Scott Litzau, MCP
> Olympus Flag & Banner
> Information Systems Manager
> scott.litzau@...
> P: 414-365-9732
> F: 414-355-1931
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Patrick Parker
> Sent: Tuesday, March 25, 2008 3:12 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Sales commissions on Orders
>
> I need to create a new report for commissions on orders that
haven't
> been shipped and invoiced yet.
>
> I tried a BAQ but can't get the fields to specify the sales reps by
to
> come up. So, went to the Data Dictionary and found in OrderHed and
> OrderDtl fields for RepRate, RepSplit, SRCommableAmt (which hold
the
> commissionable amount on the order), and SRCommAmt (which holds the
> commission amount).
>
> However, I can't for the life of me find any column which
identifies
> the SalesRepCode for the sales rep tied to the order.
>
> The Quotes have their own table named QSalesRp that lists the reps
> attached to the quote, but there's nothing as far as I can see for
> Orders to do the same thing.
>
> Anyone know where this is stored or have a query/report they can
share
> with me please.
>
>
> ------------------------------------
>
> 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
>
2
I need to create a new report for commissions on orders that haven't
been shipped and invoiced yet.

I tried a BAQ but can't get the fields to specify the sales reps by to
come up. So, went to the Data Dictionary and found in OrderHed and
OrderDtl fields for RepRate, RepSplit, SRCommableAmt (which hold the
commissionable amount on the order), and SRCommAmt (which holds the
commission amount).

However, I can't for the life of me find any column which identifies
the SalesRepCode for the sales rep tied to the order.

The Quotes have their own table named QSalesRp that lists the reps
attached to the quote, but there's nothing as far as I can see for
Orders to do the same thing.

Anyone know where this is stored or have a query/report they can share
with me please.
3
In the Orderhed table SalesRepList maybe what you are looking for.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Patrick Parker
Sent: Tuesday, March 25, 2008 4:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales commissions on Orders

I need to create a new report for commissions on orders that haven't
been shipped and invoiced yet.

I tried a BAQ but can't get the fields to specify the sales reps by to
come up. So, went to the Data Dictionary and found in OrderHed and
OrderDtl fields for RepRate, RepSplit, SRCommableAmt (which hold the
commissionable amount on the order), and SRCommAmt (which holds the
commission amount).

However, I can't for the life of me find any column which identifies
the SalesRepCode for the sales rep tied to the order.

The Quotes have their own table named QSalesRp that lists the reps
attached to the quote, but there's nothing as far as I can see for
Orders to do the same thing.

Anyone know where this is stored or have a query/report they can share
with me please.



[Non-text portions of this message have been removed]
4
OrderHed has a field SalesRepList which holds all the values,
delimited if there are multiple.

--- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@...>
wrote:
>
> I need to create a new report for commissions on orders that
haven't
> been shipped and invoiced yet.
>
> I tried a BAQ but can't get the fields to specify the sales reps
by to
> come up. So, went to the Data Dictionary and found in OrderHed
and
> OrderDtl fields for RepRate, RepSplit, SRCommableAmt (which hold
the
> commissionable amount on the order), and SRCommAmt (which holds
the
> commission amount).
>
> However, I can't for the life of me find any column which
identifies
> the SalesRepCode for the sales rep tied to the order.
>
> The Quotes have their own table named QSalesRp that lists the reps
> attached to the quote, but there's nothing as far as I can see for
> Orders to do the same thing.
>
> Anyone know where this is stored or have a query/report they can
share
> with me please.
>
5
Oh man.. how could I have missed that. (shaking head)

Thanks.. that appears to be the way they're doing it. Strange
method - rep codes separated by a tilde character.

Thanks!

--- In vantage@yahoogroups.com, "Stan Chmura" <schmura@...> wrote:
>
> In the Orderhed table SalesRepList maybe what you are looking for.
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Patrick Parker
> Sent: Tuesday, March 25, 2008 4:12 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Sales commissions on Orders
>
> I need to create a new report for commissions on orders that
haven't
> been shipped and invoiced yet.
>
> I tried a BAQ but can't get the fields to specify the sales reps by
to
> come up. So, went to the Data Dictionary and found in OrderHed and
> OrderDtl fields for RepRate, RepSplit, SRCommableAmt (which hold
the
> commissionable amount on the order), and SRCommAmt (which holds the
> commission amount).
>
> However, I can't for the life of me find any column which
identifies
> the SalesRepCode for the sales rep tied to the order.
>
> The Quotes have their own table named QSalesRp that lists the reps
> attached to the quote, but there's nothing as far as I can see for
> Orders to do the same thing.
>
> Anyone know where this is stored or have a query/report they can
share
> with me please.
>
>
>
> [Non-text portions of this message have been removed]
>
6
In OrderHed there is a SalesRepList field that denotes the Sales Rep Code.
One thing to be aware of is that multiple Sales Reps can be entered in Order
Header \ Sales Person and they are delimited by a ~ (tilde) in that field.

Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
scott.litzau@...
P: 414-365-9732
F: 414-355-1931


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Patrick Parker
Sent: Tuesday, March 25, 2008 3:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales commissions on Orders

I need to create a new report for commissions on orders that haven't
been shipped and invoiced yet.

I tried a BAQ but can't get the fields to specify the sales reps by to
come up. So, went to the Data Dictionary and found in OrderHed and
OrderDtl fields for RepRate, RepSplit, SRCommableAmt (which hold the
commissionable amount on the order), and SRCommAmt (which holds the
commission amount).

However, I can't for the life of me find any column which identifies
the SalesRepCode for the sales rep tied to the order.

The Quotes have their own table named QSalesRp that lists the reps
attached to the quote, but there's nothing as far as I can see for
Orders to do the same thing.

Anyone know where this is stored or have a query/report they can share
with me please.


------------------------------------

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