RE: Source a customer record field into another custom record field
Hi I have 2 custom records:
Record A has Customer (list), Item (list), Customer Code
Record B is a packing list and has Customer (list),Item(list), and a lot of packing related field. I want to pull the value from record A where Customer and Item are equal in Record B. I thought I might be able to achieve this with Sourcing but I do not seem to be able to get the required value. What is the best way to achieve this?
Thanks for the clarification. Unfortunately, I don’t think any of the standard tools are actually going to help with this and so it is likely to require some level of scripting.
Very happy to discuss that option too if it’s something you are able to progress with.