Mark Rhyman Blue Ribbon

I think Sklett is pointing in the right direction. We have a functionality that needs to send multiple SO to a customer in one click of a button. Therefore we build up our own PDF and then in a loop we Attach all of them to one email. We even have a check to see if we reach the NetSuite 5Mb Limitation per email and then we…

You can do this if you use a Client Script deployed Opportunities. There are some ways to do this but one way would be on Page Init you would prevent the change to be done to the Status field. Then use another function on Field Change so that when the checkboxes changed from F to T, you can enable back the Opportunity…

DEbugger has been behaving like that for, I would say the past month. It's on and off. Sometimes it will fire and sometimes not. Sometimes it will even fire but not break at the first execution. Try Clearing your cache, closing your browser and try again. Sometimes it helps. This complicates just a bit scripting :rolleyes:…

Hi, Here is what I would have done: 1. Trace your code using nlapilogexecution to get the value of each line item value. 2. Comment one by one the search filter and run your script to know which one fails. Let me know how this works and the we can debug futher. Regards,

I suppose that you are doing something like: response.write(str); where str is a string an looks like: str = 'something' + '<br>';

True. You are getting this error because rate is a line item field and not a body field. What about using the client script to simply revert the rate?

If you really want to use the User Even you can try something like this: function beforeLoad(type, form) { nlapiGetLineItemField('item','rate',1).setDisplayType('disabled'); } This will disable the date on line item 1. You can have a loop if you are editing an already create SO to disable all rate column. When creating a…

With a Client Script you would be able to do a validation on that script and prevent modification to it. One way you can do it is, On Field Change you simply revert the value back to the original value before modification. If you would like to use setDisplayType, this is not available in Client Scripts. You should use a…

You can have something like the code below for a Submit Button: var submit = form.addSubmitButton(); submit.setLabel(Submit); For other kind of button you can define their actions in a client script and when you create the script record, you must go to the Buttons Subtab and Add the button labels + their functions there.…

Hello, You would need a client side script that checks that fields for the two criteria. First you would do something like: var myString = nlapiGetFieldValue('yourfieldid'); var length = myString.length; //this gives you the length of the string. if (length != 3) { alert("Length must be 3); } Second you want to include the…

If I understand correctly, you want to Check and Set Class on Sales Orders before saving the record using Before Submit, right? The part I am not certain I understand is the Bulk Billing. In order to set classes on all Orders, I would have used a Scheduled Script instead.

Hi, True the JavaScript by default will replace the first occurrence. Try this workaround and let me know if it helps. var test_string = "Testing Javascript Replace"; var new_test_string = test_string.replace(/ /g,”,”);

Tha'ts kind of strange. Maybe nlapiEncrypt is not using SHA1. If you go to http://sha1.web-max.ca/ you can decode your SHA1 code back to 1234 whereas the code generated by nlapiEncrypt does not decode to anything.

You can try to use the nlapiGetContext().setSetting(type, name, value). If that does not work, what you can do is to use a custom field and place your parameters there and then in your script get the value of that field and use it as parameter.

Let say you have a string defined like that: var companyName = "Company ABC Ltd."; if you want to replace the white spaces, simply do: var newName = companyName.replace(" ", "%20");

Could you try to use filters[0] = new nlobjSearchFilter('internalid','message','is',messageid); and if that does not work try filters[0] = new nlobjSearchFilter('internalidnumber','messages','is',messageid);

I am glad you could figure this out. You are on the right track here. Will those fields contain strings ever? If no, why not set them to their default purpose but setting them to Currency instead of Text? Just be careful if you change the Field type from one format to another.

Hi Matt, In your IF statement you should use || for the OR in your script you are saying: If custrecord58 OR custrecord59 changes get value from custrecord58 get value from custrecord59 set value of custrecord60 Can you let me know what errors you are getting, after you update the IF statement? If that can help here…

I am not sure if this is what you would want but in NetSuite if you go to Home -> Set Preferences you can change the date format from YYYY/MM/DD to MM/DD/YYYY.

Working with dates can sometimes be tricky. What I would do is to first make sure the value you have is a date format by using var theDate = nlapiStringToDate(nlapiGetFieldValue('fldname')); Then you can define var one_day = 1000 * 60 * 60 * 24; and perform the following calculations: var dateDiff =…

Hello, For a start here's some info that might help you. First of all you need to write a client script: Next you will probably want to apply the script to Field Change function in the New Script page. Next in your script you should start with something like: function fieldChanged_calculateSomething(type, name){ try { if…

Hi, nlapiGetCurrentLineItemValue takes two parameters: type,fldname Therefore you should call it like: nlapiGetCurrentLineItemValue(item,rate); You are mistaking it with: nlapiGetLineItemValue where you have to specify the line number.

Hi. What is the error you are getting? In your last if statement you wrote: if (n_count == n_linesclosed) shouldn't that be if (n_icount == n_linesclosed) //you are missing the i in icount.

Hello Mark, Unfortunately I have not seen any way that you can Export all the information in each Shipping Item. Nor have I seen the possibility to Import Shipping Items. Good Luck.

Hello Penny, You can achieve this with a bit of customization. For example, you can import anything you want in a Custom Record. Then with a Script you can convert those imported records to PromoCodes very easilly. Best Regards,

I have not seen the possibility of ever importing two customer records at the same time. I think you would have to do a two phase import process, once to add the records, and another one to update the records (i.e. associating the links between parent and child).

Might be a headache without scripting. Not 100% sure how you would do that. Why don't you want a small script? Regards,

Basically check the GL impact on the Invoice. It will most probably post to some Accounts Payable & the account defined on the Item Record. I'm glad it worked for you. Have a good day.

Where it says (on the right in NetSuite Fields) + Invoice Items, it says Item (Req). What exactly did you match that column to in the csv? Basically you must have Item (req) matched to an Item Column in your CSV or you MUST provide a default one by clicking on the Pencil icon and provide a Default Value. If that does not…

I know if you go to the Fulfill orders Screen you can create invoices in Bulk from there (most probably if you have Pick - Pack - Ship it's gonna be different). Are you looking to send those invoiced by email ? Regards,