Hi,
I'm trying to do a saved search which I thought would be relatively simple, but for the life of me, I can't figure it out. I've searched around online and the forums, but in some ways I'm not sure exactly what I'm searching for in terms of questions. What I am trying to do is search for open invoices based on a specific list of invoice numbers. Now I don't need ALL open invoices, just the select ones from my list. The numbers are not in consecutive order and jump around and some that I don't need are in between the ones I do. I'm going through hundreds of invoices which is why I only want the ones on my list to show up.
I currently have my criteria set
name: customer name
status: invoice: open credit memo: open
document number: is between 3000 to 6000
the between criteria sort of works, but doing it this way does give me invoices I don't need. Ideally I'd like to be able to copy paste from my list into the criteria.
I'm not sure if this is doable just via the criteria menus or if I need to do a formula. Getting into the formula aspects of Netsuite is a bit overwhelming for me as someone with no prior coding experience and would appreciate any help with this!