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.
Formula to Display On-Hand Count with Units
If you maintain inventory as both NetSuite Inventory Items and Assembly Items, then you will know what a challenge it is to produce a saved search (or report) that shows you the current on-hand count with the UNITS also displayed.
For Inventory Items, the On-Hand units are always the {StockUnit}
For Assembly Items, NetSuite does NOT support any type of Units of Measure. So we have created several custom fields to record the units for AI. One of these is {Base Units}.
Here is a formula that will display the on-hand quantity with units, and will work for all Item types:
0