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

How to get the transaction line item location on the saved search report?

If it is a transaction search, then `location` is the field you need.

`Item` search and `Inventory` search are different.

Thank you for your reply.  It is a transaction search, but the location is giving the main line location.  I want the line item level location.

Do you have the filter for `Main Line: False`

image.png

Just tested it, runs as expected:

1. The Sales Order form has location on header and item lines
2. Create a Sales Order with different locations
3. Create a Transaction Search for that specific Sales Order, to test it
4. Select a single column in the Report: Location
5. Run the Saved Search, it returns the Location at the item line level