Adding last posting date in Employee doctype

hello,
I am trying to fetch the last posting date field from Salary slip doctype to a custom field in the Employee doctype, I tried to put “salary slip.posting_date” in the fetch from property but it is not working,

by the way I already did the opposite an added “Employee.mother_name” in Salary slip an it worked fine

You have to provide the reference of the salary slip.

It worked in the other example because the Salary slip already contains Employee field so the system knows where to look.

You will have to write a server script to fetch last salary slip of that employee and get the date from that.

thanks @kennethsequeira ,
I was trying to avoid the server script and hoping there is some workaround solution, but I guess I have to do it this way :expressionless: