Need some advise....
Payroll program Access97. Payroll is printed then posted to a hx table thro'
a query with the payroll calculations that freeze that payroll's numbers for
that period.
The weekly payroll period reports are produced from the Payroll table by
queries that are linked to the Employee details table...salary, base rate,
lead rate, wh allowances, status etc...so this is real time data with the
current information in the details table.
The quarterly, YTD and EOY reports all come from the hx table.
Now of course, comes the data entry error and the payroll period reports are
reproduced. But, there have been some changes in the details of an employee
since the first report and the numbers are wrong for that payperiod now.
Anyway I recommend that the payroll clerk go into the details table and
change say the wh allowance number back to the one used for that payperiod
and generate the report. After doing so, change the wh allowance back to the
current number.
A bookkeeper says these reports (weekly) should come from the hx table. But,
if there are errors and they have been posted then the hx table would have
to be edited to correct the errors to print the reports. Which means I have
to diminish the security on the hx table so it could always be edited. I
don't like that. I have security on the hx table now so only inserts of the
posted data will be accepted. The table cannot be edited except by an
administrator to protect the table from tampering....
I hope I have made myself clear on this matter. :-)
What say you???
rdf