Calculate total salary

ERPNext Customize ERPNext
, , ,
1

Any help with this?

image
image1922×1030 70.9 KB

frappe.ui.form.on('Definition Of Salary', function(frm){
	refresh(frm); {
  frm.set_value("total_salary",frm.doc.basic_salary + frm.doc.housing_allowance + frm.transportation_allowance);
}
	
});
2

@Hardik_Gadesha

3

@Nada-86

frappe.ui.form.on("Definition Of Salary", {
    refresh: function (frm) {
        if(frm.doc.docstatus === 0){
            frm.set_value("total_salary",frm.doc.basic_salary + frm.doc.housing_allowance + frm.transportation_allowance);
        }
    }
});
4

@Hardik_Gadesha
what is docstatus?

5

image
image1406×835 17.7 KB

nop

6

@Nada-86

frappe.ui.form.on("Definition Of Salary", {
    refresh: function (frm) {
        calculate_total_salary(frm);
    },
    basic_salary: function (frm) {
        calculate_total_salary(frm);
    },
    housing_allowance: function (frm) {
        calculate_total_salary(frm);
    },
    transportation_allowance: function (frm) {
        calculate_total_salary(frm);
    }
});

function calculate_total_salary(frm) {
    let total_salary = frm.doc.basic_salary + frm.doc.housing_allowance + frm.doc.transportation_allowance;
    frm.set_value("total_salary", total_salary);
}
7

@Hardik_Gadesha

image
image1922×1030 51.7 KB

image
image1922×1030 52.4 KB

8

@Nada-86 Looks like you have create field type as Data, make it as currency or use it like parseFloat(frm.doc.basic_salary) and so on for all component

9

@Hardik_Gadesha
I put the type ReadOnly

image
image1922×1030 86.2 KB

10

@Nada-86 asking about the input field on basic_salary, transportation_allowance, housing_allowance

11

Ohh yes Data

12

yes Data

13

@Nada-86 try with given solution

14

2023-12-06 (16)
2023-12-06 (16)1922×1030 45.4 KB

image
image1922×1030 101 KB

15

@Hardik_Gadesha
How can I use this?
parseFloat(frm.doc.basic_salary)

16

@Nada-86 parseFloat() - JavaScript | MDN

17

@Hardik_Gadesha

frappe.ui.form.on("Definition Of Salary", {
     return parseFloat('total_salary');
     
    refresh: function (frm) {
        calculate_total_salary(frm);
    },
    basic_salary: function (frm) {
        calculate_total_salary(frm);
    },
    transportation_allowance: function (frm) {
        calculate_total_salary(frm);
    },
    
    housing_allowance: function (frm) {
        calculate_total_salary(frm);
    },
    refresh: function (frm) {
        calculate_total_salary(frm);
    }
});

function calculate_total_salary(frm) {
    frm.set_value("total_salary",(frm.doc.basic_salary + frm.doc.housing_allowance + frm.doc.transportation_allowance));
}
18

@Nada-86

frappe.ui.form.on("Definition Of Salary", {   
    refresh: function (frm) {
        calculate_total_salary(frm);
    },
    basic_salary: function (frm) {
        calculate_total_salary(frm);
    },
    transportation_allowance: function (frm) {
        calculate_total_salary(frm);
    },
    housing_allowance: function (frm) {
        calculate_total_salary(frm);
    }
});

function calculate_total_salary(frm) {
let total_salary = parseFloat(frm.doc.basic_salary) + parseFloat(frm.doc.housing_allowance) + parseFloat(frm.doc.transportation_allowance);
    frm.set_value("total_salary", total_salary);
}
1 Like
20

@Hardik_Gadesha
You are the best always and forever :star_struck: :heart_eyes: :smiling_face_with_three_hearts:
Thanks :pray:

1 Like
21

@Hardik_Gadesha
I have a question can I use this in child table?