Hi all, I have a problem with sourcing fields on a "nested" custom record for shipment containers on item fulfillments. I have a custom record "Container" that is associated with a shipment via an "Item Fulfillment" field. Then this Container contains a list of custom "Container Details" records with information about each item/qty etc. The Container Details record contains a field for "Associated Shipment" which currently sources from source list "Container" and source from "Item Fulfillment", and then another field for "Item SKU". The "Item SKU" field is what is having issues. Currently, when a user in the UI goes to create a Container Details, the dropdown list for items gives them the option of selecting ANY item in their NetSuite. Ideally, this field should be filtered down to only the items which are actually on the associated shipment. Currently, "Item SKU" has source list "Associated Shipment" and source from "Item" but this isn't doing the trick. It seems no filtering is being applied to their Item SKU dropdown. Any solutions or ideas why this doesn't work? lmk if there is some clarification that I can provide, I know the hierarchy/explanation is a bit confusing.

This wouldn’t be possible using native sourcing functionality. I think this would need to be a scripted field You can only filter by fields that are present on the item record so a script would be needed