orange,
thank you very much !
Your description is good but i would like to correct few sentences.
You deal with Companies who may have Departments and/or Sections (some organizational units)
Such Units have Employees.
My company has a lot of internal and external clients - other companies (we are outsourcer).
In my company there are employees which are servicing my company's clients.
Each employee in my company has his own department (area) and subdepartments.
Within my company's clients there are employees who should be serviced by employees from my company.
The Employees get paid for Work done in a time/Pay period.
At some future point, there is a realization that there was an error in the Employee's pay record/pay slip/pay check.
You want to correct the Employee's Pay record and identify the Cause of the error.
It is connected with disability and moneys paid by my government.
Client's Employee can get additional money when they get disabled or change their disability level (from 1 to 2 or from 2 to 3).
Employee has to go to polish court and for example it lasts one year (or longer).
Employee is working all this time, and after year he gets positive opinion from court that he should get the additional money for present time and for 1 year before.
Now my company enter here. All corrections' tickets are inputed by different people from other departments into Probit or SAP system.
And now my department has to check all these corrections (their correctness) and input it into SAP or Probit systems.
Problem is that in my company within these systems there are not any adequate report for our clients. Clients want to know everything including exactly amounts of money for each employee.
So in consequence i am doing Access tool to help people with creating reports for our clients.
?? Could it be the Employee who notices the error? Or
?? Is it always the Company (or some other organization)??
It is always company or other organizations.
Code:
The Employee's pay rate is known.
The length of the Employee's Pay period is known.
So the Employee's Gross Pay can be calculated.
The appropriate Taxes/Deductions are known.
So the Employee's Net Pay can be calculated.
All what is known Employee Correction amount and for each period.
Code:
In order to "correct" the Pay record in error, you need to know
- the original amount
- the revised amount
- the reason for the error
I need get report from SAP for specific month which will show what each employee has to have corrected.
Best Wishes,
Jacek Antek