Commissions

Our company is trying to determine how best to use Vantage for
reporting Commissions to our Sales Reps.

We will want the ability to do Split Commissions, but our commissions
are based on the paid amount throughout the month and not on the
sales order value.

If anyone has any information or knowledge or reports they can offer,
I'd be very grateful.

Sincerely,
Judy Havlik
Plitek, L.L.C.
847-827-6680

e-mail: judy.havlik@...
Does anyone know where (what table) Vantage stores the Sales Rep? I am trying to create a commission liability report and I need to sort by sales rep.
Please and Thanks
Stephanie
There is a "salesrep" table. SalesRep Code shows up in the Invoice tables.??

HTH,

Juliet

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Monday, March 07, 2005 12:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Commissions




Does anyone know where (what table) Vantage stores the Sales Rep? I am trying to create a commission liability report and I need to sort by sales rep.
Please and Thanks
Stephanie
SalesRep


[Non-text portions of this message have been removed]
But that doesn't show the same thing that is on the order detail... there is nothing that ties to that code?

-----Original Message-----
From: jeremyrleonard@... [mailto:jeremyrleonard@...]
Sent: Monday, March 07, 2005 1:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Commissions



SalesRep


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



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
Ok thanks I will look there

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Monday, March 07, 2005 1:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Commissions



There is a "salesrep" table. SalesRep Code shows up in the Invoice tables.??

HTH,

Juliet

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Monday, March 07, 2005 12:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Commissions




Does anyone know where (what table) Vantage stores the Sales Rep? I am trying to create a commission liability report and I need to sort by sales rep.
Please and Thanks
Stephanie


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
Just a thought (reading between the lines)....are you trying to link SalesRepList on OrderHed to SalesRep table? If so and you have not worked with the reps on orders or in invoices be aware that in order to handle commission splits the rep list is an array. It can handle 5 reps and these correspond to the RepRate and RepSplit fields.

In the SalesRepList the individual reps can be split out (in RB) using the ENTRY function. There may be an equivalent in Crystal. The delimiter character is the ~ or tilde character which is ASCII 126. I usually create a function field called Tilde and assign is CHR(126) and then use this in another function to grab each rep and then link them to the SalesRep table....like SalesRep1 = ENTRY(1,SalesRepList,Tilde) where the 1s can be 2,3,4 or 5. I have alias tables for SalesRep so I link to it 5 seperate ways for each order/invoice.

Even if you do not split commissions you would need to at least parse out the rep code for Entry 1 in order to link to SalesRep..

Sorry if this was not what the issue was but I was sensing some possible confusion and the way the commissions are designed (with arrays) is confusing enough anyway.

-Todd C.

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Tuesday, March 08, 2005 7:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Commissions


Ok thanks I will look there

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Monday, March 07, 2005 1:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Commissions



There is a "salesrep" table. SalesRep Code shows up in the Invoice tables.??

HTH,

Juliet

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Monday, March 07, 2005 12:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Commissions




Does anyone know where (what table) Vantage stores the Sales Rep? I am trying to create a commission liability report and I need to sort by sales rep.
Please and Thanks
Stephanie


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









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 Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129gcvp34/M=298184.6018725.7038619.3001176/D=groups/S=1705007183:HM/EXP=1110373735/A=2593423/R=0/SIG=11el9gslf/*http://www.netflix.com/Default?mqso=60190075> click here
<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:HM/A=2593423/rand=504233986>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]
You are exactly right in what my problem is ... but we don't use/have RB so I am trying to create something in access... and being an Assistant Controller not a computer person I have no idea how to break this field up into the 5 or whatever fields they are... I think I am in well over my head on this one.

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, March 08, 2005 9:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Commissions



Just a thought (reading between the lines)....are you trying to link SalesRepList on OrderHed to SalesRep table? If so and you have not worked with the reps on orders or in invoices be aware that in order to handle commission splits the rep list is an array. It can handle 5 reps and these correspond to the RepRate and RepSplit fields.

In the SalesRepList the individual reps can be split out (in RB) using the ENTRY function. There may be an equivalent in Crystal. The delimiter character is the ~ or tilde character which is ASCII 126. I usually create a function field called Tilde and assign is CHR(126) and then use this in another function to grab each rep and then link them to the SalesRep table....like SalesRep1 = ENTRY(1,SalesRepList,Tilde) where the 1s can be 2,3,4 or 5. I have alias tables for SalesRep so I link to it 5 seperate ways for each order/invoice.

Even if you do not split commissions you would need to at least parse out the rep code for Entry 1 in order to link to SalesRep..

Sorry if this was not what the issue was but I was sensing some possible confusion and the way the commissions are designed (with arrays) is confusing enough anyway.

-Todd C.

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Tuesday, March 08, 2005 7:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Commissions


Ok thanks I will look there

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Monday, March 07, 2005 1:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Commissions



There is a "salesrep" table. SalesRep Code shows up in the Invoice tables.??

HTH,

Juliet

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Monday, March 07, 2005 12:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Commissions




Does anyone know where (what table) Vantage stores the Sales Rep? I am trying to create a commission liability report and I need to sort by sales rep.
Please and Thanks
Stephanie


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









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 Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129gcvp34/M=298184.6018725.7038619.3001176/D=groups/S=1705007183:HM/EXP=1110373735/A=2593423/R=0/SIG=11el9gslf/*http://www.netflix.com/Default?mqso=60190075> click here
<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:HM/A=2593423/rand=504233986>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]



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