Our AR team are processing payments through ACH for some of our customers, with the customer filling out a form for what ACH they want to use for these payments - some of these customers have multiple ACH or credit cards, and are able to change their default on our SuiteCommerce site, so AR can't depend that the default payment method will always be the same as the one on the form.
I want to create a custom List/Record field, where I can save a Payment Instrument/Automated Clearing House record in that field. The problem I'm having is that there is no way to source the list of payment instruments for just that customer record through the native NS sourcing/filtering - it just shows ALL payment instruments we have in our system.
Is there a way I can source the list of payment instruments from the customer record with a custom field natively? Or would I need scripting for this?