cancel
Showing results for 
Search instead for 
Did you mean: 

payroll monthly factoring, Valuation Base issue

Former Member
0 Kudos
214

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.

View Entire Topic
sikindar_a
Active Contributor
0 Kudos

on V_512w_O

check processing class 10

Former Member
0 Kudos

Hai

I think only the basic pay Wage type assigned to valuation base , if you want to give all other allowance as per working days (,as you said recurring allowance,)you have to add those wage types into valuation base ie processing class 01 in v_512w_d.

Vincent

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hai

Valuation Base will give per hour value, check the rule X012 & X013, same,check the payroll Log.

If possible give your earnings heads.

Vincent

Former Member
0 Kudos

Dear Vincent,

Can u explain /203 Average base to me as i dont understand this. and can u plz tell me if i have correct understanding of /001 Valuation base, i have given the details in my earlier answer.

Regards,

Former Member
0 Kudos

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

Former Member
0 Kudos

Also Table v_512w_c define how averages are created and how wage types are valuated using averages.

Vincent

Former Member
0 Kudos

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

Former Member
0 Kudos

Hai

Post the Gross details,like how much is basic , other allowance in earnings.Same what is the Planned working time of the employee per day as per schedule.Confirm all those earnings are assisgned specification 1 in PC 01.

Will sort it out.

Vincent

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Dear Vincent,

Thank you very much for all the time you gave this issue. It has been resolved now.

Regards.