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

I understand it is frustrating but as mentioned on the SQL Compliance article, the Connect Service may not be fully compliant with SQL-92 syntax and is limited to both OA SDK and Oracle. This is also a known concern that lead to enhancement request mentioned. Apologies for the inconvenience it may have caused. -Mikko

Hi @Janis001 , Thank you for posting again in the community! Our gurus/members will look into your concern and get back with more information. Hi @Dominica Sevilla-Oracle /@Shamaine Chan-Oracle , any tips to share? ? To everyone, feel free to share your suggestions. -Mikko

I don't think this would be possible via SSO. I would suggest submitting an enhancement request for this concern but please be specific on the details. -Mikko

Hi @Marek Zada , 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 @Claudio Costa , Good to see you again and thank you for posting! Our gurus/members will look into your concern and get back with more information. To everyone, feel free to share your insights! -Mikko

While we check on this, have you tried using fieldChange function of Client script when getting the checkbox value instead of using the After Submit function? -Mikko

Since the data type used was varchar, you have to modify the query to compare varchar data type values. You may want to use the wildcards. E.g instead of using '>' 2022, you may use LIKE '%2022%'. This will give the results with 2022 in the value. -Mikko

Upon further checking, it seems that this is related to an enhancement (# 275687 ODBC > YEAR function > Failed to retrieve data). You could submit a case to support team to add a vote or visit SuiteIdeas. You could try the following syntax as a workaround: select to_char(lastmodifieddate) from transaction where…

Could you provide a sample script on how you retrieve the checkbox? You could also check the article that uses parameters to get the value. For SS 2.0, you can check the following articles: Retrieve Parameter from One Suitelet to Another Suitelet via SuiteScript 2.0 Retrieve URL Parameters on a Suitelet Using SuiteScript…

Apologies for the confusion. Transaction was the correct table. Transactions was for the netsuite.com data source. Few questions: Are you retrieving large number of data? If yes, please try to test on few results. Is this the first time you encountered this error? Could you please try to use convert()(to datetime format)…

Hi @Saqib Ali , could you double check the table used, please try to use "transactions" and let us know if the error persist. -Mikko

The 'A' and 'B' represent the value of the text: 'Pending Approval' and 'Paid in Full'. In SuiteScript, you will get the value A/B when using function like Record.getValue then the string 'Paid in Full' when using Record.getText. You can check sample status Id in this article. Let us know if this helps. -Mikko

Hi @asha.jena , please correct me if what I understand is not accurate. On your last paragraph, do you mean when the checkbox is checked manually, you get the value Incorrect? May I know if what function are you using when getting the values? And what record are you referring? E.g New/Old record.

Hi @Nikolay Georgiev , This concern is currently related to enhancement (# 530115 SuiteScript > User or Client Script > Does not trigger when 'Save Baseline' Button is clicked on Project record). You could submit a case to support team to add a vote or visit SuiteIdeas. Unfortunately, no alternate solution mentioned on the…

Hi @iecpradeep_14007 , Thank you for posting again in the community! Please allow some time for the gurus/members to check if this is possible. Hi @Joahnna Given Uy-Oracle /@Kristoffer Viray-Oracle /@Jack Daryl Espiel-Oracle , any ideas to share? ? To everyone, feel free to share your thougths. -Mikko

Hi Toanne @Toanne Termeer - van de Ven , Thank you for posting again in the community! Our gurus/members will look into it and update this thread for any findings. Hi @Joahnna Given Uy-Oracle /@Jack Daryl Espiel-Oracle /@Kristoffer Viray-Oracle , any suggestions to give? ? To everyone, feel free to share your knowledge…

Hi @PaulFleetwood , Thank you for posting again in the community! Please allow 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 ideas to give? ? To everyone, do not hesitate to share your knowledge. -Mikko

Hi Dirk @Dirk Nieuwkamp , It's been a while, how are you? Thank you for posting again in the community and hope you had a wonderful year ahead! Our gurus/members will look into your concern and update the thread for any findings. Hi @Micah Timbol-Oracle /@Patrick Fresnosa-Oracle , any insights to share? ? To everyone, feel…

Hi Toanne @Toanne Termeer - van de Ven , Thank you for posting your concern again here in the community! Please allow some time for the gurus/members to check this for your and get back with more information. Hi @Joahnna Given Uy-Oracle /@Kristoffer Viray-Oracle /@Jack Daryl Espiel-Oracle , any tips to share? ? To…

Hi @NewNetSuiter , 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 @Micah Timbol-Oracle /@Patrick Fresnosa-Oracle , any thoughts on this one? ? To everyone, feel free to share your insights. -Mikko

Hi Erick @User_NYYPL , It's been a while, how are you? Thank you for posting again in the community as well! Our gurus/members will look into your concern and get back with more information. Hi @Shamaine Chan-Oracle /@Dominica Sevilla-Oracle , any Ideas to share? ? To everyone, feel free to comment your suggestions. -Mikko

Hi Chris @HertsChris , Thank you for posting again in the community! On top of my head, creating another custom field that source the other custom field(with unchecked store value) value would be an option. Let's see if others have any suggestions. Hi @Kristoffer Viray-Oracle /@Joahnna Given Uy-Oracle /@Jack Daryl…

Hi Matan @User_G722X , 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 Mathias @User_GXMTF , Thank you for posting again in the community! Our gurus/members will check on this and get back with more information. Hi @Micah Timbol-Oracle /@Katerina Winklerova-Oracle , any ideas to share? ? To everyone, feel free to comment your insights. -Mikko

Hi @NewNetSuiter , Thank you for posting again in the community! Please allow some time for the gurus/members to look into your concern and update this thread for any findings. Hi @Jack Daryl Espiel-Oracle /@Kristoffer Viray-Oracle /@Joahnna Given Uy-Oracle , any thoughts you could share? ? To everyone, feel free to…

Hi @iecpradeep_14007 , do you still need assistance on this concern? -Mikko

Hi Martha @Martha Hakes , Thank you for posting again! Please allow some time for the gurus/members to check your concern and get back with more information. Hi @Michelle Jabanes-Oracle , any insights to share? ? To everyone, don't hesitate to comment your ideas. -Mikko

Hi Martha @Martha Hakes , Thank you for posting again here in the community! Our gurus/members will look into this and update the thread for any findings. Hi @Joy Noreen Magoling-Oracle /@Ivy Lopez-Oracle , any idea came to mind? ? To everyone, feel free to share your thoughts! -Mikko

Hi @HDefriedman , Glad to see you again and thank you for posting in the community! Our gurus/members will look into it and get back with an update. Hi @Dominica Sevilla-Oracle /@Shamaine Chan-Oracle , any tips to share? ? To everyone, feel free to comment your insights that can help. -Mikko

Hi @User_BR625 , 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…