If statement base salary component

ERPNext
1

Hi Good Day, is there someone can guide me to right direction on how cani achieve this thing.

I have a list of range compensation for deductions for example the range compensation amount is from 8,250 to 8,7499 this is the bracket. When i have a salary of 8,500 which is under the bracket list i will get the amount of 340. How can i achieve this? Using formula or condition. Thanks.

2

Put this in your formula:

340 if (salary_component >8250 and (salary_component <= 8,7499) else if

salary_component is where you insert the abbreviation of your salary component. If you want the sum of several salary components, then you can do like this:

340 if ((salary_component1 + salary_component2) >8250 and(salary_component1 + salary_component2) <= 8,7499) else if

else if where you repeat the same formula for the second tier.

Hope it helps!

1 Like
3

Hi Sir Thank you for your big help… may i ask i try to use this condition B>=amount and B<=amount and i unchecked amount based on formula and input amount that i want to get. And it works the way i want it. My question now is am i doing things inproperly? Or im doing it the wrong way? Thank you

4

To use this formula, you have to check ‘Amount Based on Formula’.

5

Thanks Raymond your formula pattern is much proper than what im using for. Thank you again.

1 Like
6

i have tried this formula but it has failed to work

7

do we use else if or else only to enter another tier

8

Can you please explain the steps of creating salary component till creating salary slip.

-First - create salary component
-Can i put here gratuity/employer PF contribution but do’t want to show in salary slip?

  • Is it necessary to put company name and account in component component>overview>Account while creating salary component (If basic is one of the
    -Value should be annual or monthly in creating salary component & salary structure

Please explain steps