BAQ Info for Commissions

Yahoo Archive
1
You can find that information at each Sales Order (OrderHed.SalesRepList, .....RepSplit1, RepSplit2.....3, 4, 5,....RepRate1, RepRate2......3, 4, 5) as well as each line -if different from OrderHed info- at OrderDtl.

It's tricky to parse out the SalesRepList but everything else is clear-cut by Rep.

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Monday, May 23, 2011 2:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Info for Commissions



Not sure, but it looks like SalesRep is the table in Vantage...

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of gordon
Sent: Monday, May 23, 2011 1:41 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Info for Commissions

Does anybody know what table I need to access to find the Region, Territory, commission-able Rep and Commission Rate in VISTA using BAQ's?? Thanks Gordon

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
Does anybody know what table I need to access to find the Region, Territory, commission-able Rep and Commission Rate in VISTA using BAQ's?? Thanks Gordon
3
Not sure, but it looks like SalesRep is the table in Vantage...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of gordon
Sent: Monday, May 23, 2011 1:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Info for Commissions



Does anybody know what table I need to access to find the Region, Territory, commission-able Rep and Commission Rate in VISTA using BAQ's?? Thanks Gordon



[Non-text portions of this message have been removed]
4
Each of those things is it's own table. Just link them up in the baq to get
what you need.

On Mon, May 23, 2011 at 3:20 PM, Karen Schoenung <
kschoenung@...> wrote:

>
>
> Not sure, but it looks like SalesRep is the table in Vantage...
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of gordon
> Sent: Monday, May 23, 2011 1:41 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ Info for Commissions
>
>
> Does anybody know what table I need to access to find the Region,
> Territory, commission-able Rep and Commission Rate in VISTA using BAQ's??
> Thanks Gordon
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]