There is a native Key Performance Indicator in Netsuite for "Inventory"...you can put it in your Key Performance Indicators portal on your dashboard and set 2 time frames to compare. EX: Inventory Today vs Inventory last month.
I want to see a KPI just like that, but for AVAILABLE inventory, because at any given point in time, we may have 100-150 orders "pending fulfillment" because they are partially comitted, waiting on other parts to come in to complete their orders to ship. That means a considerable portion of our inventory is actually already sold, at all times. So i would like to view an "Available Inventory"
I created saved search that sums up the value of all the available inventory i have by summing the products of the qtys and purchase prices, but it can only show the "current" available inventory value, i cant filter by date ranges since theres not really a date involved with the list.
Does anyone know a better way to do this?