Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Inventory item last count date by location
Hello
I'm trying to build a report by location to show the number of items not counted within the last 3 months and then be able to drill down and see these items.
I have been able to create a report using an item saved search and using the location last count date. However, I'd only like to include the counts that have been approved and not anyanother status. Is there a formula I could use?
The issue I have is, we circulate various stock counts every months, but they don't always get counted and approved. The counts then get deleted and circulated again. I need a way to identify the items that aren't getting counted at each site.