I’m trying to get the monthly sales made by an Employee/Sales Person/User through his userid/email. I then want to use that data in a doctype and Salary Structure to create a formula for the generation of Salaries for an Employee segment (eg. Employee Grade) based on custom rules based on his monthly sale
If the monthly sales are> 30,000 for an employee, Salary = 10,000.
If the monthly sales are> 70,000 for an employee, Salary = 20,000 + 50% of Salary
If the monthly sales are> 1,00,000 for an employee, Salary = 30,000 + 45% of Salary
Is that somehow possible in ERPNext? I’m trying but I haven’t been able to figure it out yet. Any guidance on what could be done? I really need this feature.
Thanks in advance!