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.
Compare summed value with non-summed value in summary criteria.
Hi,
Is it possible to do a comparison between a summed value and a non-summed value in the criteria summary fields?
For example:
Search Type: item
Search Summary Criteria: SUM({binonhand.quantityonhand}) > {somecustomitemfield}
Search Results: Name (Group)
It seems like to be able to do this you would need to be able to input {somecustomitemfield} into the "VALUE" field of the summary criteria. Unfortunately, it only allows for numeric input.
Thanks!
0