Hello @NKusiak, Can you please explain further how the solution from SuiteAnswers did not work as expected? Was there any error message? Thanks!

Hello @Dwight Schrute! Happy to work with you again. When the user login fails, is there any particular error message returned? You mentioned that you have the "Single Sign-On Only" checkbox ticked. Can you please untick it and then add the following permissions to your custom SSO role? Set Up SAML Single Sign-on - permits…

Hello @Andrii Siryi, I've tried to look for other solutions but as of now, we have no other approach that we can provide to achieve your requirement without needing the creation of a saved search via the NetSuite UI. You could file this as a SuiteIdea so that our engineers could take it into consideration for future…

Hello @User_C5N4B, Let's look into that further. Are you using ODBC or JDBC Connection? If you're using JDBC, can you please send the URL you're using? And please remember to censor sensitive information. I installed DBeaver into my device as well and checked if I get the same result, but I do have the tables you…

That's great! I'm glad to know you were able to get it to work. 😊 Thank you as well for your patience in troubleshooting this with me. Have a good one!

Hello @SeamusMon, Thanks for updating this post. I've checked this with our engineers but as of now, there is no native way to turn this warning off in NetSuite. I'm not sure if it would be possible via native JavaScript but even then, it is not advisable. On the bright side, I found that an enhancement request has already…

Hello @Dwight Schrute Happy new year! I created a free trial account in Rivery so that it'd be easier for us to be on the same page and I was able to get a connection going by doing the steps I documented in the file below.

Hello @AhmedM! Glad to have you with us today. Thank you for creating this thread. Please allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To our other members, please feel free to provide your insights. It is highly appreciated!

Transaction data are typically extracted from several tables, depending on the fields involved. These are some of the commonly used tables in NetSuite2.com data source: transaction transactionline transactionaccountingline entity (for employee/customer/vendor) You can find more information about these tables in the record…

Hello @User_C5N4B, The feature to be able to pull pre-made reports from NetSuite directly via ODBC/JDBC Connections is currently not available in NetSuite. The good news is you can write an SQL Query that would mimic the data from the report you are looking for. The closest example I found is in SuiteAnswers Article 23308…

Hello @Vernita, I looked into the code you posted and there appears to be a minor correction needed around line 32. Instead of a single quote followed by a semicolon, there was a zero at the end of the line which resulted in an error. After correcting this, the error disappeared. Can you please check if this works on your…

Hello @Benjamin Paul - USA, Glad to have you with us today. Thank you for creating this thread. Please allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To our other members, please feel free to provide your insights. It is highly appreciated!

Hello @Dwight Schrute! Just following up on this thread in case you missed the last comment that I wrote. Let me know if you need further assistance, more than happy to help!

Glad to know editing the permissions helped, as a start. There isn't one permission that would allow you to view all sales data. But as you were able to view those data using your Sales Manager role, I suggest copying the permissions from that role so that you can ensure that everything the sales manager is able to view,…

Hello @GauravAgrawal, Several updates will be done in the backend. Specifics will be provided once the Release Notes for the upgrade are published. Thanks!

Hello @Dwight Schrute, Thank you for letting me know! Just to clarify, there is no need to rerun the .exe file once it is installed in your system. To open the ODBC Driver, you can simply open the Start Menu of your laptop and then search for "ODBC Data Sources (64-bit)" or "ODBC Data Sources (32-bit)" whichever is…

Hello @User_C5N4B, SuiteAnalytics Connect - Read All is not applicable if you are using NetSuite2.com. (See SuiteAnswers 39013) Instead, you must maintain the "SuiteAnalytics Connect" and the permissions required to access the table you need. For example, if I want to see the Sales Orders from the transaction table, I will…

Hello @Mohammed Al-husseini! Glad to have you with us today. Thanks for creating this thread. Our gurus are reviewing your concern and will perform their initial investigation. We will reach out again if we have updates on this. To our other members, please feel free to provide your insights. Your voice makes an impact in…

Hello @Betsy Vance, Refreshing your Sandbox to replicate your production account does include copying the files from production. However if you would only refresh to fix this script you mentioned, I suggest that you try to download the script from production and upload it in Sandbox if that is feasible for your situation.…

Hi @Nicole SB-Oracle! It is by design that administrator roles are not accessible when logging in via SSO. According to SuiteAnswers Article 102787 SAML SSO Permission Limitations, a user who has accessed NetSuite through SAML Single Sign-on cannot access any roles that do not have SAML Single Sign-on permission. This…

Hi @MathewB, Apologies for the error. I meant the release notes, not the release itself. I've corrected the previous comment I made. Happy Friday!

Hello @Carla S.! The Release Notes for NetSuite Version 2023.1 should be available by January 18, 2023.

Hello @User_SZ0C3, I'm sorry to hear that this solution is not feasible for you. Let me see if there is any other workaround that will not require creating anything in the UI. I will get back to you hopefully with good news. Thanks!

No worries! I'm glad I was able to help you find the answer and besides, this thread could also help others as well in the future. 😊 Cheers!

Hello @User_SZ0C3! Were you able to get this working? If yes, can you please click the "Yes" button from the "Did this answer your question?" at the bottom of the answer that helped resolve your concern. If you need further assistance, please feel free to reach out! 😊 I'm more than happy to help.

Hello @Dwight Schrute, Just checking in on this. May I know if you were able to resolve your NS2.com connection with the guide I provided in the previous comment? If it did, please let us know by clicking on the "Yes" button below the answer that helped. Thanks!

Hello @Dallas H! Hope you're having a great day. I've looked into this and according to SuiteAnswers 44135, only administrators can create integration records. I hope this helps!

Hello @rymer! Glad to have you with us today. Thank you for creating this thread. Please allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To our other members, please feel free to provide your insights. It is highly appreciated!

Cool! Thanks for providing this. I think what you're missing is the setup for this driver to work. To do this, you can click on "Add" then fill out the information. It should look something like this: Afterwards, try the connection by clicking on "Test Connect" at the bottom-left corner. A pop-up like this should appear.…

No probs! I've tried downloading the Installation Bundle and opening the exe file from my device and encountered the same message as well. However, I believe I encounter this because I already installed the ODBC Driver beforehand. Perhaps what it is telling us is that if you re-install the driver, the configurations…