Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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.
Tagged:
0