pradeep.r.s

Hi Ravi, whether the text field has opportunity 'tranid' value??? use this, var filter=new nlobjSearchFilter('tranid',null,'is',opid); . . . nlapiSetFieldValue('customrecord86', 'custrecord23', opp_id);

in Opty number updated from Free from text to List field in custom record Comment by pradeep.r.s Aug 2, 2013 5:04AM

Hi Ravi, Just try this, var filter=new nlobjSearchFilter('tranid',null,'anyof',opid); var searchresult=nalpiSearchRecord('opportunity',null,filter,null); if(searchresult!=null) { var opp_id=searchresult[0].getId(); } nlapiSetFieldValue('customrecord86', 'custrecord21', opp_id); ----------- Pradeep

in Opty number updated from Free from text to List field in custom record Comment by pradeep.r.s Jul 29, 2013 11:43PM

Hi Liam, Add value for amount and try... B'coz without amount we cannot add item in Purchase order.... Pradeep

in Line items not commiting Comment by pradeep.r.s Jun 28, 2013 6:42AM

I tried a small piece of code on Assembly item Component Sublist. But It didnt worked. function validateInsert(type){ if(type =='member'){ alert('hi'); return false; } } Hi Madhur, Could you tell me what you selected in Script Deployments 'Applies to'. I can't found 'Build/Assembly item' in script deployment applies to.

in Validate insert not working on Assembly Item Component Sublist Comment by pradeep.r.s Jun 20, 2013 1:35AM

Your code is working for me..... Im getting 'Hi' alert....

in Validate insert not working on Assembly Item Component Sublist Comment by pradeep.r.s Jun 24, 2013 1:56AM

Hi Shrinivas, Instead of adding URL field you just add a text field and use href attribute in the field value. Try the below code. var col = sublist.addField('custpage_sublist_url', 'text', 'URL'); var URL = "http://www.netsuite.com"; for(var k=1;k<5;k++) { var link = '<a target="_blank" href="' + URL + '">' + k ;…

in How to create url link column in sublist? Comment by pradeep.r.s Nov 25, 2013 10:41PM

Hi jwenzer, In view mode try to load the record and get the value. i.e var recordload=nlapiLoadRecord(nlapiGetRecordType(),nlapiGetRecordId()); var formvalue=recordload.getFieldValue('customform');

in How to get the Form ID in Before Load Function of User Event Script? Comment by pradeep.r.s Nov 22, 2013 5:25AM

yes you need to customize and add new fields to the form, if there is no out of box field.

in Adding extra fields to custoemr records Comment by pradeep.r.s Nov 19, 2015 12:19AM

Hi DB, There is no NetSuite Standard PDF print for Vendor Bill. So, you have to create PDF file using nlapiXMLToPDF() and attach the file in nlapiSendEmail().

in Send vendor bill as attachment Comment by pradeep.r.s Feb 24, 2014 4:37AM

Hi Jarrod, Refer the below links. https://netsuite.custhelp.com/app/answers/detail/a_id/30748/kw/Mass%20Update%20on%20a%20custom%20field https://netsuite.custhelp.com/app/answers/detail/a_id/25373/kw/Mass%20Update%20on%20a%20custom%20field

in Mass Update Comment by pradeep.r.s Jan 21, 2014 6:16AM

Cheers!!!!!!!! scottr

in Total Available - Transaction Column Comment by pradeep.r.s Jan 14, 2014 10:10PM

Hi Scottr, I solved this by adding a column field in the transaction and deployed a client script which will sum the QOH of all locations and displays in the column field on item field change. function clientPostSourcingInvoice(type, name) { if(name == 'item' && type == 'item') { var itemID =…

in Total Available - Transaction Column Comment by pradeep.r.s Jan 9, 2014 1:35AM

Setup >> Import/ Export >> View CSV Import Status. then there will be the list of things u imported. Click on 'CSV Response' on right side of the list then you can save the excel that u imported in ur local drive.... Regards, Pradeep.

in How to download the original CSV import file in NetSuite? Comment by pradeep.r.s Jun 25, 2013 4:56AM

Hi Dbablu, you can do this in beforeload userevent script... create a custbody list field lists sales order no and apply that field in sales order form and use the below code. function userEventBeforeLoad(type, form, request) { if(type=='create') { var id=request.getParameter('memdoc'); if(id==0) { var…

in Capturing the info of the original SO in the new SO when copied Comment by pradeep.r.s Aug 27, 2013 6:45AM

Add some text in ELSE eg. 'No'. CASE WHEN {item.lastpurchaseprice} = 0 THEN 'Yes' ELSE 'No' END

in Simple Formula - what am I missing? Comment by pradeep.r.s Mar 26, 2014 8:37AM

Hi eleran, Simply add "/ {anotherfieldid}" after the case. Case WHEN {transaction.account} like '%6000%' and TO_CHAR({today}, 'YYYY') = TO_CHAR({transaction.trandate}, 'YYYY') then (Case when {transaction.type} in ('Invoice', 'Cash Sale') then {transaction.amount} else 0 end ) else 0 end / {anotherfieldid}

in Saved Search help needed Comment by pradeep.r.s Mar 28, 2014 1:29AM

Hey man add company in event 'related records' tab.. then its showing in report. Note: If the above fails add the attendees.

in Sales Activity by Sales REP Comment by pradeep.r.s Jun 24, 2013 5:54AM

Last try Vj..... add company in attendees then change the event date to yesterday.....

in Sales Activity by Sales REP Comment by pradeep.r.s Jun 24, 2013 11:51PM

Hi Vj, If u add company in attendees then only its showing in report. No need to add in 'related records' tab. Kindly check this.

in Sales Activity by Sales REP Comment by pradeep.r.s Jun 24, 2013 6:54AM

Have u selected sales role field value as Sales rep in Employee Record >> Human Resources Subtab???

in Sales Activity by Sales REP Comment by pradeep.r.s Jun 24, 2013 3:24AM

Hi Kent, Have you installed the bundle "SuiteLabs File Drag and Drop BETA" id-41309

in Drag and Drop issues oin 2014.1 Comment by pradeep.r.s Apr 15, 2014 6:58AM

Check whether the suitelet script deployment status is released and it is released to your role or employee. If the script deployment status is in testing or not released to roles and employees this error will occur.

in Suitelet Call Externally Comment by pradeep.r.s Jan 23, 2014 10:42PM

Hi Jarrod, Could you share the formula. so that i can check.

in Trouble With Saved Search Comment by pradeep.r.s Jan 3, 2014 3:44AM

Hi Jarrod, Whether the custom field you created was a body field or column field? you can get reference of that field in saved search as field name(custom).

in Trouble With Saved Search Comment by pradeep.r.s Jan 2, 2014 1:46AM

Hi Josh, U can deploy User event script Beforeload function to disable amount field in SO line. function userEventBeforeLoad(type, form, request) { if(type=='create') { form.getSubList('item').getField('amount').setDisplayType('disabled'); } } _____________ Pradeep

in How to make the Amount field on SO not editable? Comment by pradeep.r.s Nov 8, 2013 12:17AM

Hi Josh, U can deploy an user event script beforeload function to disable the amount field. function userEventBeforeLoad(type, form, request) { if(type=='create') { form.getSubList('item').getField('amount').setDisplayType('disabled'); } } ____________ Pradeep R

in How to make the Amount field on SO not editable? Comment by pradeep.r.s Nov 8, 2013 12:15AM

Hi josh, 1. Copy the code in notepad, save as to anyname.js in to desktop. 2. Go To, SetUp>> Customization>> Scripts >> New .It will list the type, click on "user event". 3. Enter name for ur script. click on script file list field in scripts subtab >> new. A window pops up, enter the anyname.js in file name field and…

in How to make the Amount field on SO not editable? Comment by pradeep.r.s Nov 8, 2013 2:22AM

Thanks a lot Tristan.... I will try ur code... _____________ Pradeep.

in Reading Suitelet CSV File upload Comment by pradeep.r.s Aug 12, 2013 7:39AM

Hi tmargot, I don't know how to read the excel column and rows after decoding excel file using the above function. I just added three columns and 2 rows in excel and uploaded in file cabinet. ___________ Pradeep

in Reading Suitelet CSV File upload Comment by pradeep.r.s Aug 12, 2013 7:11AM

Hi, I tried the same code im getting symbols. Could someone help me out. __________ Pradeep

in Reading Suitelet CSV File upload Comment by pradeep.r.s Aug 7, 2013 11:55PM

pradeep.r.s Bronze Medal

Comments