Hi All, I am trying to update lease record for sta...
# suitescript
s
Hi All, I am trying to update lease record for start date and amount via script but in the script log i am getting the error that module does not exist. Please help.
c
Not enough information. Share your code
s
function updateLease() { var search = nlapiLoadSearch('customtransaction_fam_leaseproposal', 'customsearch_find_pending_lease_payment'); var searchResultsSo = search.runSearch(); if (searchResultsSo && searchResultsSo != null) { var SearchfromIndex = 0; var SearchtoIndex = 1000; var resultSet; do { resultSet = searchResultsSo.getResults(SearchfromIndex, SearchfromIndex + SearchtoIndex); SearchfromIndex = SearchfromIndex + SearchtoIndex; for (var so = 0; so < resultSet.length; so++) { var paymentAmount; var externalId = resultSet[so].getValue('externalid'); var id = resultSet[so].getValue('internalid'); var leaseTerm = resultSet[so].getValue('custbody_fam_lp_term'); var leaseStartDate = resultSet[so].getValue('custbody_fam_lp_startdate'); if (isNotNull(externalId)) { var paymentDetailSearch = nlapiSearchRecord("customrecord_lease_payment_details", null, [ ["custrecord_lease_external_id", "is", externalId] ], [ new nlobjSearchColumn("custrecord_payment_amount", null, null) ] ); if (paymentDetailSearch && paymentDetailSearch.length > 0) { paymentAmount = paymentDetailSearch[0].getValue('custrecord_payment_amount'); } } // // create lease payment // nlapiSubmitField('customtransaction_fam_leaseproposal', id, ['custpage_auto_startdate', 'custpage_auto_amount'], [leaseStartDate, paymentAmount]); } } while (resultSet.length > 0) } }
It is resolved.