Mikko De La Fuente-Oracle

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

in SuiteScript (Workflow?) remove 'Default Shipping Address Comment by Mikko De La Fuente-Oracle Dec 9, 2021 8:49PM

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

in Need help in calling Netsuite from google sheet Comment by Mikko De La Fuente-Oracle Dec 9, 2021 8:47PM

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

in Third party libraries in Suitescript 2.0 Comment by Mikko De La Fuente-Oracle Dec 9, 2021 8:44PM

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…

in How to replicate rolling balance sheet using SuiteAnalytics Connect Comment by Mikko De La Fuente-Oracle Dec 9, 2021 8:33PM

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

in Can we turn off auto package creation when fulfillments move off of a picked status? Comment by Mikko De La Fuente-Oracle Dec 9, 2021 4:38PM

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

in Identifying if a Transaction was Created through Memorized Transaction Comment by Mikko De La Fuente-Oracle Dec 9, 2021 4:20PM

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

in How to get SSH key for SFTP server configuration Comment by Mikko De La Fuente-Oracle Dec 9, 2021 3:04PM

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…

in AE:Sticky Notes display on a Saved Search Comment by Mikko De La Fuente-Oracle Dec 9, 2021 2:15PM

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…

in AE:Restrictions Comment by Mikko De La Fuente-Oracle Dec 9, 2021 2:14PM

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

in AE:Split line into two Comment by Mikko De La Fuente-Oracle Dec 9, 2021 2:12PM

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…

in AE:How to convert GMT to Malaysia time zone Comment by Mikko De La Fuente-Oracle Dec 9, 2021 12:37AM

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

in How to replicate rolling balance sheet using SuiteAnalytics Connect Comment by Mikko De La Fuente-Oracle Dec 8, 2021 3:18PM

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

in Promise function not running in suitelet script Comment by Mikko De La Fuente-Oracle Dec 8, 2021 2:48PM

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

in AE:Update 'Production End Date' field with SuiteScript or WorkFlow Comment by Mikko De La Fuente-Oracle Dec 8, 2021 2:33PM

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…

in AE:Custom Transaction Approval Via Mobile App Comment by Mikko De La Fuente-Oracle Dec 8, 2021 2:13PM

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

in AE:Split line into two Comment by Mikko De La Fuente-Oracle Dec 8, 2021 2:11PM

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

in Decimal separator export CSV Comment by Mikko De La Fuente-Oracle Dec 7, 2021 3:24PM

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

in AE:Inventory on Back Order Comment by Mikko De La Fuente-Oracle Dec 7, 2021 2:19PM

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

in How to replicate rolling balance sheet using SuiteAnalytics Connect Comment by Mikko De La Fuente-Oracle Dec 3, 2021 10:54PM

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

in Access custom sublist via script Comment by Mikko De La Fuente-Oracle Dec 3, 2021 10:44PM

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

in AE:Update 'Production End Date' field with SuiteScript or WorkFlow Comment by Mikko De La Fuente-Oracle Dec 3, 2021 9:08PM

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

in How to replicate rolling balance sheet using SuiteAnalytics Connect Comment by Mikko De La Fuente-Oracle Dec 3, 2021 3:03PM

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

in No External ID Inventory Cost Revaluation Comment by Mikko De La Fuente-Oracle Dec 3, 2021 2:46PM

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

in AE:How to convert GMT to Malaysia time zone Comment by Mikko De La Fuente-Oracle Dec 3, 2021 2:28PM

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

in AE:Update 'Production End Date' field with SuiteScript or WorkFlow Comment by Mikko De La Fuente-Oracle Dec 3, 2021 2:22PM

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

in AE:How to convert GMT to Malaysia time zone Comment by Mikko De La Fuente-Oracle Dec 3, 2021 2:08PM

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

in Access custom sublist via script Comment by Mikko De La Fuente-Oracle Dec 2, 2021 5:40PM

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.…

in Inventory Transfer - Pulled Items From Location, Did Not Add Comment by Mikko De La Fuente-Oracle Dec 2, 2021 3:02PM

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

in Access custom sublist via script Comment by Mikko De La Fuente-Oracle Dec 2, 2021 2:38PM

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

in AE:Work Order Completion and Item Fulfillment > GL impact System Changes Comment by Mikko De La Fuente-Oracle Dec 2, 2021 2:05PM

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

Comments