If I wanted to save the custom record once the field values are set, how would I do that? (without the user clicking the save button?) I would want the save record to occur just after: objRecord.save({ enableSourcing: true, ignoreMandatoryFields: false, }); }

Hi @Joahnna Given Uy-Oracle thank you for your detailed instructions. I have tested this and am not getting a value on the invoice record. One thing I wanted to check is why the contract field on the project record needs to be populated with a workflow? At the moment, I am able to have this pull information directly from…

Is there a way to submit a record without the user pressing the 'save' button? E,g, in this case, for a function to be created on the client side that submits the record to the database essentially 'mimicking' what would occur if the user were to click the save button and submit the record to the Netsuite database

Hi @Joahnna Given Uy-Oracle Yes, I would like details from the sub customer and the project record on the invoice header. In terms of the fields in question, they are custom fields on the sub customer and project record. The fields I am trying to source on the invoice are : From the project record, a field with id:…

Sorry, I am not too sure I understand @Mikko De La Fuente-Oracle . So the part of the client script function to set field values (function executeRecurring() ) is working as expected. The values are being set. It's the page reload that isn't working. Or is that what you mean? That a function to reload the custom record…

Hi @Joahnna Given Uy-Oracle Did you want a screenshot of the sub customer or project record? or for the advanced pdf template source code?

Hi @Dominica Sevilla-Oracle I am using an advanced pdf printing type

Hi @Michelle Jabanes-Oracle I was able to log a call with Netsuite to get this resolved. What I was trying to do was set up a DKIM in production after making the sandbox one inactive. What I hadn't realised is that I need to create a different domain selector and not re-use this between the two environments (even if it…

Hi @Erick Dela Rosa-Oracle I was able to extract the value from a message field and store it in another field (custevent_case_creation). I then had a workflow action script that looks up the record referenced in the workflow state field(custevent_case_creation). and stores it against another…

Thanks Erick I am still trying to work through getting this formula into a script. I will let you know if this works once I am done testing.

Thanks @Mikko De La Fuente-Oracle I am currently looking at a few different options to achieve what I need... One of the other things I wanted to look at is the use of a Suitelet to capture information from the user and create create transactions. From my research on Suitelets, I can find information about it being used to…

Hi @Mikko De La Fuente-Oracle The only functions I can see from the moment library is // Moment prototype object function Moment(config) { copyConfig(this, config); this._d = new Date(config._d != null ? config._d.getTime() : NaN); if (!this.isValid()) { this._d = new Date(NaN); } // Prevent infinite loop in case…

Thanks @Mikko De La Fuente-Oracle Is there a way to have validation on the line so that it can only be committed for the quantity available? Anything above that cannot be saved?

Hi @Joy Noreen Magoling-Oracle I have found that even after the transaction is saved, the quantity for back order is not updated on the transaction. Or in this case, there is reference to the item being on back order if you create another transaction with the same item. However, the back order column is not populated on…

Hi Jack I haven't had a chance to test this yet sorry. I will do and post the results here. Thanks

Thanks Erick. Would a script use the same formula functions as, for example, a saved search? I have currently got a saved search formula which uses REGEXP_Substr which correctly extracts the value of the sales order number from the 'message' field. I'm not sure how that would be used in a script so that the extracted value…

Hi Ivy I realised why the issue was occurring. I had toggled the auto numbering feature on and off which was causing the name to appear in the hierarchy format. I switched it off and so didn't get a chance to test the formula sorry. I will mark this as answered as this does seem to be what I was after :) thanks

Hi Mikko. Did you mean checking the original third party library to see if there is a function or the script calling the function? With the script calling the function, this is the script being used: /** * Prompts the user if the current project has not been re-baselined in some time * * @copyright 2020 Stoic Software, LLC…

Thanks for looking into this @Joahnna Given Uy-Oracle Is this something that can be scriptable?

Update: It looks like when the email case capture first occurs, the html code and other elements of the original email are preserved. This is what is affecting the workflow. The workflow is applying the rule to the html version of the email and not the plain text version which is stored with the case once it is created. Is…

Thanks @Jack Daryl Espiel-Oracle I have noticed I am getting a different result for the exact same email message depending on where it is sent from When the email is converted to a case, the images or other elements of the signature are not preserved. What is it looking at in that case to classify this differently? These…

Hi Jack I am testing this in Sandbox (apologies I did not mention this earlier). I have found the cause of the workflow failing, I created the case in the UI and found that I received an error message on invalid syntax. I have corrected the formula. It previously was using either 0 or null in the case when statement…

With the internal ID of the base record, is there a way for this to be set to an array? The workflow needs to be initiated for more than one record. Basically, the script needs to be running continuously (every 2 minutes for example) on existing records. This will apply to more than one record. If I can store an array of…

Sorry @Jack Daryl Espiel-Oracle , I forgot to include a screencap of the case created via email capture:

Hi @Jack Daryl Espiel-Oracle I had amended the workflow to the following However, when I do, the email case capture fails to create case records. It only does when it is set to 'testing'. I had tried one other variation on the workflow: 1 I changed the status back to 'testing ' 2 Changed the workflow triggers to 'All'…

This is the case profile that relates to that email address The message creating the case I sent an email to the email address under the field inbound email address (on the case profile screen). A case record was created from that. Is that the information you were wanting for the email captures? EDIT: I have changed the…

Hi @Joahnna Given Uy-Oracle That is correct. The 'case issue' field doesn't populate once the record is created through the email case capture. If I create a case through the UI, when I save the record, the field value for 'case issue' changes to 'returns' in line with the workflow. The case created through the email case…

Looks like once the summary fields are taken out, the code seems to work. Posting it here in case it helps someone else: /** *@NApiVersion 2.x *@NScriptType ClientScript */ define(["N/search"], function (search) { function pageInit(context) { var customerSearchObj = search.create({ type: "customer", filters: [["stage",…

HI Jack So this will work when the email case capture first initiates and creates a case? I am currently stuck with the testing as somehow the email case capture has stopped creating cases

I don't actually know how to do that sorry so haven't been able to