Francesca Nicole Mendoza-Oracle Gold Crown

Hello @User_C5N4B, Thanks for getting back to me! Can you please navigate to Setup -> Users/Roles -> Manage Users -> View “SuiteAnalytics Connect User” and then send us the screenshots of the Transaction Permissions? Let’s double check if you have the necessary permissions for the transaction table.

Hello @Sushil 7, 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 this…

Hello @Vernita, Bumping this thread in case you missed it. It would be helpful for us if you could provide the details requested in the previous comment. Thanks!

Hello @Dwight Schrute, Happy Friday! Please let us know if you need further assistance on this thread. Thanks!

Hi @User_C5N4B, This is a gentle follow-up to the previous comment. Please let me know if you need further assistance. Thanks!

Hello @Rizkygaus, Bumping this thread in case you missed my previous comment. Thank you and happy Friday! 😊

Hello @NKusiak, If the answer I provided in the previous comment is the answer you're looking for, please let us know by clicking "Yes" at the bottom of the comment! Thank you. 😊

Hello @SanjeevV, 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 @NKusiak, Thanks for getting back to me! There's no information on the maximum number of schedules that can be created for a single report. As of now, you do need to set up a new schedule in order to change the owner, which is what we're doing in the SuiteAnswers Article. However, since your goal is simply for…

Hello @Vernita, I hope you're having a nice day. We're still looking into this as of now. For testing purposes, would it be possible for you to provide us with the details of the file you're using such as size and file type (jpeg, png, gif)? Also, were you able to try using other types of encoding for this? Thanks!

Hello @Rizkygaus, Here to assist! I agree with the suggestion from @GauravAgrawal. We cannot provide you with a functional code from scratch but I can give you a suggestion on the approach. Personally, with Gaurav's suggestion in mind, I would use an array containing multiple objects. Basically looking like this: {'item':…

Hello @NKusiak Bumping this thread in case you missed it! Let me know if you need further assistance, I'm more than happy to help. Thanks!

Hello @User_C5N4B, It looks fine. The issue could still be the permission. Can you please share a screenshot of the transaction permissions that you have for the role you're using for JDBC? For reference, this is what mine looks like:

Hello @Dwight Schrute, It is by design that SSO roles are not accessible when logging in via NetSuite UI. 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…

Hello @Dwight Schrute, Thank you for pointing that out, I misread it earlier. The error you encounter might have something to do with your IdP Metadata File. Can you try to download it again and re-upload it in NetSuite? After downloading the IdP Metadata from G-Suite, please perform the following steps: 1. Navigate to…

Hi @User_C5N4B, Bumping this thread in case you missed it! Please feel free to let me know if you need further assistance.

Hello @Andrii Siryi, Good day! This is a gentle follow-up to this thread in case you missed it. Thanks!

Hi @SeamusMon, Just bumping this thread in case you missed it! Thanks!

Hello @NKusiak, Thanks for letting us know! I believe the instructions from SuiteAnswers only provided a guide for which fields are required to get a scheduled report working again, while optional fields were not mentioned. If you need to configure the other fields, this can be done by updating the Recipients, Message, and…

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…