Francesca Nicole Mendoza-Oracle Gold Crown

Hello @User_M1OCU, 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 @User_ET02U, Thanks for letting us know. Does running the query without any item filter yield any result at all? Per checking, only invtitempricehistory table is related to item price changes.

Hello @ User_FH6FZ, Good day. After consulting internally, we have identified your concern as a potential defect. To assist you further, we will send you an email requesting your account information. Please feel free to include any additional details that may help us resolve this issue promptly.

Hello @User_ET02U, Good day. Is this only happening for a specific item? If yes, what is its item type?

Hello @Gert Van Damme, Good day. The SOAP URL for your account can be found in Setup > Company > Company Information > Company URLs subtab. I hope this helps!

Hello @Casey Keating, Good day. As Dext3r mentioned, this is a custom error created either via SuiteScript using N/error module or a Workflow with Return User Error action. If you have not resolved it yet, please check if you have scripts or workflows that use either of those. I hope this helps.

Hello @User_UTWAG, Good day. If you are using the Order Reservation record, yes, SuiteScript does support it as listed in the enums for search.Type. All the scriptable fields for this record type is also listed in the Records Browser. I hope this helps!

Hello @Ashoka_Sanjapu, Good day. Upon checking, the field Transaction_TRANDATE in not listed as a scriptable field in the SuiteScript Records Browser as of version 2025.2.

Hello @User_A72RO, Good day. Can you please check if you encounter the same error when creating a record via NetSuite UI?

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…