We have fields created on the sales order that hol...
# general
k
We have fields created on the sales order that hold a customer’s third party shipping account information, these autopopulate from the customer’s account. I am trying to figure out how to use a multiselect field/list (or something of the sort) to be able to select from when a customer has multiple shipping accounts (they designate on the PO which they want to use at that time) . When the different account is chosen, I want it to change what populates into the current created third party shipping fields (carrier, account #, billing address, ect… ). Can anyone explain to me how to make this happen in layman terms?
d
Depends on how you've currently got it setup, I'll layout my presumptions and potential solution. • I presume all the 3rd party ship info are entity/flat fields on the customer record, as opposed to being in a custom record. • I'm presuming also that the 3rd party ship info is unique to each customer • I'm presuming there isn't a 1:1 relationship between the customer's 3rd party shipping account/info and their shipping address(es) (it's simpler if this is the case)
One potential solution is to: • move the 3rd party ship info into fields on a custom record and add an extra field for customer (record as parent). • Then you can add a transaction body field to the sales order (list/record type with your custom record). In the sourcing tab select customer = customer as a filter (screenshot below) • Then edit your current 3rd party shipping fields (transaction body fields) and change their sourcing to be the relevant field from the custom record you added above (again, screenshotted below)
I mentioned my presumption was that the 3rd party shipping info wasn't a 1:1 relationship with the customer's shipping addresses. If it was, you could follow the same instructions, but use custom fields on the address record instead of a custom record. if you have any questions, or any of my presumptions were wrong, please let me know