Hi All. Trying to write a script in 2.0 which does the following:
▪️ After entity bank details for a vendor are saved (where the type is primary and inactive is F), update a custom field on the vendor with the last 4 digits of the account number.
The idea is that our AP team can enter the last 4 digits of the vendor bank account number when entering vendor bills, and we can have an alert via saved search if we ever enter a bill which has different bank details to what we have on record.
I feel like this should be doable via either a workflow or via a saved search which links to entity bank details, but unfortunately I can't get a search to link from transaction to entity bank details, and my attempts at a workflow weren't updating the field on the vendor (this may be a pretty basic misunderstanding on my part).
With the above in mind, my approach so far is a Userevent script on the entity bank details record (aftersubmit) but I don't see how to update the vendor. Do I need a record.load? And is there an easy way to identify the script id of the parent vendor field on the entity bank details record?