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

<@U86RW6Q92> As <@U5TF1GQ20> mentioned you can use `Applying` or `Applied` to transaction join and is also relevant to know that the Sales Order `line` = the fulfillment `orderline` .

Thanks. Do you know what the fulfillment orderline would be called in a search?

Depending on your use case you may not be able to do this in one single search and you may need to create a Map Reduce to do an initial search and then in a different stage do a search per fulfillment or Sales Order.

:confused: Wasn't that the whole question how to do this in a search?

And my answers is that depending on what you need it may not be possible to do in a search I don't know enough details about what do you want to do to be able to tell you.

it depends on if what sort of items you're using, i'm saying explictily for those item group, or assembly item scenarios, you might want to use a field common to both SO and IF so that when it transforms it's brought over

the orderline of an item fulfillment record is equivalent to the applied to transaction's line id in an item fulfillment search

<@U5TF1GQ20> But everything I am doing is through a search and it doesn't seem that orderline is available in a search is it?

records and searches dont need to share data, or even have the same data represented under the same name

you will only find the orderline field on records

however, the data it represents can be found in a different place in searches

&gt; however, the data it represents can be found in a different place in searches
What do you mean by this?

the value of the orderline can be found in the applied to transaction join's line id column

mostly because the applied to transaction join on an item fulfillment represents the matching order line

you have to share both your criteria filters and result columns