Hello @Ron Mc, Copy that. Please feel free to reach out once you are able to confirm. Thank you for letting us know!

Hello @User_FAN5P, Good day. NetSuite2.com schema does not use SuiteAnalytics Connect - Read All permission anymore. Instead, each transaction type needs to be added in the list of permissions. As stated in Role and Permission Considerations for NetSuite2.com, Data Warehouse Integrator and custom roles are recommended for…

Hello @Ron Mc, Happy Monday! Following up on this in case you missed my previous comment. Thank you!

Hello @Ron Mc, Good day. Can you please check the deployment record of theSuiteQL Query Tool? It is also possible that it is set up with Execute As = "Administrator", instead of the current logged in role.

Hello @Jernan Gumpad-Oracle, Good day. I have tested this formula on my end but I am unable to replicate the error. Here are the screenshots of my testing:

Hello @esabis, 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 @ Ron Mc, Happy Monday! Folllowing up on this in case you missed my previous comment. If you need further assistance, please let us know. Thanks!

Hello @ Ron Mc, Good day. This could be a result of using different roles that have different permissions. You could query the unique transaction types you're retrieving from the transaction table for both sides by using SELECT DISTINCT and then compare the results. I hope this helps!

Hello @User_SCYT4, Good day! Following up on this in case you missed the previous responses. Thank you.

Hello @ ABDUL HANNAN, 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 @Dext3r, Good day! Following up on this thread in case you missed my previous comment. Thank you!

Hello @ ABDUL HANNAN, Good day. NetSuite has SuiteAnalytics Connect (ODBC/JDBC). It exposes NetSuite’s Analytics Data Source (“NetSuite2.com” schema) via ODBC/JDBC so you can run SuiteQL from external tools. Role-based security applies. It’s read-only. For more information, you can check out these links: I hope this helps!

Hello @User_SCYT4, Good day. Is this error only occurring in SOAP Integrations and not on NetSuite UI? Per checking, one of the common causes of the error include configuration setups for the item, subsidiary/nexuses, and vendor record. You can check the following: 1. The tax code is only valid…

Hello @Dext3r, Good day! You're heading in the right direction. However, using task.create() for each individual transaction could result in multiple (or even excessive) concurrent script instances, which may lead to governance and performance issues. A more efficient approach would be to use your Queue Record as a…

@Makiko 様、 ヘッダー・レベルの「Department(部門)」フィールドは、「Main Line(メインライン)」= 「true」フィルタをトランザクション表に適用することで表示できます。 メイン行にtrueを設定すると、ヘッダー・レベルのデータが取得され、falseではサブリスト(行レベル)データが取得されます。 SuiteAnalyticsワークブックを使用している場合は、次のステップに従ってください。 1.[分析] > [新規データセット] > [トランザクション]に移動します。 2.…

Hello @User_7NK3Q, 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_RLXCM, Good day. Please try the following steps: Log in to your production environment using an Administrator role. Navigate to Setup > Integration > SAML Single Sign-on. Note the current value of the Logout Landing Page field. Right-click Current Identity Provider Metadata, select Save Link As, and save the…

Hello @CDuf, Good day! Following up on this in case you missed my previous comment. If you need further assistance, please let us know. Thanks!

Hello @CDuf, Good day. According to this documentation, you can use the ConnectLoginAudit record available for NetSuite2.com to get this information. This record gives SuiteAnalytics Connect administrators Connect usage information, including users' login attempts, outdated drivers, the third-party application, the Connect…

Hello @User_C3WZE, 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 @ Dan at Alnoba, Good day. Do you still need assistance with this concern? Thank you.

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

Hello @User_G7R2E, Thank you for posting in the NetSuite Support Community! Hello everyone! Your collaboration and input are highly valued — let’s work together to provide guidance and support on this topic.

Hello @ Vishnu M, Good day! Following up on this in case you missed my previous comment. If you need further assistance, please let us know. Thank you!

Hello @PaulRipley, Good day! Following up on this thread in case you missed my previous comment.

Sample tools are also available on GitHub: https://github.com/oracle-samples/netsuite-suitecloud-samples/tree/main/MCP-Sample-Tools

Hello @Vishnu M, Good day! According to our experts, there shouldn't be a script type declaration for custom tools. if you want a header, you can use something like: /* * mycustomtool.js * @NApiVersion 2 .1 * @NModuleScope Public */ you should also wrap your entire function (inside the define() call in try/catch blocks and…

Hello @mark petzold, Good day! We’ve identified your concern as a potential defect. To determine the root cause, we recommend reaching out to NetSuite Customer Support. We’ll be sending you an email shortly to request your NetSuite Account ID. You may also include any additional details that could help our team investigate…

Hello @ PaulRipley, Good day! If you are referring to SQL Server Management Studio, I found this documentation online that provides a step by step guide on how to connect NetSuite to it. Please note that this is not official NetSuite Documentation.

Hello @User_OGQAD, Greetings from the NetSuite Support Community! Thank you for starting this discussion. Hello everyone! We look forward to your input and experiences. Thanks!