Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
NetSuite has launched SuiteSuccess Wholesale Distribution Edition, in Japan. Please join us the webinar on February 12 that introduces NetSuite solution with demos and case studies for Wholesale Industry.
Register Now
Have questions or experiences to share? Post your Release 2026.1 questions and join discussions in the Release 2026.1 category.
Formula to Show Qty on Sales Orders in Inventory Report
We have an inventory report we use to see overstock qtys. I discovered yesterday that the formula is not returning the correct results.
This is the criteria:
This was the original results and formula:
Based on that, the results were returning this:
The test item I am using as comparison, should actually show 159 on sales orders and 122 backordered.
So then I thought I could use the formula from the item 360 bundle that shows the qty on SO's.
It returns some information but it is still not accurate.
Any help from the Gurus out there would be greatly appreciated. I need to have a report completed for Management by Monday. I can always back in the correct data outside of NS, but I use this report a lot and would like to find a solution that doesn't involve extra work. Thanks in advance! :)