How To Make Custom Field Link to other fields in Sales and Purchase Items

[ekpott]

I have created a custom field and I need it to interact with other items just as Item code automatically fetches the respective values for Item name and description.

Also, I need to allow the custom field, “Manufacturers Part No.” to be searchable just like item code is searchable.

This is relevant for the following doctypes:

• Purchase Order Item
• Purchase Invoice Item
• Sales Order Item
• Sales Invoice Item

@OmarJaber @tundebabzy @olamide_shodunke will really love your inputs.

Thanks.

[OmarJaber]

The Item code field in such child tables is linked to Item doctype

The type of field is Link and in options, you can add the linked doctype you want

[ekpott]

[OmarJaber]

You can use add_fetch for this
please check this post

Custom script - fetch data

@max_morais_dmm add_fetch does work for child tables! Try item_code instead of item cur_frm.add_fetch('item_code','nombre_de_venta','nombre_de_venta')

Add_fetch using frappe.ui.form.on instead of cur_frm

Here is a good example of how you’re supposed to do it now: