This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I want to print the items of certain transaction in suitelet but the search is not working probably ,does anyone know what cause this problem

I want to print items of certain invoice using suitelet but i have a problem with the search filter i can’t do it

The problem is that some results return more than one time i don’t know why 

or at least the filters and columns of the search

It is repeating and i tried mainline is t it didn’t work

unusual for an invoice search, more normal for things like item fulfillments

id make sure that your internal id is actually an invoice

otherwise, recreate the search in the ui so you have an easier time of seeing your data

i guess if its a standalone invoice, it would have the same accounting impact of a item fulfillment

which probably means you want a filter to exclude the COGS lines

build it in the UI and export it, is the easiest way

its easier to see which filters and columns you have access to

you'll want to exclude `taxline`, `cogs` and `shipping`

`var transactionSearch = nlapiSearchRecord("transaction",null,`
`[`
  `["taxline","is","F"],` 
  `"AND",` 
  `["cogs","is","F"],` 
  `"AND",` 
  `["shipping","is","F"],` 
  `"AND",` 
  `["internalid","anyof",recid]`
`],` 
`[`
  `new nlobjSearchColumn("item"),` 
  `new nlobjSearchColumn("quantity"),` 
  `new nlobjSearchColumn("rate")`
`]`
`);`

I want to print the description of each item also what is its id