Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Search Transactions on Item Commitment
Has anyone figured out how to "Find all sales orders that have items still committed"?
I'm trying to pin-point some orders that may be affected by the kit-commitment bug (such that the order may show simultaneously as fulfilled and still committed) and I was hoping to avoid having to page through hundreds of orders by hand. A simple search that could show any sales order that had items still committed would be handy.
My first attempt at a search was
type: sales order
item: committed > 0
This search yields thousands of sales orders that are properly fulfilled and closed, with nothing remaining committed. (It seems that 'item: committed' is treated as the total number of that type of item committed across all sales orders, not just on the individual sales order.)