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