karenn Green Ribbon

Hello, Yes I saw the message and find it very frustrating that NetSuite decides to end support before they finish mapping all the data we currently have to some new place. It make it VERY hard to have everything ready for when they totally remove NetSuite.com next year. We have many things to change and a lot of other…

Figured it out. where isinactive is in 2 tables so where clause causing issues

No. We just rebuilt the existing one

Yes I was, thank you. Sorry for the delay. We came to the same conclusion that it is not possible, which seems to be quite a hole in the design of this in NetSuite. We ended up just rebuilding the list via import Thanks

Yes we received the reply. Did not answer my original question but may triggered us to look at the ODBC connections to make sure everyone was updated. Was originally wondering how we find apps that are still using NetSuite.com instead of NetSuite2.com without having to look at every app. Thanks

I am not sure what more I can give but I'll try, Create a Transaction Line custom free-form text field for Sales Orders. Source it from the Item Manufacturer Country. Does not set the value to the items manaufacturer country if sales order is created via website and yes we are using NetSuite for the website. If created via…

Thank you for the reply but I have a question. Why does it fill in the full manufacturer country, which is what we want not the customer country btw, when it populates the default as it is supposed to? It is because it is not filling the default sometimes that we need the workflow to fill it in. We have no idea why website…

We had the folder limited to IT(MIS) department but I had removed from the sub folder and even the SuiteScript folder to see if that helped but it still would not upload or create files. If you are able I am not sure what is going on. Thanks

I select "SuiteCloud: Upload File" from the command palette. It says the file will be overwritten and I select continue. While the pop ups say completed if you look at the output it says the following 2023-08-17 11:20:28 - Production V2 The following files were not uploaded: /SuiteScripts/PE Scripts…

Honestly I rarely find them to be helpful. They just make me check what I have already checked and done

Not a folder restriction issue it seems. Removed any in our sandbox account to test and tried to create a file in the SuiteScripts folder and that does not work either. I get the following: The file cabinet path "\\SuiteScripts\\pe2_ss_test.js" is invalid. It must refer to a file in a "/SuiteScripts" folder or in any "/Web…

Yes I had seen that and I am trying to find out if it means you cannot upload to a SuiteScript subfolder which is how we organize our scripts. Thanks!

How do you know a record was just saved in the beforeLoad function? Yes you want to check for "view" but you do not want the message to always appear in view mode. How do you check to only show message after a save?

Thank you. Seems so counter intuitive and missed it if that was specified in documentation. Might need to make things a little clearer there. Thanks!

Interesting. That works but why can we no longer simply use the "Amount" field? Thanks for the help!

Sorry Ben. With this change to this useless Oracle Support Group now I had no idea you asked. And sorry but no.

Thanks Scott. Our drivers are updated and this issue was only with queries that included dates. All other queries were functioning properly

FYI to anyone else that runs into this issue, it requires a to_date() now

NO NetSuite support. Team dealing with them on other unpublished issues after upgrade so I was on my own with this one. Not s sure what is going on but as soon as I fixed queries to use to_date() things worked on each app. All I know is 2018.1 is bad news so far

Thanks! This helped. 

Yeah, the only way we can get it to download is to remove the criteria but then the filter does not work

Permissions are all fine. Just an issue with this one search and under certain conditions. The search has a filter for item numbers, Since we have over 20,000 items, the search filter cannot be ont eh item because the select field size is limited. We instead have to use a formula text field. When this is left blank the…

No we are all in the same region. I know we have had some issues with NetSuite this afternoon being up and down. Maybe I will see what happens tomorrow. Thanks David. Appreciate the help.

Hi All, The fields are finally showing up the morning as a criteria option. Thanks!! Karen

Hi David. No this is production and has been a few hours now. I thought about a delay but I have never dealt with it being delayed this long. And the box to store the value is checked just like the other field. This just weird. In fact all three of the custom fields we just set up are not showing up. the one date field and…

Thanks all! Looks like we need to move to 2.0 sooner rather than later

Ooops. ok, all lowercase and now I see my date in there for a second but then is over written by the current date so I changed from "fieldChanged" to "postSourcing" and all is good. KNEW it had to be something simple. Not sure where I saw the upper/lower. Must remember lower case!!! Thanks SO much!!!

HI JP, Yeah that is what I thought but no go when trying to put it into that date field or any custom field. I have tried many things and nothing has worked. One thing, this is a column in the current sublist line the user is adding so instead of nlapiSetFieldValue I am using nlapiSetCurrentLIneValue. if(type == 'item' &&…

Hi Pierre. We are using a 3rd party for demand planning so no it is not turned on.. Using lower case fixed my problem

If any one in the future cares, here is the answer. itmSearchAdv = new ItemSearchAdvanced { savedSearchScriptId = "customsearch_pe_itemprefbin", }; SearchStringCustomField custSearchField = new SearchStringCustomField(); custSearchField.scriptId = "custitem_pe_eancode"; custSearchField.@operator =…