Hello everyone!
As you have been using NetSuite, you may have asked yourself, “is there anything we can do to help us keep track of our inventory and where it is located?” Today, I wanted to walk you through the Available to Sell by Location Portlet and how you can create this yourself!
Check out the 6-minute tutorial video below on how you can create this saved search for yourselves:
You can also copy paste the formulas from here:
On Hand Formula: NVL({locationquantityonhand},0)
On Order Formula: NVL({locationquantityonorder},0)
On Sales Order Formula: NVL({locationquantitycommitted},0)+NVL({locationquantitybackordered},0)
Available to Sell Formula: NVL({locationquantityonorder},0)+NVL({locationquantityonhand},0)-NVL({locationquantitycommitted},0)-NVL({locationquantitybackordered},0)
Have a custom item search you created that you found helpful? Feel free to share that with others in the comments below!