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.
How do I filter the Create Inventory Count page to only include inventory items at the location selected in the header? If you add department or location as an additional criteria, it displays nothing. If a user has the "count bin rows with zero quantity" checked, it's possible to count and approve and therefore create an IA for an item that was never in that location to start with.
Anybody have any ideas?
Thanks,
Elizabeth