Author: Aswathy Viswanathan

How to get the search result in Suitescript 1.0 with join

var inventorybalanceSearch = nlapiSearchRecord(“inventorybalance”,null, [ [“item.type”,”anyof”,”Assembly”], “AND”, [“binnumber”,”anyof”,”8521″], ], [ new nlobjSearchColumn(“item”,null,”GROUP”).setSort(false), new nlobjSearchColumn(“name”,”inventoryStatus”,”GROUP”), new nlobjSearchColumn(“inventorynumber”,”inventoryNumber”,”GROUP”) ] ); var result = inventorybalanceSearch[0]; var columns = result.getAllColumns(); var columnLen = columns.length; nlapiLogExecution(‘DEBUG’,’result’, result) nlapiLogExecution(‘DEBUG’,’columnLen’, columnLen) for (i = 0; i <= columnLen; i++) { var column = columns[i]; var value = result.getValue(column); resultArray.push(value) // nlapiLogExecution(‘DEBUG’, ‘resultArray’,… Continue reading How to get the search result in Suitescript 1.0 with join

Email Transaction Forms in a PDF or HTML format on Selected Customers Only

Email Transaction Forms in a PDF or HTML format on Selected Customers Only
There is a user setting to be able to email transaction forms in HTML or PDF format.

This can be found under Home > Set Preferences > Transactions tab > Printing portlet > Transaction Email Attachment Format > we may choose to either send it in HTML or PDF format.

There is also an option to choose a specific setting for selected customers to email transaction forms in either PDF or HTML.

This can be done in the Customer record > Preferences tab > Email Preference field. We can select either HTML or PDF as its preferred email format. This overrides the user setting. When the Email Preference is set to Default, NetSuite uses what is set in the user setting.

How to resolve the error ” Failed to export Matrix Item#17263 | Matrix options missing for following Item(s): Item SGLBLU Options (additionalsize), Item SGLNVY Options (additionalsize), Item SGLPRP Options (additionalsize), Item LSGBLU Options (additionalsize) “

Failed to export Matrix Item#17263 | Matrix options missing for following Item(s): Item SGLBLU Options (additionalsize), Item SGLNVY Options (additionalsize), Item SGLPRP Options (additionalsize), Item LSGBLU Options (additionalsize), Item LSGNVY Options (additionalsize), Item LSGPRP Options (additionalsize), Item KSGBLU Options (additionalsize), Item KSGNVY Options (additionalsize), Item KSGPRP Options (additionalsize)