Automatic change of Contract end in Employee doctype if contract renewal Doctype is Approved

ERPNext Customize ERPNext
1

if doc.status == ‘Approved’:
# Update the contract_end_date in the Employee doctype
frappe.db.set_value(‘Employee’, doc.employee, ‘contract_end_date’, doc.contract_end)
frappe.msgprint(‘The Contract End Date in the Employee record has been updated successfully.’)

This is the server script i ran . I want when the Contract Renewal Doctype is Approved the Contract end date in the Employee Doctype to change to the new contract end in the Contract Renewal. But its not working , Anyone who has an idea or view or any kind of help.

2

Hi

have you applied workflow on Contract Renewal Doctype?

3

Yes I have

4

What is the final state of workflow?

5

Pending from MD

6

On which state you want to update the date in Employee list?

7

After the State is Approved

8

So, Your server script will be

if doc.workflow_state == "Approved":
    emp_doc = frappe.get_doc("Employee",doc.employee)
    emp_doc.contract_end_date = doc.contract_end
    emp_doc.save()
    frappe.msgprint('The Contract End Date in the Employee record has been updated successfully.')
9

it has some how worked most especially the frappe.msgprint message . But the
contract_end_date in the Employee doctype has not changed.

10

try this edited code

11

Am talking about the one you shared

12

I updated the code

if doc.workflow_state == "Approved":
    emp_doc = frappe.get_doc("Employee",doc.employee)
    emp_doc.contract_end_date = doc.contract_end
    emp_doc.save()
    frappe.msgprint('The Contract End Date in the Employee record has been updated successfully.')

Have you tried this code?