Hello @User_UQ9ZD, Good day. The NetSuite.com data source is no longer supported as of 2025.1 and will be removed in 2026.1. You should use the NetSuite2.com data source when working with SuiteAnalytics Connect to avoid any disruptions. If you stopped using NetSuite.com for a long period, the outdated data source will be…

Hello @Mary Rivas, Good day! Tagging here some of our active members in case they have worked with DATEV. Hello everyone! If you’ve worked on this integration, please share your insights, challenges, or best practices. Your input would be greatly appreciated! Thank you! @Tigran Shahnazaryan @Chelsea Jacobs @Dext3r @Tiru…

No worries! Happens to the best of us.

In addition, I also noticed that you're using "inventorynumber" field to set the Inventory Number. This is not a valid field in the Records Browser. Instead, please use "issueinventorynumber" Reference: Records Browser version 2025.2 (latest at the time of writing) I hope this helps! If you find this reply to your question…

Hello @CristianCiz, Can you please provide a screenshot of your Inventory Detail when you're filling it out via UI? I will attempt to replicate this on my end.

Thanks for the detailed explanation of your approach, @ Dext3r! This is valuation information.

Hello @CristianCiz, Good day! 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 @RRW_EPM, 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.

Thank you very much for your feedback as well, Geoff! Always happy to help. 😊

Hello @User_FAN5P, Glad to hear that it works now! These are the required permissions entity: List > Perform Search permission accountingperiod: Setup > Manage Accounting Period permission CUSTOMRECORD_EFF_NSP2P_XML2NSTRANS: List > Custom Record Entries permission You can also double check the Custom Record itself by…

Hello @CristianCiz, Good day. Please try to use the actual bin number instead of the internal ID, that is enclosed in a double quote. i.e. value: "12345" 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 question?” below, you’ll be…

Hello @Pradeep Kumar., Good day! Thanks for letting us know. If you need further documentations on SuiteAnalytics Connect and Token Based Authentication, you can check SuiteAnswers Requirements for Using Token-based Authentication in Connect Using Connect with Token-Based Authentication (TBA) Token Password for Connect…

Hello @ABDUL HANNAN, This may be better answered by our fellow community members who have worked with such third-parties for their integration. Tagging here some of our most active members in case they have any insights. Hello everyone, your recommendations are highly appreciated to help Abdul with their integrations.…

Hello @User_FAN5P, You'll need the System Notes for Analytics and REST permission to access the System Notes table via SuiteAnalytics Connect and REST API. 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 question?” below, you’ll…

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:…

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.