Hello,
Our food industry manufacturing/distributor business is hoping to use NetSuite for all factors in inventory management of raw materials. This includes setting preset re-order points, restock amounts, and other required fields;managing inventory count and alerting when new orders are placed or need to be placed; and having the system consider all variables needed to make this happen.
I am looking for a report, formula, set up...whatever it is that
suits best, that will allow the NetSuite system to automatically track, alert, and re-order materials when they are needed.
The reason that this has not worked yet is because, so far from our activity, NetSuite isn't factoring in future production while also including orders that have already been placed/queued.
For example, an item/ingredient is running low and falls below its reorder point. As a result, each time there is a transaction with this item, NetSuite alerts that it is below the reorder point. However, this item already has x number of orders queued in succession during the upcoming weeks but NetSuite is not registering those orders into account.
This leads towards the second half of this puzzle. In order for this to be effective, there needs to be a way that NetSuite will factor in future production alongside these queued orders so that the inventory isn't at a shortage or surplus. Otherwise, NetSuite would assume that there will not be enough demand/production and as a result the system will not order the necessary amount of materials.
This scenario above doesn't factor in that I want to use NetSuite in a way that allows it to automatically create PO's THAT NEED APPROVAL based on the information I will preset. The goal with this is that when NetSuite sees the low inventory it will create a PO for the restock amount. I want this PO to require manual approval still so that it can be managed of course.
How do I make this happen in NetSuite? After reading many articles I truly believe this is possible within the system but I have not figured it out on my own sandbox.
I hope this explains my concern. Thank you.
-Q