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.

Thanks.

1 Like

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

1 Like