3954375

This should do it: CASE WHEN {checkboxvalue}='T' and {field1} IS NOT NULL THEN {field1} ELSE CASE WHEN {checkboxvalue}='F' and {comparisonfield}<50 and {valuefield}<({comparisonfield}+2.5) THEN {valuefield}+2.5 ELSE {valuefield} END END I have one question: if {field1} is null and the {checkboxvalue}='T', you want to get…

Assuming all fields are decimal number fields but the check box, and assuming the field for which you have your formula is store value false and also a decimal field, then this will work: CASE WHEN {checkbox}='Yes' and ({field1}) IS NOT NULL THEN {field1} ELSE CASE WHEN {checkbox}='No' and {comparisonfield}<50 and…

Also, you may want to simplify your code as well: if (parseFloat(amount) < parseFloat(currency)) { do ABC }else { do XYZ }

The SuiteScript's API doesn't give much here for that detail, but for SuiteFlows, the send email function limits the CC parameter to 1000 characters. I'm confident it is the same limitation for nlapiSendEmail.

Hi Ravi, You would need a script. If the goal is simply to have the info auto-populated after you submit your weekly page, then a user event script will do the work. However, dealing with time entries and especially weekly time sheet is a funky business. And here's why. One thing about the weekly time sheet is that there…

If I understand you correctly, you want to populate them on the time entry line item?

Hi Xenomate, As the others said, we would need to know more about the kind of script you are writing in order to help you more directly. In NetSuite, Request & Response occurs typically as Suitelet parameters. The write.('bablabla') method exist for the Suitelet nlobResponse parameter and 'babla' has to be xml, text or…

Then, you may benefit from reading the help about Suitelet, which has many detailed examples. What I can tell you, which should give you a good start, is that you need to have the following main structure for a suitelet: function mainFunction(request, response) { if ( request.getMethod() == 'GET' ) { // view mode var form…

Hi Ben, As MChamma and others has wisely advised, in order to know what goes wrong with a script, the method nlapiLogExecution is useful to track what goes on or not. For instance, here you may want to know if your var mailRec contains anything, as it is on this that you apply .getName() and .setName(). If there is nothing…

Hi there, I'm assuming here you are not citing in your post the whole code for your search, but only the relevant part you spotted as causing problem. The search filter field name is very probably not correct: for Sales Order or Invoices, you'll have 'datecreated' and not 'created'. But for the record type of Inventory…

Hi Dan, Behind Netsuite's nlapiXMLtoPDF, there is the work of the Big Faceless Report Generator (known as BFO): the documentation for nlapiXMLtoPDF has a link to its userguide. For images, on p. 38, you'll see that some of the TIFF subformats are not supported. So, the first thing I would do would be to try your code with…

A pointer with respect to a script or workflow will depend on the kind of criteria the action of sending the email must meet. If the criteria amounts to a simple check box, then go with the workflow. If the criteria is more complex than directly checking some field, then you will need a script.

Hi, 1. NetSuite has already some structure in the email address that is associated to cases. An email to a given case has indeed the following structure: cases.TSTDRV188066.XXX_YYY_WWW.NNNNNNNN@cases.na1.netsuite.com You'll find the first part and the last part in the address used by NS to create new cases in your account…

A way to have a log of emails send for employees, it is to use their internal id as the sender of the email. This will automatically attached the email to their employee record, and it won't if you use their email address. This options maybe possible with vendor internalid for the recipient field: I haven't tried with…

I believe you are right, you are not doing anything wrong and you found a bug. The proper formula should be using 'T' however in the first place. The work around you created is great and I don't believe there is much else to do. I would recommend you log a case at NetSuite.

Hi ddmdave, As khultquist said, a record of the deleted transaction remains in your audit trail. (cf. Using the Transaction Audit Trail in NS Help.). You may find sufficient information on the Audit Results Page, even if you may not undo the delete of the sales order. With respect with the larger point - are all deletions…

Hi, Make sure the initiating trigger context includes user event script (or don't select any context at all), and, you shouldn't have to call the workflow with nlapiInitiateWorkflow. Make sure that the workflow matches also the general event of on your Sales Order: a create or an update. Make sure the execution context of…

Can you detail the event and trigger context for both set Field Value? Best regards,

Hi Rodney, You can only set a field via Go To Record if go to a new Record, which is the case when you don't pass an internal id as parameter of the record to go to. This is what the help says. A script will certainly do the job. If you need help on this, you may give more details on the criteria must the previous PO…

Hi Andy, Regarding your issue, I would like to make the following points in the hope it will help you: 1. What does you workflow action script? It may interfere. Have you try to see if the worfklow sets the fields you want when that action script is inactive (I know it returns a value, but I'm sure you can change the…

The way I would try with workflow is this way: 1. In your workflow have a Return User Error action to be triggered on After Field Edit. Add a proper error message. In your client fields, select the PO# field of your SO. In the condition, use custom formula: there you will enter your javascript code 2. The code will look…

It doesn't really create a Sales Order: it brings you to a new SO page, with the possibility to have body fields initialized. But as long as you have not added at least one line item, and actually click save, you haven't created anything. Also, the workflow won't have any idea of the SO internal id, since it was not…

Can you give (me) more details on what you are trying to do, please?

This is doable in workflow to the extent that you are willing to use javascript. In edit mode, formula in workflow use javascript, which could do the search you want to execute. However, it will slow down the process. You would trigger your search when the PO field would be edited. Even though, due to parallel processing,…

Yes, it's because I thought your business process was using already created Sales Orders. I have edited the code to manage that case. Please, keep me posted.

You cannot create Transaction record in general with the Create Record functionality.

I'm glad it does! My pleasure!

Hi teuchere, You cannot do want you want by workflow on field edit - even with a workflow custom action script. You cannot throw an error on field edit as well. I have designed a solution for your situation, but, as I said, it won't throw an error (which I find not very user friendly). It will prompt an alert box and…

We need more and clearer details regarding the email action that doesn't work. Also, the details of the transition to the next state can be helpful. Finally, the log of your workflow on the record it is deployed would be helpful as well. I'm also unsure of what you mean when you write: the state that it enters into is from…

I understand you wanted 'to effectively place a freeze on an item fulfillment' and you Return an Errror to the user under certain conditions. Did you know you could also simply use Lock Record as action?