I have an issue with a formula case statement in a NetSuite workflow, I am using the same case statement in a saved search and it works just fine, but generates an error in the workflow formula for sourcing date, to set the date field on a cashsale record created from a sales order. NetSuite formula which basically states if
Tag: netsuite
TRIM or REPLACE in Netsuite Saved Search
I’ve looked at lots of examples for TRIM and REPLACE on the internet and for some reason I keep getting errors when I try. I need to strip suffixes from my Netsuite item record names in a saved item search. There are three possible suffixes: -T, -D, -S. So I need to turn 24335-D into 24335, and 24335-S into 24335,
NetSuite ODBC Limitations
I’m trying to find out if anyone is aware of any list of the limitations of NetSuite’s ODBC SuiteAnalytics Connect Service being used through OpenQuery? I’ve been running into many problems with some of my more complex queries failing for no apparent reason, and I finally started narrowing it down to some sort of strange limitations that I wasn’t expecting
Need to parse a date range location in a field to two SQLStatements
Have a custom field that contains a date range in the following format: What I need to do is separate this one line into two different fields, the first selection/range and the second range, so if you take the screenshot I need it to be separated to 3/16/20 for one field and 3/22/20 for the other field. Currently I have