Separating Statuses for Sales Orders vs Purchase Orders
It is very confusing for users to filter on a status field when the list of statuses includes ALL statuses for ALL transactions.
How do we segregate the various statuses so that the user is no so confused and can actually filter based on a status related to the transaction set that they querying?
If you have a consolidated list of statuses shared across all transactions types, you could create a custom list field that has those statuses. Then you could map the native NetSuite status fields to the custom list/dropdown with a submit workflow or script. Once you have that in place you could add this as the filter for your searches to reduce the noise your users are currently experiencing.
Is there a way to limit the listing in the filter to be only the ones relevant to that particular transaction type being queried? Users get confused if they see ALL statuses including those NOT related to the transactions that they are querying.