on 10-23-2013 9:51 AM
Dear All, I am facing a problem in claim wage types /552 & /563. In October payroll, there is a claim for employee 822 SR. While running November payroll, the amount 1141 is being posted under Wage Type /563, and the reason is there is a deduction of 319 in employee's salary.
But the problem is, the difference (-319) is also being posted to Difference Wage Type (/552) as 319, and also being posted to Claim From (/563). If it is being posted to /552, the amount should not come under wage type /563.
How come the difference (-319) being posted to different wage types (/552 & /563) at the same time? Please advise as how can i solve the problem?
Regards, Omar
Dear Omid
I have above attached the RT for October salary, from there you can clearly see that the claim (822) is caused by total deductions (4122) which is -2465. And this -ve amount was more than the total earning 1643 which caused the claim (561) -822.
I need to know exactly which PCR needs to be checked for the above calculation.
Regards,
Omar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Omar,
You processed live payroll for the month of november?
If yes please go to PC_Payresult and check what is the difference between active and previous results for October month.
If no payroll live payroll run happen , please check the result of Otober month in the payroll log and active result of October ( in period October and for period October ).
You can see there is an entry for /551 in the latest result of October and that same is effecting /561 of that month. The same amount of /551 will come as /552 in November and the new /561 will come as /563.
For example you have an earning of 1000 and deduction of 2000 in the month of October . Due to some master data changes ( let say a reduction of 500 in October ) in November for October system will go for a retro active payroll run for october in november . This time the earning is reduced by 500 so your earning is now 500 and the same will come as /551 . Due to this reduced earning your new claim will become 1500 instead of 1000 what calculated last time .
The new /561 will now passing as /563 and you will find the difference of 500 and the same will be come in /552 with a negative amount .
There is nothing wrong with the calculation it is only about the understanding of the process.
Regards
Sujith
Dear Sujith
Yes, the live payroll has been executed for both Oct & Nov salary.
I think you are not able to comprehend what exactly happening in my payroll process. I believe there was claim of 822 which posted to November salary as (-1141) because there was some reduction in Oct salary, which is absolutely fine. But the problem is the reduction (-319) as difference (/552) is being deducted twice from November salary. If the difference (-319) from Oct salary is appearing in Nov salary then it should not be posted to Claim from (/563) wage type. Also, the difference -319 (/552) is being added to claim wage type (/561) in November salary (which is even more worse) because there was further reduction in November salary which caused the claim. The difference amount from prev. period (-319) should not be posted to current November salary Claim wage type (/561).
The right calculation in November salary should be like this:
Right Calculation (November):
/552 Difference 319.00-
* /561 Claim 517.00
* /563 Claim from 822
Wrong Calculation (November) - which is happening in Live Payroll
/552 Difference 319.00-
* /561 Claim 836 (Diff -319 is added here)
* /563 Claim from 1141 (Diff -319 is again added here)
Regards,
Omar
Dear Omid
You can clearly see from above text that the system has not carried forward the same claim (822) from October salary into November salary (1141). The system has added the difference (-319) into both wage types Claim (/561) and Claim From (/563), which is wrong. The claim (/561) in November salary should be 517 but the system has added amount (-319) from difference wage type (/552) into both Claim (/561) and Claim from (/563) wage types.
Regards,
Omar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Omar,
May I have October result for previous RT? And I would know what you have done in October which cause claim?
I recommend to go line by line for October and check the PCR outputs to realize how system makes calculation and produces this amount for claim. Do the same for November.
Regards,
Omid
Dear Omid
Please have a look at below screenshot:
October Salary
* /101 Total gross 822.00-
* /550 Statutory n 822.00-
* /561 Claim 822.00
* /562 Balance of 822.00-
* /700 Wage/salary 822.00-
* /840 Diff. to av01 21.50-
* 5030 GOSI Elr Ct 27.50
* 9010 GOSI BASE 1,375.00
2 /001 Valuation b01 5.28
2 /002 Valuation b01 4.58
2 1000 Basic pay 01 1,100.00
2 1020 Transportat01 168.00
2 1030 Housing All01 375.00
2 4122 Other Deduc01 2,465.00-
November Salary
Table RT
A WT WT Text APC1C2C3aBKoReBTAwvTvNUnit Amt/Unit No. Amount
* /101 Total gross 624.00
* /550 Statutory n 624.00
* /552 Difference 319.00-
* /561 Claim 836.00
* /563 Claim from 1,141.00
* /700 Wage/salary 624.00
* /840 Diff. to av01 50.00-
* 5030 GOSI Elr Ct 22.18
* 9010 GOSI BASE 1,108.75
2 /001 Valuation b01 4.09
2 /002 Valuation b01 3.70
2 1000 Basic pay 01 887.00
2 1020 Transportat01 95.00
2 1030 Housing All01 342.00
2 4121 Other Payme01 300.00
2 4122 Other Deduc01 1,000.00-
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You please check in RT table , previous and active result for employee for the month of october (in period october for period october and in period november for period october).
Lat time you have a claim( /561) of 822 and in the retro run there is a change in the pay components that create /551 in october for 319 ( it will reduce the payment side) and because of this the claim will become more. So in november the amount 1141 will come in wage type /563 and 319 in /552.
Check the values of /561 in PC_Payresult for active and previous periods you can see the difference.
It is genuine adjustment due to masterdata change.
Regards
Sujith
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Sujhith
Thanks for the reply.
The problem is which I forgot to mention in the earlier message is that the difference '-319' in /552 is also being added to wage type /561 in November payroll means the difference '-319' is being added to '/563' & '/561' at the same time. If it already posted to 'claim from' /563 then it should not have been posted to /561.
The amount of claim /561 in November payroll should be -517 (1141 - 624), the amount 624 is employee's earning in november payroll. But instead of -517, the amount being posted to /561 is 836 (-517 + -219) which is wrong.
Regards,
Omar
Dear Omar,
It's a difficult to understand your case by your explanation. I recommend to post result table for October and November and explain why you have claim, what is the claim amount and so on.
Let me just explain how system works maybe this help you. To have a better understand of claim you should understand how system uses each related wage types like /550, /551, /552, /553, /559, /560, /561, /563.
There are two types of claim one is positive amount(must to pay to EE) and next is negative amount(must deduct from EE).
/563 is related to negative claim. This is the amount which comes from previous month. Imagine in your case you calculate and pay EE in October by basic salary 1000 USD then in November you realize you have made a mistake in EE's basic salary and it must be 900 USD. So you have to change EE's basic salary to 900 USD for first of October.
If you do such a change system will calculate a negative claim(deduction). If you run payroll for November system will do retro. calc. from October and if you look RT table of October you will see the claim amount in /561 but in RT of November you will find the same amount in /563. This means system has done a carry forward of negative claim from previous month into /563 of current month.
I hope this help you to realize your case otherwise share some screenshot of your case to have a look.
Cheers,
Omid
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.