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!
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