Francesca Nicole Mendoza-Oracle Gold Crown

We are now closing today’s session. We hope to see you in the next #AskAGuruLive! I hope the tips I provided will be helpful for you. 😊 Be sure to follow the AskAGuruLive tag for updates. To help us improve this program, feel free to share your feedback with us. Have a good one, everyone! 🎉

https://community.oracle.com/netsuite/english/discussion/comment/16909349#Comment_16909349 Hello @Robert Nedelkow-Oracle, Great question! Yes, NetSuite has documentations for both NetSuite Prompt Studio and SuiteScript Gen AI API. You may refer to the following for more information about these topics: Prompt Studio:…

Tip #3 Managing governance limits effectively is crucial for script performance: Minimize the number of API calls by combining operations where possible. For instance, use record.submitFields() instead of loading and saving a record when updating specific fields. Process records in batches to distribute the governance unit…

Tip #2 You can use the built-in SuiteScript debugger to troubleshoot your scripts, including server-side scripts. The debugger has break points, execution logs, and variables that can aid in troubleshooting. To access the Script Debugger: Navigate to Customization > Scripting > Script Debugger. If you're not already in the…

Tip #1 You can prevent a User Event script from executing during a SuiteTalk operation. To do this, you can set the runServerSuiteScriptAndWorkflowTriggers request preference to false. This disables server-side SuiteScript and workflow triggers for that specific operation. Sample:…

Hello @User_X5Z7Q, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter. 

Hello @User_JNRWJ, 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_FH6FZ, Good day. Upon checking, the Address Book tables work this way by design as of now where what appears to be duplicates actually have different ids. You may file for a SuiteIdea so that our our product team can take a look into it. You may use SELECT DISTINCT, to get the unique values.

Time's up! ANSWER: C. 90 minutes Explanation: As of Version 2020.1, idle session timeout policies have been enforced to enhance security and optimize system resources. Once exceeded, users will be logged out and will have to login again. Stay up to date with the latest changes in SuiteAnalytics Connect by checking this…

正解: C. 90分 説明:バージョン2020.1以降、アイドルセッションタイムアウトポリシーが適用され、セキュリティーが向上し、システムリソースが最適化されました。超過すると、ユーザーはログアウトされ、再度ログインする必要があります。 SuiteAnswers: Connect Service Notificationsの記事をチェックして、SuiteAnalytics Connectの最新の変更を最新の状態に保ちます。 NetSuiteの始め方ページで他の役立つ記事を確認し、NetSuiteを最大限に活用しましょう。

Hello @kariingvaldson, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter.

Hello @Eric Roelofs, 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_PAU1A, Good day! The table name for Script Server Log is "scriptnote". It's information is available in the Records Catalog. URL: <account_id>.app.netsuite.com/app/recordscatalog/rcbrowser.nl?whence=&siaT=1769013937913&siaWhc=%2Fapp%2Fcenter%2Fcard.nl&siaNv=ct1#/record_ss/ScriptNote Alternatively, you can find…

Hello @CrisH7, Thanks for getting back to us. Upon checking, it is currently filed as an enhancement under 571524 SuiteAnalytics Workbook > Calculated Measures > Percentage of Column Total. To support this Enhancement, you can cast your vote on the SuiteIdeas page by following the instructions provided in SuiteAnswers…

Hello @ CrisH7, Good day. Can you please provide a sample of the correct output that you need? Could be a screenshot of it done via excel just so we can understand what you require. Thank you.

Hello @ABDUL HANNAN, Good day! Following up on this in case you missed my previous response. In addition, tagging here some of our active members in case they've tried this on their end. @Tigran Shahnazaryan @Tiru Chembeti @Chelsea Jacobs @GauravAgrawal @Jesse Wampole @Dext3r @Divya Unnikrishnan @Todd N Niedringhaus

Hello @ ABDUL HANNAN, According to our SuiteAnalytics engineer, SuitQL should already support CTE. He recommends trying out the CTE solution and reporting any problems you find. I hope this helps! If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the…

Hello @ABDUL HANNAN, Good day. I have consulted this with our SMEs regarding your concern. I'll get back to you as soon as I receive a response. Thanks!

Hello @Ted Stout, Good day and thank you for posting this new thread. We're sorry to hear about your situation. We'll get back to you as soon as we can. Hope you feel better soon! Hello everyone! We kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.

Hello @User_FH6FZ, Good day. Upon checking, this behavior is currently logged as an enhancement under Enhancement 679538 NetSuite2.com Data Source > Discrepancy between retrieving rowcount and results for calendarevent table. When querying the CalendarEvent table in the netsuite2.com schema, including the attendee field…

Hello @User_SCYT4, Good day. As of now, REST does not support Legacy Tax. As of now, we do not have specific information from our Product Team regarding the deprecation of Legacy Tax. We will keep you updated and inform you ahead of time via marketing campaign emails. All NetSuite accounts, both new and existing, will need…

Hello @User_WMAX9, Good day. Do you still need assistance with this concern?

Hi @ABDUL HANNAN, Following up on this thread in case you missed my previous reply. If you need further assistance, please let us know. Thanks!

Hi @Chelsea Jacobs, Good day! Following up on this thread in case you missed our previous replies. If you need further assistance, please let us know. Thank you and Merry Christmas!

Hello @ABDUL HANNAN, Good day! Oracle Help Center documents the SuiteQL Limitations and Exceptions, SuiteQL Supported Built-in Functions, and SuiteQL Performance and Best Practices. One of the Built-In Functions is the BUILTIN.HIERARCHY. Sample query from the document: SELECT id, parent, BUILTIN.HIERARCHY(parent,…

Hello @User_63SXE, 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 @Chelsea Jacobs, Good day. @Dext3r is correct. SuiteScript does not support this saved search type as of now. You may explore a different approach such as using SuiteQL Queries and N/email module within the SuiteScript itself. You can check the Records Catalog if all the fields you need are also accessible via query.…

Hello @RKrol, Good day. Our expert suggested that we file a case on your behalf. With this, we have sent you an email requesting for your account information. Please feel free to add any other information that can help expedite the investigation. Thanks!

Hello @jjt, 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 @ RKrol, Can you confirm if your browser language (e.g. Chrome, Firefox) is also for 'Nederlands'?