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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
BUG: Numeric Formula Does NOT Sort Correctly
A Summary Saved Search does NOT sort correctly when the SORT field is a numeric formula in which you have
[LIST]
[*]Summary Type = "Sum" and
[*]Function = "Round".
[*]Formula = "{AmountRemaining}/1000" in this case, but I would expect the bug to exist regardless of the formula.[/LIST]The formula calculates correctly, but sorts like the field was a character field, not a numeric field.
This BUG has been reported to NetSuite and reproducted by the NetSuite support rep. However the Support rep would NOT submit it as an issue because I did not have the time to do a WebEx so he could see the same bug in my account that he had
0