Francesca Nicole Mendoza-Oracle NSC Guru

Hello @chonchanan.p, Thanks for pointing that out. It was due to a mismatch in the formatting in the SQL statement. To ensure that your formats match, you can add another parameter in the TO_CHAR() function. I did some digging online and found a helpful documentation in this link: Here's the before and after of the testing…

Hello @User_V5KBL, Good day. I'm Nicole, Patrick's fellow guru. I've tested this via script and found that it is possible to update the value of the role in the "Resource Details Sublist". The technical name for it is "jobresources". Here are some screenshots from the test I did: Before script execution: After Script…

Hello @User_C5N4B, Hope you're having a great day! Did you get a chance to test the solution provided in my previous comment? Thanks!

Hello @User_7D2KD, 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!

Another sample:

Hello @chonchanan.p, May I know if the workaround provided from the related thread you mentioned did not work? Just to bump it here, this is how the your SQL query would look like: SELECT TOP 10 * FROM "NS Connect"."transaction" WHERE to_char(lastmodifieddate) = '2016-06-16 18:50:50' I tried this solution and it works on…

Hello @User_C5N4B, All the field IDs in the SQL/JDBC Connection should be the same as the those in the Records Catalog. To open the Records Catalog, use your administrator role and go to Setup > Records Catalog or https://system.netsuite.com/app/recordscatalog/rcbrowser.nl. The arrangement might be different but most or…

Hello @User_NLK5H, 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. Thanks!

Hello @Vernita, This is feasible. There is a record type in NetSuite called "Customer Deposit". The attachment below shows how I did it in the UI so that you'd have a better view of the flow. I have not written a code for customer deposits but I've checked the records browser and I was able to confirm that Customer Deposit…

Hello @Chad C, Interesting. You can check what scripts ran for a specific date range by going to Customizations/Scripting/Scheduled Script Status. It should look something like this: Note: This is a Map/Reduce Script Status because I have no scheduled scripts running in my test account but it's almost the same thing.…

Hi @User_C5N4B, Can you confirm if the solution from my previous comment worked? Thanks!

Hello @User_C5N4B, It appears that you only have permission for SuiteAnalytics Connect for this role. In order to have access to other tables that require specific permissions, those permissions must be maintained to the role you are using for SuiteAnalytics Connect. First, you must add 'Find Transaction' permission as…

Hello @Martha Hakes, 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.

Hello @Mudassir Khan, I'm Nicole, one of the SuiteCloud gurus on the team. The address sublist is called the "addressBook" while the address sub-record is called "addressBookAddress". In the sample below, I highlighted the fields for the sublist in red while the fields for the sub-record are in yellow. I created two…

Hello @User_C5N4B, This is a gentle follow-up to this thread. Feel free to reach out if you still need assistance. Thanks!

Hello @SIlvio Bruckmann, 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 @Chidi Okwudire, Thank you very much for posting this! This will surely be handy for our users.

Hello @Brian D-Oracle, Thanks for posting this new thread. Please allow our gurus and members some time to review and investigate this concern. We will get back to you with more information. Our users, please feel free to provide us with your insights or suggestions! This means a lot to this community and to us.

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!