Francesca Nicole Mendoza-Oracle Gold Crown

Hi @Vernita, Good day. I'll be checking your code in a bit. But to make sure this is not permission/role-related, can you try to undeploy the script and perform the steps manually in the UI?

Resposta: D. Pesquisa salva de transação Explicação: A pesquisa salva da transação pode retornar notas do sistema em nível de linha que também são encontradas no campo Histórico na interface do usuário do NetSuite. Esses campos podem ser extraídos por meio da interface do usuário de pesquisa salva, SuiteScript e SuiteQL.…

Respuesta: D. Búsqueda guardada de transacciones Explicación: La búsqueda guardada de transacciones puede devolver notas del sistema a nivel de línea que también se encuentran en el campo Historial de la interfaz de usuario de NetSuite. Estos campos se pueden extraer a través de la interfaz de usuario de búsqueda guardada,…

Time's Up! Answer: D. Transaction Saved Search Explanation: Transaction Saved Search can return line-level system notes that are also found in the History field in the NetSuite UI. These fields can be extracted via Saved Search UI, SuiteScript, and via SuiteQL. For more details, you may visit NetSuite Admin Tip: Different…

Hello @Aaron McCausland, Glad to hear that you were able to run your workaround successfully. We also do not have access to debug a locked bundle. You may file a case with NetSuite Support if you believe that this could be a defect. They are also better equipped to troubleshoot this by checking the replica of your account.

Hello @User_K51C7, I'm just checking in to make sure you didn't overlook my prior message. If there's anything else we can do to assist you, please feel free to reach out. For new members, we encourage you to update your profile - add a profile picture and preferred username so other members can address you properly moving…

Hi @Aaron McCausland, I'm touching base to confirm that you didn't miss my previous message. If you find yourself in need of further assistance, please don't hesitate to get in touch.

Hello @User_8V0KU, I'm circling back to ensure you saw my previous communication. Should you require any additional support, please don't hesitate to contact us.

Hello @User_8V0KU, I haven't tried it nor heard of anyone using that within NetSuite before. These are the only common ways we run queries: SuiteScript N/query Module SuiteQL Query Tool Other than that, we use 3rd party applications like Postman for SuiteQL with REST API or database tools like dbvisualizer and power bi.

Hello @Aaron McCausland, Can you please double check your email plugin deployment? This is one common root cause identified in previously reported cases. The email plug deployment (Customization > Plug-Ins > Manage Plug-Ins). It is not enabled since it is unchecked. If you find this reply to your question useful, others…

Hi @User_8V0KU, According to our community administrator, a user can post anywhere they like so no action/permission is required. The post remains active in our community and all members can still reply. As for your query, it is best if you check this with support. They would be better equipped to get to the root cause of…

Hello @Edgar Valdes, Good day. This is still not supported for SuiteQL currently and is logged under Issue Record #724241 SuiteAnalytics Connect > ODBC > Expose Currency Revaluation. This is currently logged as a defect therefore it would not appear in the SuiteIdeas page. You may file a case with Support and provide this…

Hello @User_9BMIN, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated.

Hello @User_K51C7, Can you please try clearing your cache? This is working fine on my end:

Hi @ONO4, I'm circling back to ensure you saw my previous communication. Should you require any additional support, please don't hesitate to contact us.

Hi @Jorge Albanez, This is currently not possible out-of-the-box. You could perform some customization by either adding a custom field or a script that would copy the value of the inboundshipment field in the Item Receipt so that you can extract it via SuiteQL. This has been requested as an enhancement under Enhancement…

Hello @Sally Justiani, In the initial test, I do not have SuiteTax enabled and was not done in a OneWorld account, therefore I did not have subsidiaries. I tested this again in a different account with SuiteTax and Alaskan Subsidiary. I also got the expected result. It is most likely that the error you are encountering is…

Hello @ONO4, I would need a little more information on the use case. I have already checked our system and so far there is no report of an issue for enableSourcing. I have been unable to replicate your concern in several accounts as well. Here are the screenshots of one of the tests I did: First, I changed the customer to…

Hello @User_TQMLE, Good day and thank you for posting this new thread! Hello everyone! We kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.

Hello @Roshan Shaikh, Good day. You can use the Date() function of the native JavaScript to get the current day and convert it using Format.format, and then append the time into a string. Here's a sample code for you: function pageInit(scriptContext) { //----------------DATETIME-----------------// var date = new Date();…

Hi @Ckirk, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated.

Hi @User_8V0KU, Thank you for the clarification. I ran this test again on my end but I am still unable to get similar results. This could be specific to your integration. If possible, you might want to reach out to SSMS support in case this is a known error on their end. For your other concern, we do not delete content or…

Hello @Christopher Rossi, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support.

Hello @User_UORXE, "itemList" should only be "item". Once you change this, a new line will appear in the transaction when it is created. Upon checking, it does not appear to be possible to perform partial returns. As a workaround, you can send another PATCH operation to remove the first line with the quantity of 10. Here's…

This appears to be similar, if not the same as the query you have in another thread: the word AND seems to break Suite QL query. If that is the case, we are unable to replicate it on our end, as it works in both DBVisualizer and SuiteQL tool in the NetSuite UI, as you also mentioned. Some of the things you can check…

Hi @User_8V0KU, What application are you using that causes this error? I checked our system and did not find the same error message mentioned in any case or issue record.

Hello @User_8V0KU, I read through the exchanges you had with James. The short answer would be that the ODBC is a Pull. Basically, you install an ODBC driver that looks like this: or a JDBC Driver where a JAR file is added into the DBVisualizer (or other 3rd party applications) to establish a connection. This is very…

Hi @R. Dieka Pribadi G. E.,, I am unable to find a documentation as to what exactly happens when the limit is reached. Again, your account manager is the one who can best answer this question. In the meantime, tagging here some of our active community users as well in case they encountered it before: @Angela Bayliss…

Hi @User_8V0KU, Glad it's cleared out now. You might want to check out an article I wrote a year ago: New to NetSuite | How to Setup a JDBC Connection with DBVisualizer using SuiteAnalytics Connect

Hello @Jorge Albanez, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support.