Auto-populate Tax Code when creating an invoice from Transactions > Customers> Invoice Billable Customers

When an Invoice is loaded for any of items under Billable Item or Billable Expenses Or Billable Time Sublist populate the line item to have a required tax code. Please refer to the sample code below (Client Script deployed on an Invoice Record triggered on Page Init)

function bill_invoice(){ var form = nlapiGetFieldValue('customform'); alert(form); if(form=='116') //internal id of the required form on which the script should execute { var count = nlapiGetLineItemCount('expcost'); //get no of lines in Billable Expenses List alert('Billable Expense' + count); var count1 = nlapiGetLineItemCount('itemcost'); //get no of lines in Billable Items alert('BillableItem' + count1); var count2 = nlapiGetLineItemCount('time'); //get no of lines in Billable Time alert('Time' + count2); if( count != null || count1 != null || count2 !=null) {// this loop sets tax code for Billable Items list, perform similar actions to set values in other two lists as needed for (var i=1; i<=count1; i++) { nlapiSelectLineItem('itemcost',i); nlapiSetCurrentLineItemValue('itemcost','taxcode','-7'); // -7 seems to be internal id for 'not taxable', check the internal id of your value being set nlapiCommitLineItem('itemcost'); } } }}

Disclaimer: The sample code described herein is provided on an"as is" basis, without warranty of any kind, to the fullest extentpermitted by law. NetSuite Inc. does not warrant or guarantee the individualsuccess developers may have in implementing the sample code on theirdevelopment platforms or in using their own 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 liablefor any direct, indirect or consequential damages or costs of any type arisingout of any action taken by you or others related to the sample code.