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

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



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.



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



You can use add_fetch for this
please check this post