Francesca Nicole Mendoza-Oracle NSC Guru

Hello @Moe Bashir, Back-end tables can be accessed via ODBC/JDBC Connections if you have the SuiteAnalytics Connect license. As of now, reports created within NetSuite UI cannot be extracted via this connection. Instead, you have to build your reports within the third-party application using SQL queries. To get started,…

Hi @Owen Ramirez, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter. 

Hi @User_WM3MD, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support.

Hello @User_ETZRS, A gentle follow up on this.

Hello @User_ETZRS, Please provide a copy of the saveRecord function of the Client Script: customscript_14552_entity_details_cs so that we can provide further support. Thank you!

Hi @Fabss, Good day and thank you for posting this new thread! Hello everyone! Recognizing your expertise and knowledge, we kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.

Hello @User_76ANW, Good day and thank you for posting this new thread! Hello everyone! Recognizing your expertise and knowledge, we kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.

Hello @gbradley, Good day! Please follow these steps: Double click State 1. There should be an action called "Set Field Value" for the field Memo there. Click on its Name column to open the action. Under condition, input the following values: Record = Customer (this is equivalent to join, so that it is sourcing the…

Hello @User_7NEDX, Did the solution I provided in the previous comment work?

Hello @User_7NEDX, This message could be prompted by either a client script or a workflow. You can check which scripts and workflows are running for the JE Record by navigating to Customization / Scripting / Scripted Records. If client scripts are present, look for alert() functions within the script. If via workflow, look…

Hi @RS_RS, We can't provide a script from scratch but you can use this SuiteAnswer Article Detect Duplicate Items in Sales Order via Script as reference. function beforeSubmit(scriptContext) {‌ //load current record, and get item count var rec = scriptContext.newRecord; var counter = rec.getLineCount({‌ sublistId: 'item'…

Thanks for responding, @CDuf!

Hello @User_FL4CK, Thank you for posting in NetSuite Support Community. Can you please provide more details?

Hello @Nickey, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter. 

Hello @JohnnyF, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter. Thank you @Edwards_05 for your quick response!

Hi @FazeprooF, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated.

Hello @Sven VdB, I believe @CDuf is right. I tested this via workflow but it doesn't set the field to mandatory. It isn't possible via script unless you're opening a record in edit mode and you get the record's field values in the beforeLoad function and set it to mandatory at that point. Otherwise it isn't possible. I…

Hello @User_FHYZH, Apologies for the delay. Upon further checking, custom item number fields are not yet exposed for SuiteAnalytics Connect. It has already been requested as an enhancement under 668218 SuiteAnalytics: Connect > Records Catalog > Visibility of custom fields on Serial/Lot Number (inventoryNumber) table. To…

There doesn't seem to be a native way to do this as of now. There is also no existing enhancement for this so feel free to file it as a SuiteIdea if you please. Thanks!

Hi @gbradley, Do you still need assistance regarding this concern?

Happy to help! Thanks for letting us know.

Hello @Jeroen Sprangers ZS, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated.

Hi @R. Dieka Pribadi G. E., Good day and thank you for posting this new thread! Hello everyone! Recognizing your expertise and knowledge, we kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.

Hello @_Naresh_-Oracle, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter. Your willingness to assist a fellow member doesn't go unnoticed and is sincerely valued.

Hello @emcee_uk, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated.

Hello @Eklon Eleuterio, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated.

Hello @R. Dieka Pribadi G. E., Good day and thank you for posting this new thread! Hello everyone! Recognizing your expertise and knowledge, we kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.

Hello @tech work, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter. Your willingness to assist a fellow member doesn't go unnoticed and is sincerely valued.

Hello @rburns515, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated. 

Hello @Angela Bayliss, Sending the photo here: Seems like the workflow was updated via workflow. There could be an underlying condition to trigger the change so it would be best to check the log, which is the hyperlink in the Log column of the Workflow History sublist or the Workflow itself. Sample: