Francesca Nicole Mendoza-Oracle Gold Crown

Hello @User_NG5TG, Glad to have you with us today! Our ERP 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 community.

Hello @Ray Mart-Oracle, NetSuite is currently not capable of the feature you're looking for. As for the DOM-manipulation approach, SuiteAnswers Article 43586 says that NetSuite does not support direct access to the NetSuite UI through the DOM. There may be a workaround for it as I have seen some accounts with customized…

Hello @User_1J19L, You can use the N/search module to create, load, and run a saved search via script. For more information, you can visit SuiteAnswers Article 43702 N/search Module and 95069 N/search (Sample Codes). One of the sample codes from Article 95069 shows you how to search for customer records. You might also…

Hello @Vernita, I've tried my best to get this to work but I have not been able to get any success either. It would be best if you could create a case record for this with NetSuite Customer Support so that they can look into it further. Thank you.

Hello @Keith Boatner, Per checking, SCIM is still not supported by NetSuite right now. There is no news on when this will be back as well. I also checked our 2023.1 Release Notes (SuiteAnswers ID: 90043), but it is not included in the list of changes.

Hi @User_C5N4B, Editing native field IDs in NetSuite is not supported. Custom fields, however, can be modified but not in the Records Catalog. You can check out SuiteAnswers Article 42612 Editing a Custom Field for the guide on how this can be done. Hope this helps!

That's great! Thank you very much for letting us know.

Hello @User_C5N4B, It is currently not possible to modify field IDs in the Records Catalog.

Hi @Dwight Schrute, 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. Hopefully this is not as tricky as it seems!

Hello @Dwight Schrute, Glad to have you with us! This sounds like a concern that our Supply Chain Specialists can help us with. Tagging our Supply Chain Gurus: @Joy Noreen Magoling-Oracle, @Elychelle Gulen-Oracle@ Thanks!

Hello @User_UY6JW, Interesting question! I've already notified our gurus for them to look into this. We'll get back to you shortly. 😊 To our fellow members, please feel free to join in the discussion!

I'm sorry to hear that, @User_V5KBL. I'd love to assist you but it is against our policy to provide script solutions from scratch. I suggest that you reach out to your in-house developers if you have any, or to our Advanced Customer Solutions (ACS) Team if you availed ACS in your account.

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.