Custom script for taxable income

ERPNext
1

Hi Good Day how can i make a custom script for salary slip by creating a field name taxable income that is based only on earnings plus specific deductions like deduction 1 , deduction 2 deduction 3 is this possible? Thanks in advance kindly refer to the image below

20200226_163034
20200226_163034459×816 93.1 KB

1 Like
2

You can use somthing like this code:

frappe.ui.form.on('Salary Slip', {
    validate: function(frm){

        var total_deduction = 0;
        $.each(frm.doc.deduction || [], function (i, d) {
            if (d.component in ('Deduction1','Deduction2','Deduction3') ) {
                total_deduction += flt(d.amount);
            }
        });

        frm.set_value('taxable_field', frm.gross_pay+total_deduction);

    }
});

Edit field name

3

Okay Omar… i will try this later and il give ylu a feedback thank you soooool much for guidance and instruction.

4

Hi Sir do i miss something kindly check the screenshot below i try to create a custom script under salary slip and place your code. But it seems it doesnt work. My field type name under salary slip is taxable_incomes under Float type. Should i change something? Thank you.

20200226_181326
20200226_181326459×816 93.6 KB
20200226_181343
20200226_181343918×1632 271 KB

5

child table name is deductions not deduction
component name is salary_component

I write test code, you need to check actual fields name

6

Okay im going to check it since this is my first time uaing custom script. Thanks again.

7

Hi yhenn. Did you fixed the problem?