christianedensorarbon Red Ribbon

I do agree with @pcutler's notes from above that online record forms would lack permissions required a a client script calling a RESTlet would be the best option. The best option security-wise would be utilizing Token-based Authentication on the call as there will no passwords being exposed on the client side and all…

Hi John, From what I understand from your use case is that you wanted to have cache groups and perform the flushing of KVPs in a cache group basis. Please file a support case and we would have an enhancement filed for this concern.

Hi Eric, I would like to agree with david.smith that it is a better option to use the path-based approach on importing your library e.g. d3. As of the moment, I haven't heard of the option to globally create a require.config(). Another alternate solution is to create a library which will act as you mask or alias to the…

Pitching in the information provided along, Even on view mode, you can set client script either but file id or by module path in version 2016.2. By creating a client script and adding a JS library or even JQuery as a dependecy of the client script, you can have it added on the view mode of the record.

What is the Java version that you are using on your end? Also is your JKS updated to support the one in production?

Hi jordan_RH As for this concerned, have you already checked it out in the Connect Browser (https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_2/odbc/record/inventoryitem.html) If the field is present in the Connect Browser and you are not able to find the mentioned field, kindly file a Support Case.…

Have you tried Administrator.TRANSACTIONS instead. It seems that the MS Access application does not find the mentioned table from the schema because of the naming. With the office applications connecting using ODBC, it normally uses dot notation of role and the table name.

Hi savethepennies The solution for the conversion if you want to proceed with the conversion of timezone using SQL is the use of the use of SWITCHOFFSET from the result of the query to NS ODBC. This means that the conversion is done after the results has been returned by NetSuite. Although the SQL approach for timezone…

Hi tkrause@alteryx.com, For that concern, NetSuite's ODBC service for SuiteAnalytics Connect only allows retrieval of data which means that you can only use SELECT-based queries for the mentioned service. For data editing process, I would suggest you to use either SuiteTalk or RESTlet instead. The mentioned service should…

indianagreg On my experience, ODBC would require you to download it from your NetSuite UI as ODBC (SuiteAnalytics Connect) is an additional module in which it is not currently possible. Could you provide us the error ticket so that we could discuss this one to the handling rep and file an enhancement for this concern.

Microbiologics On this concern, have you updated with the most recent version of the ODBC driver? What is the version of the ODBC driver that you are using on your end? Also, is this concern occurring intermittently or are you always replicating it? If you are already using the most recent version of ODBC downloadble on…

realdrouin , the name of the ODBC table for the custom record should be similar to to concatenation of the name of the custom record e.g. a custom record with name Colors Available should be COLORS_AVAILABLE

Hi @whitecloud, For enabling the feature, there are pretty much a number of articles in SuiteAnswers like 38965 and 38960

I tried replicating the scenario on my end using the JDBC driver and I was not able to replicate the scenario. Looking at the error, the possible cause is generally caused by wrong configuration of the JDBC url. Just noticed that the prod url uses : instead of ; before the ServerDataSource

Hi Phil, Kindly submit a support case for this one so we could track the enhancement request.

Hi rvasquez Have you trued performing the similar query using the SuiteAnalytics Connect ODBC driver? If you have some table viewing tools like DBVisualizer, that could help you.

@realdrouin, If you are connecting using ODBC, you may refer to the Connect Browser (https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/odbc/record/account.html). If you are getting the getting custom fields, you may concatenate the name of the custom entity field e.g. MY CUSTOM FIELD to…

Once you know the account and the transaction types to deal with, you can perform a query joining Accounts and Transactions table but somehow will take time to generate the formula given that you can directly pull the report out of ODBC

Hi @drezaei, Currently, SuiteAnalytics Connect does not have an option to directly pull the reports that you have in UI. What you may need is to first understand the fields that the being pulled up by the report that you are working on and match them on the tables that you can see on the Connect Browser.

Agreeing with Eric. If you also check it from the Records Browser (https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/script/record/itemfulfillment.html) paymentmethod is not a field in the item fulfillment but it is rather a field sourced from the sales order to which it is created from.

Have you applied it to a form and set that form to your default Web Order form using on your Checkout Preferences? That should work for your scenario.

Hi Doug, Based on the use case that you are trying to achieve, you should first prepare a client script that will performing the appending of value and then bind that to a button for the form on your case form.

Hi @steven_stewart, I also tried this on my end and was able to replicate the scenario that you are experiencing. I would suggest that you file a support case for us to track this detail if ever we can checkout more information on this. I tried to have a rich text field on an online form and input data that is HTML code…

Hi toddk , Have you applied the fields to the form? There should be an Apply to Form button to have the added.

Similar to the provided solution coming from @torin.aminian.com, workflow should can address this concern with a simple Show Message. But maybe you have another set of validations that you want. But here's some tips on the changes you need for your script to work properly. Also use…

More or less, the original post is in the correct subforum. Have you tried filing a support ticket to have a support rep check the mentioned error that you are encountering.

Hi Steven, Here's one thing, you can customize the case forms which might be a better use case and have an identifier for each form being. That way it would be a lot easier to keep track on it

Agreeing with michoel , the general requirement to address this is by having the jqueryUI libraries into the library sublist of the client script. If you are using Suitelets, then it should also be linked to the client script record's libraries sublist.

Based on the response thrown, it seems that the Suitelet does have a function to catch request.getMethod() == POST. Also same thing as david.smith , mentioned, are you posting to the suitelet from an external application? You should try reviewing the preferences set on the deployments page.

Vinayak From what I experience on my end, script should be the one that should execute first. A best way to observe this precedence is on the client side.