Salary Slip Formula Calculation

Frappe HR
1

Hi

Need little help on salary structure formula calculation.

I need to calculate the PF on the basis if basic salary * 0.12% is higher then 1800 and it should calculate 1800 only and if it is below that then it should calculate that amount i.e. basic salary * 0.12%.

Now the basic salary is depend upon leave without pay, so after creating formula in PF section should I check Leave without pay or it will be calculated automatically ?

Regards,

2

You can try adding two rows for PF which different conditions and formula. Then try creating Salary Slip against that Salary Structure with different values in Basic Salary (with/without) LWP and greater/less than condition amount and check if amount for PF is calculated fine.

3

Hi @umair

Tried your solution please check the below conditions in salary structure is correct or not.

Condition one if basic salary(which is B) B *.12 is not equal or less then 1800 then the amount would be B * .12

PF1.png1188×922 83.8 KB

and if basic salary B * .12 is equal or higher then 1800 then the amount would be 1800 only.

PF2.png1195×927 83.6 KB

Below is the salary structure

SL1.png1407×945 55.2 KB

Please note basic salary B is depend upon Leave without Pay, so logically if it decrease then the PF amount will also decrease right ?

Now below is the salary slip, in this slip employee is present for all days which 31, so the calculated PF amount is 1800 which is correct.

SS.png1351×887 46.3 KB

This is the secondary slip where the employee is not present for 10 days, and as I said that basic is depend upon leave without pay, so after calculation the basic is 10,974.19 so accourding to the PF formula the PF should be 10,974.19*.12 = 1316.9028 but it is still showing me 1800.

SS1.png1346×887 46.7 KB

Now please let me know what I am doing wrong, and apart from it what should be the formula code if I want to round up the amount ?

Regards

4

Hi

Does any one have any input ?

Regards

5

@umair

Can you confirm, that are you also replicating the issue like I am, with the given conditions?

Or i am the only one :frowning:

6

can you explain how you get 16200?

7

Have you got the solution? As currently, I am facing the same issue

8

in single line try

1800 if B*.12 >=1800 else B*.12