Hey everyone, I have created a custom line field that displays at the line level in the sales order, and I am sourcing it from the item record. However, I want to apply one conditions, such as if the item name exceeds 60 characters, then I don't want to show characters after 60 in the sales order I only want to show upto 60 characters. I have written this formula for that, but the custom field is still showing more than 60 characters. Below is my formula. SUBSTR({custcol_ei1_so_descriptionforpo}, 1, 60)

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you are trying to limit the character count of a custom field in a sales order to 60 characters. However, your current formula

SUBSTR({custcol_ei1_so_descriptionforpo}, 1, 60)

is not working as expected. One possible reason could be that the SUBSTR function is not supported in the context you are using it. NetSuite has some built-in limitations and peculiarities when it comes to handling strings and formulas. As an alternative, you could consider creating a new custom field with a formula that truncates the string to 60 characters. However, please note that this might not be possible directly in the field settings and might require SuiteScript. Another workaround could be to handle this at the script level. If you are using SuiteScript, you could use JavaScript's substring method to limit the string length to 60 characters. Please note that these are suggestions based on the information available and might not work in all scenarios. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******