Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Accessing Customer Fields from Sales Order Suitelet
I am trying to create a script to generate PDF document from SO. I had no issues making it work as long as I use fields and sublists from sales order. But it seems I cannot get any values from linked customer record. I followed these steps:
1. Created suitelet that generates PDF file using nlapiXMLToPDF
2. Created client script to call on suitelet and pass internal id
3. created user event script to create a button on SO form
</span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'">function printLabels(request, response)</span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'">{</span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'">//retrieve the record id passed to the Suitelet</span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'">var recId = request.getParameter('id');</span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'">//load records</span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'">var recSO = nlapiLoadRecord('salesorder', recId);</span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'">var companyInfo = nlapiLoadConfiguration('companyinformation');</span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'">var recShipAddress = recSO.viewSubrecord('shippingaddress');</span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'">var recBillAddress = recSO.viewSubrecord('billingaddress');</span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'"><strong>var customerId = nlapiGetFieldValue('entity');</strong></span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'">// load the customer record using the internal id acquired above</span></span></span> <span style="font-family:'Verdana'"><span style="font-size:'1'"><span style="color:'#000000'"><strong>var customerRec = nlapiLoadRecord('customer', customerId, {recordmode : 'dynamic'}); ------</strong></span></span></span> <span style="color:'#000000'"><span style="font-family:'Verdana'"><span style="font-size:'12px'">