Add new field fetching value from other document

Is there any way to add a new filed in a doctype and fetch the values from other document.

I’m trying to:

  1. add a new field, “Cost Center”, in “Payment Entry Reference” table of “Payment Entry”
  2. While adding the field, value should be fetched from Sales Invoice of that row (mentioned in reference_name)

I tried these options but it didn’t work:

Is there any way to do it through bulk update by keeping the field “Allow on Submit” instead of just filling the values at the time of field creation.

Can Bulk update fetch value from other documents, if yes then how?