How do you create a Netsuite invoice with multiple line
Hi, i am new in this filed, getting error ::
{“type”:”error.SuiteScriptError”,”name”:”UNABLE_TO_SAVE_THE_TRANSACTION_DUE_TO_AN_ERROR_BEING_REPORTED_BY_THE_TAX_CALCULATION_ENGINE_1″,”message”:”Unable to save the transaction due to an error being reported by the tax calculation engine: A User Error Has Occurred: Duplicate input lines detected. Tax Details Reference: ”.”,”stack”:[“Error\n at RecordInvoker.save (suitescript/resources/javascript/record/serverRecordService.js:371:13)\n at NetSuiteObject.thenableFunction() (suitescript/resources/javascript/record/proxy.js:115:24)\n at inv_finalized (/SuiteScripts/flx_saas_inv_sheduler.js:286:51)\n at saasInvAddOrUpdate (/SuiteScripts/flx_saas_inv_sheduler.js:145:39)\n at Object.execute (/SuiteScripts/flx_saas_inv_sheduler.js:122:13)”],”cause”:{“type”:”internal error”,”code”:”UNABLE_TO_SAVE_THE_TRANSACTION_DUE_TO_AN_ERROR_BEING_REPORTED_BY_THE_TAX_CALCULATION_ENGINE_1″,”details”:”Unable to save the transaction due to an error being reported by the tax calculation engine: A User Error Has Occurred: Duplicate input lines detected. Tax Details Reference: ”.”,”userEvent”:null,”stackTrace”:[“Error\n at RecordInvoker.save (suitescript/resources/javascript/record/serverRecordService.js:371:13)\n at NetSuiteObject.thenableFunction() (suitescript/resources/javascript/record/proxy.js:115:24)\n at inv_finalized (/SuiteScripts/flx_saas_inv_sheduler.js:286:51)\n at saasInvAddOrUpdate (/SuiteScripts/flx_saas_inv_sheduler.js:145:39)\n at Object.execute (/SuiteScripts/flx_saas_inv_sheduler.js:122:13)”],”notifyOff”:false},”id”:””,”notifyOff”:false,”userFacing”:true}
My code :
if( itemObj!= false && itemObj!=” && itemObj!=null ){
letitemObjLength=itemObj.length;
lettest=0;
//for( let itemIndex=0; itemIndex<itemObjLength; itemIndex++){//not wrking
for( letitemIndex=itemObjLength; itemIndex>0; itemIndex–){
//for( let itemIndex=itemObjLength-1; itemIndex>=0; itemIndex–){
letitemIndexValue=itemIndex-1;
log.debug(“itemObj[itemIndex-1].item_intrnl_id”,itemIndexValue+”<=>”+itemIndex+”<=>”+itemObj[itemIndexValue].item_intrnl_id);//manoj
if( itemIndex == itemObjLength ){
log.debug(“Equal”,itemIndexValue+ “test: “+test);
inv_rec.selectNewLine({sublistId:’item’});
}else{
log.debug(“Not Equal”,itemIndexValue+ “test: “+test);
//inv_rec.selectLine({sublistId:’item’,line:itemIndexValue});
inv_rec.selectLine({sublistId:’item’,line:test});
//inv_rec.insertLine({sublistId: “item”,line: test});
//inv_rec.insertLine({sublistId: “item”,line: itemIndexValue});
}
test=test+1;
inv_rec.setCurrentSublistValue({
sublistId:’item’,fieldId:’item’,
value:itemObj[itemIndexValue].item_intrnl_id,
ignoreFieldChange: true,forceSyncSourcing: true
});
inv_rec.setCurrentSublistValue({
sublistId: ‘item’,fieldId: ‘quantity’,
value:itemObj[itemIndexValue].itm_quantity,
ignoreFieldChange: true,forceSyncSourcing: true
});
inv_rec.setCurrentSublistValue({
sublistId: ‘item’,fieldId: ‘rate’,
value:itemObj[itemIndexValue].unit_amount,
ignoreFieldChange: true,forceSyncSourcing: true
});
inv_rec.setCurrentSublistValue({
sublistId: ‘item’,fieldId: ‘amount’,
value:itemObj[itemIndexValue].tot_amount,
ignoreFieldChange: true,forceSyncSourcing: true
});
inv_rec.setCurrentSublistValue({
sublistId: ‘item’,fieldId: ‘grossamt’,
value:itemObj[itemIndexValue].tot_amount,
ignoreFieldChange: true,forceSyncSourcing: true
});
inv_rec.setCurrentSublistValue({
sublistId: ‘item’,fieldId: ‘description’,
value:itemObj[itemIndexValue].item_description,
ignoreFieldChange: true,forceSyncSourcing: true
});
inv_rec.commitLine({ sublistId: ‘item’});
//inv_tax_linename=itemObj[itemIndex-1].item_disp_name
}//for loop closed
}//if closed
Hi,
You could try to add information at the line level regarding the tax (tax code, tax rate).
Can you please elaborate little bit more.
