Sales Orders with Commision Amounts

I resorted to dumping the data to an Access DB but later Mark Pladson posted
report in the Epicor downloads area that managed to resolve the linking,
albeit with heavy filtering. This makes it very slow (especially on larger
databases) but apparently it can be done in RB. I have not gone back to
look at it to see if I could do a pure RB sales commissions report. The way
it was originally designed with indexed fields and the table format (data in
string seperated by tilde characters) makes the whole process of sales
commission splits difficult to report. Once you parse the sales rep code
out you can't link with it (but can filter on it). Now that I am dumping it
all out to Access (via a CSV file) it works pretty nice except that now I am
stuck running the reports (to not buy another copy of Access for the end
user).

I searched the message threads on this topic over the past couple years and
the consensus seems to be to have to do some sort of export.

-Todd C.

-----Original Message-----
From: Les Tingley <ltingley@...> [mailto:ltingley@...]
Sent: Tuesday, December 17, 2002 10:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Orders with Commision Amounts


Has anybody come up with a similar report to the one on the support
site? That one is poorly indexed or something.

Thanks,

Les Tingley
IT Manager
Decorated Products


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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

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]
Has anybody come up with a similar report to the one on the support
site? That one is poorly indexed or something.

Thanks,

Les Tingley
IT Manager
Decorated Products