pradeep.r.s

Faced the same issue & on setting the line id to 0 on all the payment lines resolved the issue. deposit.setSublistValue({ sublistId: 'payment', fieldId: 'lineid', line: h, value: 0 });

in Same script to create Deposit gives me error RECORD_HAS_BEEN_CHANGED in prod but not in sand? Comment by pradeep.r.s Jun 25, 2022 3:30AM

Thats correct... or use TO_CHAR({trandate}, 'YY/MM/DD') to convert date into YY/MM/DD

in How to convert date in a search to YYMMDD? Comment by pradeep.r.s Mar 28, 2014 1:44AM

Hello, Yes you can rearrange the column sublist fields in custom transaction form. https://netsuite.custhelp.com/app/answers/detail/a_id/10110 click on the above suite answer link and read the post. Point no 11 will describe how to rearrange the column fields.

in Rearranging Columns in sublists? Comment by pradeep.r.s Jul 16, 2014 8:03AM

Hi eleran, Could you give some more details like, when you exactly want to send email(example: On customer save or custom record save).

in Custom Record Types and Customer Records Comment by pradeep.r.s Mar 3, 2014 5:47AM

Hi eleran, Make the "Record is Parent" check box true in customer # field in the custom record.

in Custom Record Types and Customer Records Comment by pradeep.r.s Feb 25, 2014 11:24PM

Hi eleran, As per my practice, you can deploy a userevent aftersubmit script in customer record to send email. Refer the below code. If you want to send email only for the new employee added in the line(not for the existing line in the sublist). You have to create a check box in the sublist, check for false before sending…

in Custom Record Types and Customer Records Comment by pradeep.r.s Mar 6, 2014 2:32AM

Hi jonke, Saved search alert won't work if we add line in Child record subslist. It will work if we click on "new child record name" to create a line from parent record. Kindly check and revert me if im wrong.

in Custom Record Types and Customer Records Comment by pradeep.r.s Mar 10, 2014 4:40AM

Hi Mirza, U can try this 'nlapiSetLineItemDisabled('item','custcol4',true, i);'

in hide fields in Transaction record Comment by pradeep.r.s Jun 26, 2013 7:24AM

Hey Jokell, Try newActualsRecord.setFieldText('custrecord_fy', 'FY 2016'); What is the "custrecord_fy" field type? If it is the List/Record Type with Accounting period, you can search for the name 'FY 2016' in Accounting period record to get the internal id and do set field to "custrecord_fy". else explain me more about…

in Getting the current fiscal year? Comment by pradeep.r.s Nov 18, 2015 4:38AM

Hi All, Just a small hunch. If we enable both id and name in custom record then id - {name} & Name - {altname} will be the id we have to use in script. Correct me if im wrong.

in Searching a custom record by the "name" field Comment by pradeep.r.s May 11, 2015 6:11AM

Hi just add "billingSubrecord.setFieldValue('override','T');" in the code.

in Transaction Custom Address - Script Doesn't work Comment by pradeep.r.s Mar 20, 2015 3:19AM

See SuiteAnswers Answer Id: 33426 to "Add and Update Customer Address via SuiteScript".

in suitescript to create and update address book record for customer Comment by pradeep.r.s Mar 10, 2015 7:33AM

Hi Arun, instead of "var depositAmountRow = depositAmount[1]" use "var depositAmountRow = depositAmount[0]". As we will get only one result, we need to use 0 in the result array.

in Returning Value from Existing Saved Search Comment by pradeep.r.s Jan 29, 2015 7:37AM

Hi Linda, In portlet script the field id (custpage_text) is same for salesrep field. It should be unique for each field. Try the below code. function demoSimpleFormPortlet(portlet, column) { portlet.setTitle('Lost Sale Portlet') var fld = portlet.addField('custpage_text','text','Companyna me');…

in Script Help for suitelet and portlet simple form Comment by pradeep.r.s Jan 23, 2015 1:08AM

Hey, If you have deployed server side script on the custom record then mark RUN SERVER SUITESCRIPT AND TRIGGER WORKFLOWS check-box in CSV Import Preferences (Setup > Import/ Export > CSV Import Preferences) to create journal entry.

in How to invoke script call with CSV import of custom record Comment by pradeep.r.s Jan 27, 2015 8:12AM

Try this field id - "quantityfulfilled" to get fulfilled quantity i.e lineLevelQuantity = nlapiGetLineItemValue('item', 'quantityfulfilled', i).

in Script to Total Quantity Fulfilled for a Sales Order Comment by pradeep.r.s Jul 10, 2014 2:07AM

Hi, If we change the content type to 'PDF'. Suitelet will download image file. response.setContentType('PDF','Gallery.jpg', 'attachment');

in Create image download from suitelet Comment by pradeep.r.s Jul 15, 2014 1:05AM

Cheers!!!!!!!!

in Pivot Report Suitelet Comment by pradeep.r.s Mar 27, 2014 1:10AM

Hi, (Copied from Netsuite Help)Best Practices: Users should be doing post-processing of the current record on an afterSubmit. Use Case: 1. Load the record you want to make changes to by calling the nlapiLoadRecord API. Do NOT load the record object by using nlapiGetRecord, as this API returns the record in READ ONLY mode;…

in Script loop on time sublist for Invocies Comment by pradeep.r.s Mar 27, 2014 4:51AM

Hi sheetal, R u trying to show saved search values in suitelet sublist or adding fields in sublist as per the formula field in saved search.

in Access Formula field in Suitelet sublist of saved search Comment by pradeep.r.s Mar 27, 2014 7:49AM

Hi Sheetal, First create sublist. sublist.addField('tranid','text', 'Number'); sublist.addField('amount','text', 'Amount'); sublist.addField('type','text', 'Transaction Type'); sublist.addField('label', 'text', 'Formula Text'); Then add values from saved search to the sublist, if(results.length>0) { for(var i=0;…

in Access Formula field in Suitelet sublist of saved search Comment by pradeep.r.s Apr 14, 2014 7:34AM

use 'trandate' instead of 'date' in the code. var date = reportDefinition.addColumnHierarchy('trandate','Month' ,null,'DATE'); columns[2] = new nlobjSearchColumn('trandate',null,'group').setFunction ('month'); reportDefinition.addSearchDataSource('transaction'…

in Pivot Report Suitelet Comment by pradeep.r.s Mar 26, 2014 7:16AM

Cheers steve ;)

in Search for ChartOfAccounts InternalId by Account Name Comment by pradeep.r.s Mar 20, 2014 1:36AM

Hi Steve, Use the Below code to return internalId. I just used case when like in filter. var filter=new Array(),internalId =''; filter[0]=new nlobjSearchFilter('formulanumeric',null,'equalto','1'); filter[0].setFormula("case when {name} like '%4000 Goods and Services' then 1 else 0 end"); var…

in Search for ChartOfAccounts InternalId by Account Name Comment by pradeep.r.s Mar 19, 2014 5:10AM

Hi, use the below code to generate CSV on button click. function userEventBeforeLoad(type, form, request) { if(type=='view') { form.setScript('customscript91'); form.addButton('custpagebutton1', 'Export CSV', 'exportcsvclient()'); } } function exportcsvclient() { var url=nlapiResolveURL('SUITELET','customscript91'…

in Script to Export Data from Work Order Record to CSV Comment by pradeep.r.s Feb 24, 2014 4:02AM

Hi I solved the similar case using clientFieldChange and clientLineInit function. Try the below code. /** * script : Client Script - Field Change * Functionality : On location change, add location in items sublist. */ function clientFieldChanged(type, name, linenum) { if(name=='location' && type!='item') { var…

in Script that runs on a sublist only the first time a line is added? Comment by pradeep.r.s Mar 3, 2014 5:14AM

Hi Ben, Use toString().replace() function which will add comma to the currency value. Use the below code. function numberWithCommas(x) { return x.toString().replace(/B(?=(d{3})+(?!d))/g, ","); } function ASIP_NEW(portlet, column) { portlet.setTitle('Assessment Services Information - New') //var today = new Date(); var…

in Format Currency value with thousand seprator Comment by pradeep.r.s Feb 12, 2014 4:54AM

Cheers Ben!!!!!

in Format Currency value with thousand seprator Comment by pradeep.r.s Feb 12, 2014 5:23AM

Hi Klaus, I think your are trying to get the item record field values.You can't get the item record field values directly using nlapiGetCurrentLineItemValue(). You have to load or lookup the item record to get the field values. Try the below code. function validateLine(type) { // Only validate the 'item' sublist if (type…

in Client SuiteScript on line item throws NULL Comment by pradeep.r.s Jan 24, 2014 4:33AM

You make the check box disabled while creating the sublist. Then deploy a client script Line init function in the suitelet by using form.setScript(). In line init function, you just enable the field using nlapiDisableLineItemField('sublistid','fieldid',false) if the status is not approved. This way you can achieve this.

in Suitelet Sublist Disable Field Comment by pradeep.r.s Jan 23, 2014 7:03AM

pradeep.r.s Bronze Medal

Comments