Hello intellectuals, hope you are doing well, I want to source this item field from country of the preferred vendor on item record ? What I am doing wrong ?

im not sure if there is a country you can source from

I believe the Type and the Source From fields must be of the same type (i.e., List/Record instead of Free-Form). If this does not solve the problem, avoid sourcing from the main field to a line field or vice versa. Also, normally, if you check the store value, that field will not be automatically updated when the country is changed in the source record (anw, it is not common though to change one's country's address but it's not a good practice if you want it to be always linked with the vendor record).

Main problem is, I cannot change the type of field , as this is the old field and will lose value, if I change that. there are 40000 records approx if I do that. I am thinking to do this using workflow now.

You can try changing first the Type Field in the header portion to List/Record. I believe the Country (Name) is a standard field (correct me if I'm wrong) that is of a List/Record type. You do not need to adjust the Source's type but only the type of the custom field. (Before you use workflow, this should work provided they are not main to line or line to main sourcing)

I was talking of custom field only.

Oh so this custom item field has been in use already in ~40,000 records? And you're just updating the same?

yes

this works for me:

does it give you name of the country or just country codes ?

so I'm bringing back the abbreviation of the country...I'd have to see if name is available

does it work when preferred vendor changes

Not unless you had some script that said to update it when the preferred vendor changes

Then workflow is working fine.

yeah, workflow for updating...this for creating

I know scripting is better and faster than workflow. but I don't want to do that 😄

I always want workflow to be the answer...99% of the time i hit something, scream fuck and having it scripted

😄