on 08312008 3:44 PM
Dear All,
I have an issue with payroll monthly factoring. The issue is the if I hire an employee at, lets say 15.07.2008 and run his payroll for the 7 month, he should be paid half his recurring allowances that r part of his gross.
I have given this employee gross salary of 3,851/. He is suppose to be working 173.33 hours a month, as per 0007. The valuation base (/001) is coming up as 24.069, that is in accordance with monthly working hours 160.
In short, this employee should be paid half the salary but he is being paid more then that, that is 2176.652/. What could be the reason? I am using /801 factor in Mark wage types for monthly factoring for all my wage types that are part of gross.
Can someone please help me out of this problem.
Regards.
on V_512w_O
check processing class 10
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
on V_512w_O
check processing class 10
I have already made the processing class 10 as 1, that is Reduction with factor /801, for all my recurring allowances or wage types that r part of gross but the value for /001 Valuation is not being calculated correctly and thats y the reduction in recurring allowances is not being calculated correctly.
Thanx for answering.
Dear Vincent,
As per my last answer, i am doing the same as u r advising. Let me ask you one more thing, Valuation base is calculated as; all the allowances with processing class 10 marked as 1 in table V_512W_D added together devided by Monthly working hours given in infotype 0007? If i am correct then the valuation base is not being calculated correctly.
Thanx for answering.
Hai
Wage Type /201
Wage type /201 (Average basis 01) is a secondary wage type used as a cumulation wage type (see /1** wage types) for average calculation. All wage types marked as relevant for average bases are cumulated in this wage type. You can specify for each wage type which parts are to be cumulated (RTE, NUM, AMT) and the average basis in which the amount is to be stored (e.g. overtime remuneration in /201; overtime bonus in /202
or number of overtime hours in /209). When valuating wage types with averages, you can use the average calculation rule to access various combination's of average bases.
Calculation rule X018 determines the valuation of the wage type using the cumulated average base.
The AVERA function performs the complete averages calculation. The average value is calculated for each average calculation rule.
Wage Type /001
Wage type /001 (Valuation basis 1) is a secondary wage type. The valuation basis is the amount per hour. In the standard SAP system, valuation bases are formed in personnel calculation rules x010, 'Determination of valuation bases' (e.g. D010, X010) and x013,'Division of valuation bases' (e.g. D013, X013). They can be used to valuate time wage types (such as Overtime).
Hope this will helps your understandings.
Vincent
This is turning out to be a real nightmare. The valuation base is not changing even if I change the daily working hours in Infotype 0007. I thought it will change based upon the change in daily working hours. Can the HCM Gurrus please help me out?
I have observed another thing by doing some simple math. The gross pay I have given to this one employee is 3851/ and according to my Infotype 0007 his monthly working hours should be 173.33. Now the /001 Valuation Base should come out to be 22.217 but its coming out as 24.069 so that means the system is taking monthly working hours as 160 in place of the one given in 0007, that is 173.33, as;
3851/173.33 = 22.217 if 173.33 = n then 3851/n = 22.217 and if we replace 22.217 with 24.069 then n =?
n = 3851/24.069 that is n= 160
What is going on here???
Regards.
Edited by: Ahsan Zaidi on Sep 1, 2008 1:51 PM
got it... the Work hours/period in infotype 0008 was set as 160 and that was being used to calculate /001 Valuation base. Now when i am hiring a new employee in the shift, he is getting 173.33 hours in the work hours/period in infotype 0008 itself. Now the final issue is that /001 Valuation base is comming out fine but still the value being calculated on it is wrong. the wage types in infotype 0008 are as following;
0001 Basic Pay 2.926,000
0002 Rental Allowance 430,000
0003 Furnishing Allowance 125,000
0004 Utilities Allowance 35,000
0005 Transportation Allowance 175,000
0006 Education Allowance 160,000
the employee was hired on 15.07.2008 and infotype 0007 is as following;
Employment percent 100,00
Daily working hours 8,00
Weekly working hours 40,00
Monthly working hrs 173,33
Annual working hours 2080,00
Weekly workdays 5,00
and RT for the payroll run 07/2008 is as following;
/101 Total gross 2.176,652
/201 Average bas 2.176,652
/202 Average bas 1.653,826
/840 Diff. to av01 10,67
/001 Valuation b01 22,218
0001 Basic Pay 01 1.653,826
0002 Rental Allo01 243,043
0003 Furnishing 01 70,652
0004 Utilities A01 19,783
0005 Transportat01 98,913
0006 Education A01 90,435
/550 Statutory n 2.176,652
/700 Wage/salary 2.176,652
/557 Cash Paymen 2.176,652
/560 Payment Amo 2.176,652
Employee has worked 13 days in the 7th month for 8 hours a day so he should receive a gross amount of 2310.672;
13 * 8 = 104 and 104 * 22.218 = 2310.672
Where as he is getting 2.176,652. Can u help me out??? i know i am taking toooo much of your time.
Regards.
Hai
Earnings Amount Per Day Per Hour 13 Days

Basic Pay 2926 127.217 15.902 1653.826
Rental Ale 430 18.696 2.337 243.043
Furhing Al 125 5.435 0.679 70.652
Utilities Al 35 1.522 0.190 19.783
Trnsprtn Al 175 7.609 0.951 98.913
Eductin Al 160 6.957 0.870 90.435

3851 167.435 20.929 2176.652

Hope system is right in net pay, it calculates exactly for 13 working days as well you are paying only for employees working days in a month.
Problem is now Valuation base is showing 22.218 but actual valuation base as per calculation is 20.929.
Now tel me the /001 amount, it should be more than 3851 , I hope.
One more thing , you have used Average basis, tell me the need of that.Check the Wage type 0002 & 0006 in Average basis table.
as well as check processing class 15.
Vincent
Sorry but i have been very busy with other things. Ok, can you tell me one thing first, i have been told that in calculation rule XPPF you tell the system wather you want to do the calculation on hourly bases or daily bases. what is that parameter??? Is thta parameter, by default, set to days???
Regards.
User  Count 

110  
6  
6  
4  
4  
4  
3  
3  
3  
3 
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.