I'm hoping someone can help.

We are a NetSuite OneWorld customer with a bunch of locations. We are also trying to do inventory counts. We have a huge number of skus because of our business.

Several of our users are trying to create inventory counts just for their location. In the header level, they select the correct company and the correct location. They select the start and end dates.

The problem, and this is huge, is that it returns every single item across the company that falls within that date range. For example Widget A is used in location A. Location B goes to count their inventory. They go to the Create Inventory Count screen and enter in all of the parameters. Widget A shows up on the list even though it's never been at this location.