Discussions
Upcoming Change for Numerical Field Value Comparisons
As of 2019.2, we have fixed an issue that occurs for workflows with conditions on actions containing client triggers that compare two numerical fields, such as decimal, integer, and currency fields. Currently, when a condition executes on client triggers to compare two numerical fields, the field values are treated as strings by the system. Instead of comparing fields’ numerical values, the system reads fields alphanumerically, character by character. As a result, the system may be returning incorrect results.
See the following table for an example of how the system used to treat strings:
| Condition in Workflow | Field Values | Expected Results | Actual Result |
Regards,
@Robert Nedelkow-Oracle | NetSuite Support Community Administrator
Save the date: Join us for invaluable insights from ADMINISTRATION/CRM expert Mich Jabanes this coming NOVEMBER 19, 2025 - 1:00 PM TO 2:00 PM EST for Ask A Guru Live. RSVP and follow #AskAGuruLive for insights.
In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the most out of their NetSuite journey. Click here for more details.
