I have not quite got the hang of saved searches in NetSuite yet. It is a work in progress. I have searched SuiteAnswers, but I have not found what I am looking for yet. I was hoping somebody on here would be able to point me down the right path.
A little background, we are a manufacturing warehouse. We use assembly items made up of individual inventory items. We also use kits made up of inventory items. We are just now starting to work with time phased ordering. We have been using replenishment in the past, but feel time phased is going to be much better for us.
To verify that the time phased ordering is working for us, we would like to have a report that shows all items sent out the door over a time period. Most likely this would be over a month's time.
The problem I have been experiencing is not knowing if the saved search I have been using is taking all of the inventory items within assembly items and kits into account, or if it is just the assembly items and kits it is counting. Most of the inventory items that are in the assembly items and kits also get fulfilled on sales orders by themselves. We, obviously, purchase all of the inventory items by themselves to build the assemblies and kits.
What do I need to be looking for to make sure the saved search is showing us accurate data? We need to verify that everything is calculating correctly for time phased ordering before we fully implement it. The last thing we want is to rely upon it and then find that we constantly run out of stock of items we need.
Any assistance would be greatly appreciated. Time phased ordering is going to automate our cumbersome manual ordering process. We just need to verify that the data being populated when we run the plans is accurate and will keep us in stock of the items we need. We are setting up all items with safety stock and other necessary items, so that is not an issue. Just seeing an accurate movement out of all items is where I am getting stuck.