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