Hi,
I'm trying to create a saved search for reminders for processing by our procurement team who raise receive and fulfil all special order PO's on Inventory & Non-Inventory items.
In order for them to have a list of sales orders they are working on, I am trying to create them a saved search that meets the following criteria:
- Show only Open Sales orders where some or all lines are pending fulfilment
- Show sales orders that have service items and inventory and/or non-inventory items
- DO NOT show sales orders that have ONLY service items on them, as there is nothing for procurement to do with these and they are clogging up their list...
I started with the below base criteria
If I start adding criteria on "Item : Type" or on the filters it doesn't seem to affect the records. So if I say "Item : Type" is not Service, as below, it still returns the same number of records. And it still includes records with service items on.
Appreciate any support with this or a reset if I need it to come from a different angle. Filtering records by their type was something I thought was really going to help define what work is required from each department, rather than everyone seeing everything which is how it was pre-netsuite.
Many Thanks,
Chris