Former Member

# Rounding issue calculating basic pay

Hi experts,

I have an issue with employee with 2050 basic pay and he's being paid 2499,99.

Here's what happened relating to his master data:

- Employee had 2 personnel actions performed during the month which originated 3 splits

- None of the personnel actions performed have any effect in Basic Pay (constant throughout the entire month)

The salary is calculated upon monthly working days (22 in this case). The first period comprises 2 working days, the second 8 and the third 12.

The system is calculation the partial period factors based on constant GENAU (100.000,00) and the results are the following:

/801 partial per01 = 2 / 22 * 100000 = 9090,91

/801 partial per02 = 8 / 22 * 100000 = 36363,64

/801 partial per03 = 12 / 22 * 100000 = 54545,45

Then based on these values, it calculates the basic pay per partial period rounding to cents

0100 partial per01 = 2050 * 9090,91 / 100000 = 186,36

0100 partial per01 = 2050 * 36363,64 / 100000 = 745,45

0100 partial per01 = 2050 * 54545,45 / 100000 = 1118,18

In the end it sums the basic pay for each partial period and the result is 2499,99 which shouldn't happen because the basic pay remained the same throughout the entire month. Can you please give me any suggestions on how to fix this?

Hugo

10|10000 characters needed characters exceeded

### Related questions

• Posted on Jan 18, 2012 at 09:18 PM

What currency are you using, 2 decimal?

10|10000 characters needed characters exceeded
• Former Member
Posted on Jan 19, 2012 at 05:14 AM

Dear,

I think, if you have a problem of rounding the values, then you should write a PCR for rounding of values. Because as you mentioned that the patial period factoring is calculating its value in splits. In my opnion, you should have to write a pcr for rounding of values after that.

Regards,

Hassan

10|10000 characters needed characters exceeded
• Former Member

Hi Hassan,

Yes I understand that but I'm not quite sure on how to do it because for most cases this calculation method is actually correct but in this special case it's not. So I want to change it without screwing up the majority of the cases where this actually works well.

I don't want all amounts rounded up to the units. There are some situations where rounding to the cents is correct. But in this particular case it's not since there is absolutely no change that should affect the basic pay amount.

I understand that I have to create a rule that:

- Checks if this is not a case of an employee starting/leaving during the month or having unpaid absences (because if this is the case the current calculation method would be good)

- Checks if there have been any changes to the basic pay amount during the month (if there were changes then the current method is also correct)

So, I need to create a rule that will apply the amount on the basic pay infotype without any factoring being done if the following conditions are met:

- Employee has been working for the entire month without unpaid absences (I guess I can check this by comparing the sum of /801 partial periods to GENAU)

- Employee has not had any basic pay changes during the month (not quite sure on how to do this)

Could you please give me some help creating this rule?

Thanks,

Hugo

• Former Member
Posted on Jan 19, 2012 at 05:58 AM

Hi

In wage type characteristics (V_T511) table you have block as indirect valuation in that rounding type field is there give

B --- which means up or down

Regards

Manoj K

10|10000 characters needed characters exceeded