Annual Salary is not calculated after multiplying by 14
We have a custom wage type "9500 - Standard Pay" and we have 14 payperiods in a year. We are seeing that if we enter $10 for WT-9500, the annual salary (ANSAL) does show as $140 (10 multiplied by 14).
It multiplies by 12 (instead of 14)...and shows $120!!
Do you have any clue on how to correct the total annual salary.
Thank you.
G.
I guess there might be an issue with the feature PFREQ which shows currently the following:
Period Number of periods per year
Weekly 52
Two-weekly 26
Half-monthly 24
Four-weekly 13
Monthly 12
Quarterly 04
Half-yearly 01
We have 14 pay periods in a year. Not sure, which piece I need to change her. Any clue??
Thanks and very best regards.
Hi,
You should have assigned a period parameter to the pay scale area in V_T510W.
The feature PFREQ is referring to the time period associated with the period parameter in V_T549R. In order to get the period multiplied by 14 change the line in PFREQ from its current value to 14.
Cheers
_________________
Rory
Hi Rory,
Thanks a lot for your suggestion on this. I had look in table V_T510W, and then V_T549R and PFREQ feature. And I have following question if you or anyone on this forum can clarify this would be very much appreciated.
We have varying pay frequencies....for one set of employees we make 12 payments and another set 13 payments and remaining employees 14 payments.
Now for table/view V_T510W, I see, I can maintain based on pay scale type/area and ESG. Which sounds great to me. But I am confused on what to put under "Period Parameters". The standard values I have got here to choose are monthly, weekly, bi-weekly, etc.. which does not meet our requirements of 13 and 14 payments.
The table V_T549R can be used to create "Period Paramters". But I am not sure what to enter under "Time Unit" as my payroll processing is not Monthly and not weekly as we make 13 or 14 payments for specific group of peoples.
But then I see I can maintain the feature PFREQ with frquency. But how can I maintain this feature as this is global and within one country we have various pay frequency based on the pay scale type and area.
Please advise.
Thanks and very best regards,
G.
Hi G,
I presume you have are using different period parameters for each of your three groups of employees. The period parameters for employees with 12 and 13 pay periods could be mapped to the standard time units 01 and 05 respectively.
The employees with 14 pay periods do not correspond with one of the standard time units. However, you could assign one of the other time units (eg. 0 to this period parameter and then configure feature PFREQ as though 08 equalled 14 pay periods.
This should work although you may have to manually amend the results once you have generated pay periods. But then I guess you are having to do that anyway in order to create 14 periods in a year.
Good luck
_________________
Rory
Hi Rory,
Thanks a lot for your suggestion. It did work. THANK YOU.
Now I am landed up in another issue..aah...one of our location does not use payroll and they would like to maintain only basic pay infotype to record the monthly and special payments and they have following payments with frequencies:
Monthly Salary = € 1,000 x 12 payments every year = € 12,000
Special Payment#1 = € 500 x 1 payment every year = € 500
Special Payment#2 = € 800 x 1 payment every year = € 800
Special Payment#3 = € 1,200 x 1 payment every year = € 1,200
--------------------------------------------------------------------
Annual Salary = € 14,500
--------------------------------------------------------------------
If I can put the one time special payments in additional payments/deductions infotype then I am done. But my users from this location do not want this and looking to put above data in IT0008 with the annual salary calculation based on all the 4 wage types multiplied by their frequncies (and not multiplied by the same frequency 12 or 14).
Do you or anyone else on the list have any clue on how to make IT0008 accomodate this requirement.
Thank You again.
G.
G,
I think you have a couple of options:
1. The table in which you identify the wage types that feed into ANSAL (V_T539J_B) contains a percentage field. You could assign a percentage of 8.66 to the special payment wage types so that only 1/12 of the total value is evaluated in each period. However, this may lead rounding issues in the calculation of ANSAL because you can only assign the value to 2 decimal places in the table.
2. Alternatively you could hold the annual salary rather than the monthly salary ias a wage type in IT0008. Then all wage types would have the same payment frequency. However, this would then leave these guys out of kilter with the rest of the company where a monthly salary is shown in IT0008.
Cheers
_________________
Rory
Hi Rory,
Thanks a lot for your suggestion. Actually the same as in #1 is also suggested by one of another friend. However, I have not yet able to make it to work. Not sure what's going wrong here:
Standard Monthly Pay - have following characteristics
(WT 9500) indirect eval. module - TARIF (with module variant A)
and check mark 'add to total'
Special-Pay#1, #2 and #3 - have the same characteristics as above
(WT 9510, 9511, 9512)
In table V_T539J_B:
For Indirect eval. module- ANSAL:
ASAL Annual salary 1 01.01.1900 31.12.9999 9500 Std. Pay 100.00
ASAL Annual salary 2 01.01.1900 31.12.9999 9510 Special paym#1 8.66
ASAL Annual salary 3 01.01.1900 31.12.9999 9511 Special paym#2 8.66
ASAL Annual salary 4 01.01.1900 31.12.9999 9512 Special paym#3 8.66
Whatever change I make in percentage field, it does not seem to have any affect. It takes the total of 9500, 9510, 9511 & 9512 then multiplies by the pay frequency and shows the amount in Annual Salary. However, in the case of 9510 or 9511 or 9512 it should have only taken 8.66% of the amount. But it does not.
Any clue.
Thanks and best regards,
G.
G,
I have tried it out in a test client and I cannot make it work either. It looks like the percent field is ignored in the ANSAL evaluation module.
Sorry
_________________
Rory
Hi Rory,
Thanks a lot for looking into. I also debugged this ANSAL calculation but it does not seem to have anything to do with the percentage (V_T539J_B-GWCHT). Now as we seem to hit the deadend with this line of thinking so I started to think other options. However, not sure if there is any, so I would like to have your opinion on the following:
1) USER-EXIT: there seem to be a user-exit EXIT_SAPLPARA_002(Exit for Calculating Salary Percentage from IT0008 "Basic Pay" ) but this user-exit does not seem to be called from ANSAL. I tried to setup breakpoint in LPARAF01 from where this routine is called. But the control never seem to arrive here. (well, this option seem to be not a viable one unless there is something I am missing).
2) DUMMY-WAGE-TYPE: Maybe this should work. The idea is to create a dummy wage type...transfer the 1/12th of the amount from special payment wage types 9510, 9511 & 9512 to dummy wage types D510, D511 & D512. Then instead of adding 9510, 9511 & 9512; add D510, D511 and D512 to the total. And let the system multiply the period total by 12 (the dummy wage type will not be added to the basic pay, it would be just for internal calculation).
What do you think of option#2.... ?????
Thanks a lot for all your assistance.
With very best regards,
G.
G,
I'm not sure about option 2. It seems a little messy. Won't these dummy wage types need to appear in IT0008?
Cheers
_________________
Rory
Hi,
I am thinking that there would not be a need to put those dummy wage types in basic pay screen, as they will be calculated fields.
Now having said that, I think our customer seems to opt old fashioned design. Meaning, show the one-time payments as 1/12 of the amount and then let the system multiply by 12.
Well, if they choose that, then I my configuration is already there to support it. Aha...what a relief !!!!
Thank you so much Rory for all your assistance and support.
With very best wishes,
G.