cancel
Showing results for 
Search instead for 
Did you mean: 

Rounding Discrepancy for Goal Results Payout Amount – Variable Pay Management

amuehlbauer
Explorer
0 Kudos
255

Hi SAP Community,

 

I am currently working on a rounding / number format issue related with the field “Goal Results Payout Amount”.

Background of the issue: Due to rounding, the Business Payout Amount has a 0.01€ discrepancy to the Business Target Amount with 100% Target Achievement.

amuehlbauer_0-1736334401469.png

amuehlbauer_1-1736334401470.png

To solve this issue, we tried to increase the numbers of decimal places for the field “Goal Results Payout Amount”. Similar as suggested in KBA 2292772 - Business Section Amount and Target Payout Total have discrepancy - Variable Pay Management.

 

However, when increasing the number of decimal places for “Goal Results Payout Amount”, the precision of the field was not updated correctly:

Instead of displaying the correct value (13615.35 * 50% = 6807.675), the system uses the rounded value (6807.68) and adds the additional decimal places at the end.

amuehlbauer_2-1736334401471.png

I tried changing the number format multiple times (also via Provisioning), but without success.

Has anyone encountered this issue or knows if there are any specific configurations needed for the system to calculate as expected? Any guidance or suggestions would be greatly appreciated!

Thank you in advance for your help!

 

Best regards

 

 

 

View Entire Topic
xavierlegarrec
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @amuehlbauer 

Please keep me honest here but if I read your message correctly vs the content of the KBA, you are saying you added the number format suggested in the KBA to the field "Goal Results Payout Amount". That is not what the KBA is saying. goalBasis is a different field which isn't visible in the Business goal section screenshot you shared (so you need to make it visible and apply the right number format). 

Then run bonus calculation and relaunch worksheets.

All the best

Xavier

 

amuehlbauer
Explorer
0 Kudos
Hi @xavierlegarrec, thank you very much for your feedback. You are correct, KBA is referring to different field. I was linking this KBA because the issue described was similar, but we experienced the issue with the field "Goal Results Payout Amount". We were able to resolve the issue by increasing the decimal places for all money fields, not only the "Goal Results Payout Amount" field. Best regards, Ann-Kathrin
Ravi14
Explorer
0 Kudos

Hello @xavierlegarrec 

Greetings !

Is it possible to do rounding on the basis of currency in variable pay as per different sections payouts?

e.g. , we have different currencies in the form and we are using  business goal payout , Team goal payout , Individual goal payout
Now , We want to apply rounding as per employee currencies on business goal payout , Team goal payout and individual payout separately in all three payout. 
"Round off business goal payout + Round off Team goal payout + Round off individual goal payout =  Final Payout "

We tried to do it and write the formulae using half-up/half-down on above different section payout as per currency but the output is always 0 in the form
Is there any system limitation ?

Can you please provide your inputs.

Regards


xavierlegarrec
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @Ravi14, it should be possible with custom design, can you please document what you have tried to far ? If you look at the design of this blog, you can bring currency code into each section details and build if-then rules accordingly.

https://community.sap.com/t5/human-capital-management-blogs-by-sap/variable-pay-custom-gates-with-cr... 

All the best, Xavier