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
battk
07/10/2021, 11:29 PM
you will probably have an easier time filtering the select options of a custom field that you copy over to the item field
battk
07/10/2021, 11:30 PM
gives you options like using filtering on a custom field
battk
07/10/2021, 11:32 PM
or adding a scripted field and inserting your own select options
s
Suite Deal
07/11/2021, 2:34 AM
@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
battk
07/11/2021, 2:45 AM
i personally would just leave the item field unchanged if someone wishes to go through your items
battk
07/11/2021, 2:45 AM
otherwise you can modify the field in a user event script or client script to disable or hide it
battk
07/11/2021, 2:48 AM
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