Mikko De La Fuente-Oracle · SuiteCloud Support · Gold Crown

Hi @PaulFleetwood , did you manage to update the field? -Mikko

Hi @Sivasubramaniam , do you still encounter the error? -Mikko

Hi @Vernita , how things going on your end? -Mikko

I am still checking if this is possible directly via query. However, if you are familiar with customization, I would suggest creating a custom field to get the value needed and retrieve that field through the query. The article is for NetSuite data source and upon checking, the posting_account_activity table is not present…

Hi @Tom Dalton , Thank you for posting again in the community! Our gurus/members will look into your concern and update for any findings. Hi @Dominica Sevilla-Oracle /@Shamaine Chan-Oracle , any thoughts on this one? ? To everyone, feel free to share your ideas. -Mikko

Hi @iecpradeep_14007 , Thank you for posting again in the community! Our gurus/members will look into your concern and get back with more information. Hi @Micah Timbol-Oracle /@Katerina Winklerova-Oracle , any thoughts on this one? ? -MIkko

Hi @User_HM2RA , Thank you for posting here in the community. Either customer or bank can generate SSH key. SSH keys are generated by 3rd party tools and stored/check on NetSuite to have a safe connection between applications. A sample external tools you may use are puTTy/Cygwin. See article for reference. -Mikko

Hi @User_RHKAB , Welcome to NS Support Community and thank you for posting your concern here! For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. We encourage that you update your profile, add a profile…

Hi @User_36NQK , Welcome to NS Support Community and thank you for posting your concern here! For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. We encourage that you update your profile, add a profile…

validateLine / validateInsert function of Client SuiteScript should do the trick. See article for reference. -Mikko

Apologies for the confusion, the formula above converts date to timestamp with timezone. Converting the date to specific timezone is still an enhancement(# 87743 - Timezone Preference for Reports & Searches-> Customer would like to run a searc or report and get the data in the Time zone specified). You could add a vote on…

Have you tried including groups in your query? This article could give you idea. Let us know if this helps. -Mikko

Hi @Thuy Trang , is the "Available without login" enabled in the Suitelet deployment? Also, what version of SuiteScript are you working on? Have you also tried including a catch handler? -Mikko

It is not always the case, see the article on how the script executes in order. Additionally, if you are able to submit a case to support team, they could check on the backend the script/function that overwrites the affected field. Else, you have to check it one by one and arrange the order of execution. -Mikko

Hi @Parameswaran_gp , Thank you for posting again in the community! Please allow some time for the gurus/members to check on your concern and update you for any findings. Hi @Joahnna Given Uy-Oracle /@Jack Daryl Espiel-Oracle / @Leonard Mallare-Oracle , any thoughts on this one? ? To everyone, feel free to share your ideas…

Hi @Vernita , Thank you for posting again in the community! Currently, this is not possible via script. I would suggest submitting an enhancement request for this concern or visit SuiteIdeas. To everyone, feel free to share your insights. -Mikko

Hi Toanne @Toanne Termeer - van de Ven , Thank you for posting in the community! Please allow some time for the gurus/members to check on your concern and get back with an update. Hi @Joy Noreen Magoling-Oracle /@Ivy Lopez-Oracle , any thoughts on this one? ? To everyone, feel free to share your ideas. -Mikko

Hi @Vernita , Thank you for posting again in the community! Our gurus/members will look into your concern and get back with an update. Hi @Joy Noreen Magoling-Oracle /@Ivy Lopez-Oracle , any thoughts on this one?? To everyone, feel free to share your ideas. -Mikko

Could you provide the sample query you've used? -Mikko

The sublist should be inline editable. Could you also provide a sample script you are working on? -Mikko

Have you tried changing the order of scripts in the scripted record? This could help the overriding of the value on the affected field. See Scripted Record for reference. -Mikko

Hi @User_XMEU5 , Thank you for posting here in the community! Please give some time for the gurus/members to look into your concern and get back with more information. To everyone, feel free to share your ideas that could help. -Mikko

Hi Toanne @Toanne Termeer - van de Ven , Thank you for posting again in the community! Please allow some time for the gurus/members to check on your concern and update you for any findings. To everyone, feel free to share your thoughts. -Mikko

Have you tried using TO_TIMESTAMP_TZ instead of new_time function? You can check this article for sample format. -Mikko

Hi @Dirk Nieuwkamp , Thank you for posting again in the community! Are you aware on where or how the other script trigger the change/update on the said field? -Mikko

Hi Bee Yook @User_IE7NG , Thank you for posting again in the community! Our gurus/members will look into your concern and get back with an update. To everyone, feel free to share your thoughts! -Mikko

nlapiGetLineItemValue(type, fldnam, linenum) is the equivalent function on SS 1.0. Additionally, you could check the Sublist APIs for other function that would be helpful. -Mikko

Hi Jessica @jmack_admin , Thank you for posting again in the community! Please give some time for the gurus/members to check on your concern and get back with more information. Hi @Joy Noreen Magoling-Oracle /@Ivy Lopez-Oracle , any thoughts you could share?? To everyone, feel free to comment your insights that could help.…

Hi @iecpradeep_14007 , Thank you for posting again here in the community! This is possible via script. For example, you can get the value of the item field by using Record.getSublistValue(options) then use the sublistId and fieldId of it. -Mikko

Hi @Jeroen Sprangers ZS , It's been a while! How are you? Our gurus/members will look into it and get back with more information. To everyone, feel free to share your thoughts on the topic. -Mikko