I am having a doctype named Material Details. In Material Details there are fields named item_code and agile description. label is Material and Agile Description respectively. I have linked my item_code and agile description to many doctypes.
Now My requirement is like, While importing new records in linked doctypes I want to check whether the material exists are not, if exists check the agile description.If it is not same, update values of agile_description to the file same to Material Details Agile description.
Example: I am importing new records to SCM Material Details, while importing 15 material is having different agile description compared to Material Details doctype.
That 15 material’s agile description should get updated in SCM Material Data.
While importing for all csv my column name is Material and Agile Description.
Is there any way to achieve this?