I am adding a custom ‘Supplier’ field in Material Request Item. But when i try to create the material request from Production Plan, there is an error and the values do not transfer automatically. Is there something i have to do in the backend?
Because Material Request Item is Separate Doctype and Material Request Plan Item is separate Doctype and In Material Request the doctype used is Material Request Item and the Raw Materials table shown in image used Doctype is Material Request plan Item. Hence the Error Came Because you added supplier field in one Doctype but not in Other.
I am not sure what kind of script i have to add for this. Do i have to modify the logic that handles the ‘Material Request’ button in the erpnext code directly? Or can i use client/server side scripting to map the ‘supplier’ value in material request plan item to material request item.
In one DocType(Any of Material Request Item or Material Request Plan Item), add a Link Field . In the other DocType, add a Data Field and use the Fetch From option to automatically pull data from the first DocType. Specify the source DocType in the Fetch From field and select the specific field you want to fetch data from. This setup ensures seamless data retrieval between the two DocTypes.