Hi, Any suggestions for how I can filter my Items...
# administration
s
Hi, Any suggestions for how I can filter my Items sublist - dynamically - based on a Sales Order list selection? I have a Saved Search that applies a static filter, but we still have way too many fees to sort through. Intended outcome: 1. User selects "Option 2" from custom list on Sales Order (main) 2. The available Items should be filtered to show only those items that have "Option 2" selected (custom multi-select field on the item record) Thank you for your time and consideration. Workflow or SuiteScript will suffice.
b
you will probably have an easier time filtering the select options of a custom field that you copy over to the item field
gives you options like using filtering on a custom field
or adding a scripted field and inserting your own select options
s
@battk Just to confirm, I would create a custom item field/list (duplicate) appy a filter against that, and then copy the user selected value over to the native NetSuite item sublist field? Assuming I don’t have this wildly wrong, how should I handle the native item sublist considering it can’t be hidden? Thanks again. I really do appreciate your help.
b
i personally would just leave the item field unchanged if someone wishes to go through your items
otherwise you can modify the field in a user event script or client script to disable or hide it
you may end up having to do it in a client script since netsuite has a tendency to override the display options of fields it uses for sourcing
s
Okay, that works. Thanks again.
138 Views