Skip -
I am wondering how to really do this?
In the SAP database I have the following fields:
LNAME, FNAME, CONTROL COST#, PAYSCALE
Doe, John, C00567123, 2
In the Corp database I have the following:
LNAME, FNAME, DOV, SSN(last 4), JOB #, PAYRATE
Doe, Johnny, OPN123889567, 9876, R12345678, 9.25
1) I can make the CONTROL COST# = DOV by pulling out the matching numbers into two new fields.
2) I can make create a lookup table PAYTABLE where
SHIFT RATE
1 8.50
2 9.25
3 10.00
and use this information somehow...
BUT each week we get new worksheets - so I have to create some type of executable macros to do these...
So with the RAW data - right now it is taking over 36 hrs to process a payroll by hand... I KNOW there has to be a feasible way to do this faster - we are almost in the year 2007 now.
Steve