Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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