Salary Structure not validating conditions correctly

[ben]

After i process my payroll i have realised some of the validations i have put on salary components are not being validated.

My scenario is as follows.

Employee Base pay = 300.000 (I have already done this in the salary assignment)

I have the following salary components attached to my salary Structure:

House allowance Group A = Condition (base<=100000) Formula (base0.01)
House allowance Group B = Condition (200000<=base>=100001) Formula (base0.02)
House allowance Group C= Condition (300000<=base>=200001) Formula (base0.03)
House allowance Group D = Condition (400000<=base>=300001) Formula (base0.04)
House allowance Group E = Condition (500000<=base>=400001) Formula (base*0.05)

If the above conditions are set in my salary structure, it means once i process my salary slip for employee whose base pay is 300,000 then only House allowance Group C will be processed and all the others ignored.

Currently with this setup i can see the system validates House allowance Group B and House allowance Group C in the salary slip for the employee with base pay as 300,000. This is not the correct computation.

Kindly assist. Could i be missing anything on my validations/conditions or how is the best way of solving this scenario? Your assistance will greatly be appreciated.

I am using
ERPNext: v12.2.2 (version-12)

[ben]

Here is the solution:

Multiple conditions on Salary Structure with a single formula

HI i wanted to know how to put multiple conditions with a single formula on ERPNEXT version 12. Example: Component 1: if base is greater than or equal to 5,000 but less than or equal to 10,000 then base * 0.01 Component 2 if base is greater or equal to than 10,001 but less than or equal to 15,0000 then base * 0.02 How can i express these condition on the salary structure? Kindly assist.