CODEWITHSUNDEEP
listnetsuiteinvoices
Dumitru Daniel
Dumitru Daniel

Reputation: 543

Netsuite Saved Search a list of ID's by invoice No

I have a request to extract specific Invoices, over the course of an year. For target invoices i have the following information to use: Invoice Number, Invoice date, Order Ref, Value and currency. I tried extracting few months at a time, but it's too much data.

Is there a way to filter on about 200 unique Invoice No in Netsuite?

Thank you, Daniel

Upvotes: 0

Views: 1449

Answers (1)

Mike Robbins
Mike Robbins

Reputation: 3287

You can do this with a Formula(Numeric) filter in your criteria like this:

Filter: Formula (Numeric)
Description: is greater than 0
Formula: INSTR(',SLS00000101,SLS00000102,SLS00000103,SLS00000104,SLS00000105,', ',' || {tranid} || ',')

Note that the initial string is a comma separated list of document numbers that begins and ends with a comma.

I'm not sure if there is an upper limit on formula size, but I've used this pattern to find a large number of transactions when I know the document numbers or internal IDs.

Upvotes: 3

Related Questions