Automate Cash Sale after Fulfillment

The code below can be used to automate the process of creating cash sale (bill credit card) once the order has been fulfilled.

Deploy the code as an After Record Submit even for an Item Fulfillment:

function credit(){/* Create a Transaction saved search that would pull up all the sales orders via Script as show below. Filters and Columns refer to Criteria and Results */var soInfo = nlapiSearchRecord('salesorder', null,// Select Criteria and Results[ new nlobjSearchFilter('internalid', null, 'is', nlapiGetFieldValue('createdfrom')), new nlobjSearchFilter('mainline', null, 'is', 'T') ], [ new nlobjSearchColumn('statusref'), new nlobjSearchColumn('terms'), new nlobjSearchColumn('tranid') ]);// if the status of sales order is Fulfilled then transform record to a cash saleif('pendingBilling' == (soInfo ? soInfo[0].getValue('statusref') : '-na-')){ // then auto bill, place the code in try/catch block to handle errors try{// Log the terms valuenlapiLogExecution('DEBUG', 'auto billing sales order with terms: '+ soInfo[0].getValue('terms'));// Transform Record to a Cash Sale and submit it var billRec = nlapiTransformRecord('salesorder', nlapiGetFieldValue('createdfrom'), (soInfo[0].getValue('terms')) ? 'invoice' : 'cashsale' ); nlapiSubmitRecord(billRec); }catch(e){//if any error occurs it will be caught here and logged with the stack trace nlapiLogExecution("ERROR", "error billing order: "+ soInfo[0].getValue('tranid'), (e.message || e.toString()) + (e.getStackTrace ? '\n\n'+ e.getStackTrace().join('\n') : ''));// This is optional, to create note which will store the error information on the transaction record var n = nlapiCreateRecord('note'); n.setFieldValue('transaction', nlapiGetFieldValue('createdfrom')); n.setFieldValue('title', "Billing Issue:"+ (e.message || e.toString())); n.setFieldValue('note', "Error billing order "+ soInfo[0].getValue('tranid') +"\n\n"+ (e.message || e.toString()) + (e.getStackTrace ? '\n\n'+ e.getStackTrace().join('\n') : '')); nlapiSubmitRecord(n); }}}

Disclaimer: Thesample code described herein is provided on an "as is" basis, withoutwarranty of any kind, to the fullest extent permitted by law. NetSuite Inc.does not warrant or guarantee the individual success developers may have inimplementing the sample code on their development platforms or in using theirown Web server configurations.

NetSuite Inc.does not warrant, guarantee or make any representations regarding the use,results of use, accuracy, timeliness or completeness of any data or informationrelating to the sample code. NetSuite Inc. disclaims all warranties, express orimplied, and in particular, disclaims all warranties of merchantability,fitness for a particular purpose, and warranties related to the code, or anyservice or software related thereto.

NetSuite Inc.shall not be liable for any direct, indirect or consequential damages or costsof any type arising out of any action taken by you or others related to thesample code.