Skip to Content
author's profile photo Former Member
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?

Thanks in advance,

Hugo

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

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

    What currency are you using, 2 decimal?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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

    Add a comment
    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

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.