Hi @easterwoodc , Record Type should be Customer and internal ID should be blank when creating/adding new record/customer. -Mikko

Hi @Michael Shparber , the field 'parentexpensealloc' or Created From Allocation is not exposed to ODBC. You may submit an enhancement request for the field exposure on SuiteAnalytics. However, you may want to create a script to source this field to a custom field and query the custom field instead. Would this be feasible…

Hi @Asher_123 , all options are listed in this article . The condition to include that are not nulls can be done in your script logic itself. -Mikko

Hi @User_1522F , May we ask what integration are you using? E.g RESTlet, SOAP Web Services, SuiteAnalytics Connect, REST Web Services, ETC. You may want to check Records Browser to see if the field you want to script is scriptable. -Mikko

Hi @User_EX8O2 , Please be aware that the data contained within the Suitelet will be less secure when it is allowed to be accessed (via Suitelet execution) without login. Additionally, your concern is related to this Enhancement # 489317 - Provide SuiteScript API for safe and scalable CORS implementation in "scriptlet"…

Hi @Michael Shparber , Thank you for posting again in the community! Our gurus/members will look into your concern and update the thread for any findings. To everyone, feel free to share your insights. -Mikko

Hi Hillary @Hillary_S , Welcome to NetSuite Support Community and thank you for posting in the community! Our gurus/members will look into your concern and will update the thread for any advise. Hi @Dominica Sevilla-Oracle /@Elychelle Gulen-Oracle , any thoughts came to mind?? To everyone, feel free to share your ideas.…

Hi @Eklon Eleuterio , Thank you for tagging me and I am glad to be of help. I'll check on your new concern and update this thread for any relevant findings. -Mikko

Hi @User_HLBJF , We do not have information for future releases yet but it will be posted on Release Notes if there are any updates for this. -Mikko

Hi @JJ Lucarelli , This is a standard behavior. Could you confirm if the sign are the only difference but you get the same amount when querying vs using saved search on the UI? -Mikko

Hi @Bryan Carroll , does using postSourcing function be feasible on your end? -Mikko

I understand the feelings you are going through. However, it is best to continue coordinating with support team and give them more information on the impact in your day to day business. To why the customers were moved to OCI, this is best to coordinate with your Account Manager as they could explain it better and they have…

What I meant by checking if it has access to transaction is via NetSuite User Interface and not via SuiteAnalytics Connect. Login in the NetSuite UI using the user with custom role and see if it can access transactions. All available permissions are listed in this article. Also, could you share the setup for the custom…

Thank you for clarifying. I am still checking and currently encountering the same situation. I would advise to instead of using windows functions, use available native NetSuite API functions that would pass variables from Suitelet to the current record open. -Mikko

Hi @David23 , Customer Payment record is not listed on supported records for REST Web Services yet and still on Beta feature. We would not advise to make use of this specially on critical business process. See articles for Supported Records. SuiteCloud Supported Records REST Web Services Supported Records -Mikko

Hi @dsato , may we ask what are the things you have tried so far? Also, have you contacted Workday? There is an article with similar error but different application. Workday might have similar configuration and it would be best to coordinate with them. See external article for reference. Please note that this is not…

Hi @David23 , Can you provide sample on how you query with datetime. You may check this article for sample datetime field related values. -Mikko

Hi @Michael Shparber , Is the role you are using can login on the NetSuite UI? If yes, can you check if it has access on transaction? Also, what you can query on the odbc is the available tables that can be access for that specific role. If you want to see the structure even if the role does not have permission, you may…

Thank you for providing this information. Just to add, what internet browser are you using and if you have tried on different browser? Also, on what function and script type are you working on? -Mikko

That should be possible. Just remember the configuration on your ODBC data sources system DNS on what to use when connecting on specific data source. -Mikko

Saved Searches formulas' functions mostly listed in that article and maintained in Oracle database SQL reference. Also, there is an old discussion thread which members share formulas. See 100 Ways to Use Formula Fields for reference. I hope this helps. -Mikko

Hi Maurice @Maurice Shallow , Thank you for posting in the community! Please allow some time for the gurus/members to check on your concern and update this thread for any findings. To everyone, feel free to share your insights. -Mikko

Hi @SAConsulting , Thank you for posting in the community! Our gurus/members will look into your concern and get back with more information. Hi @Ivy Lopez-Oracle /@Joy Noreen Magoling-Oracle , any thoughts to share? To everyone, feel free to share your knowledge. -Mikko

Hi @Dwight Schrute , Thank you for posting in the community! This may require complex solution so we advise you to coordinate with your Account Manager to discuss the requirement with the Advanced Customer Support or Professional Services Team. To anyone with similar customization as the topic, we encourage you to share…

Hi @dsato , Thank you for posting in the community! To anyone experienced the same situation, we encourage you to share your insights. -Mikko

Hi @AnCaMc , May I ask if you already submitted a case to support team and if there is an issue filed already? This might be related to a known issue( #672782 - Performance > Multiple record slowness). It is best to coordinate with support team with regards to this matter. To anyone experiencing the same concern, it is…

Apologies for the confusion, the sample syntax provided was for Inventory Numbers alone and Bin SearchAdvanced is for Bins alone. The Inventory Numbers and Bin Search is not exposed on Web Services and SuiteScript. There is an enhancement request for SuiteScript. However, this is different request from SOAP Web Services. I…

How's it going, @srussell ? -Mikko

Hi Sam @Sampath Kumar Rudra , On what method you placed the HTML snippet? Could you also share the sample code you are working on and please exclude confidential information. -Mikko

Hi @Paul Salkeld , could you share the sample code you are working on? Please exclude confidential information. E.g Account Id. -Mikko