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)
}
}