ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

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

customization
customize_form
custom_field

#1

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.


#2

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


#3


#4

You can use add_fetch for this
please check this post