Copy fields from a transaction record to a payment in NetSuite. Built by http://SuiteSync.io/

netsuite_copy_transaction_fields_to_payment.js

/*
Author: <mike@suitesync.io>
Description: Copies department, class, and location from the order (SalesOrder, Invoice)
             to the transaction (customer deposit, customer refund, and customer payment).
             This can be customized to copy custom

Installation:
  1. https://system.sandbox.netsuite.com/app/common/scripting/uploadScriptFile.nl
  2. User Event
  3. Name: Copy Order Fields to Transaction
  4. ID: _suitesync_copy_invoice_fields
  5. After Submit: afterSubmit
  6. Deployments: CustomerDeposit on Create, or CustomerPayment on Create
*/

// Utils
// https://gist.github.com/iloveitaly/db7d532e772b67f5b81d0199d094301f

function log(msg) {
  nlapiLogExecution('DEBUG', msg);
}

function error(msg) {
  nlapiLogExecution('ERROR', msg);
}

function isEmpty(obj) {
  return obj === undefined || obj === null || obj === "";
}

function afterSubmit() {
  var recordType = nlapiGetRecordType();
  var recordId = nlapiGetRecordId();

  var locationsEnabled = nlapiGetContext().getFeature('LOCATIONS');
  var classesEnabled = nlapiGetContext().getFeature('CLASSES');
  var departmentsEnabled = nlapiGetContext().getFeature('DEPARTMENTS');

  var currentDepartment = null;
  var currentClass = null;
  var currentLocation = null;

  if(departmentsEnabled) {
    currentDepartment = nlapiGetFieldValue('department');
  }

  if(classesEnabled) {
    currentClass = nlapiGetFieldValue('class');
  }

  if(locationsEnabled) {
    currentLocation = nlapiGetFieldValue('location');
  }

  if(!isEmpty(currentDepartment) && !isEmpty(currentLocation) && !isEmpty(currentClass)) {
    log("department and location are already set, skipping");
    return;
  }

  var applyingTransactionId = null;
  var applyingTransactionType = null;

  if(recordType == 'customerdeposit') {
    var salesOrderId = nlapiGetFieldValue('salesorder');

    if(isEmpty(salesOrderId)) {
      log("customer deposit is not linked with sales order");
      return
    }

    applyingTransactionId = salesOrderId;
    applyingTransactionType = 'salesorder'
  } else {
    if(nlapiGetLineItemCount('apply') > 1) {
      log("contains more than one applying transaction, skipping");
      return;
    }

    applyingTransactionId = nlapiGetLineItemValue('apply', 'doc', 1);
    applyingTransactionType = nlapiGetLineItemValue('apply', 'type', 1);
  }

  if(departmentsEnabled && isEmpty(currentDepartment)) {
    var departmentId = nlapiLookupField(applyingTransactionType, applyingTransactionId, 'department', false);

    if(!isEmpty(departmentId)) {
      nlapiSubmitField(recordType, recordId, 'department', departmentId);
    }
  }

  if(classesEnabled && isEmpty(currentClass)) {
    var classId = nlapiLookupField(applyingTransactionType, applyingTransactionId, 'class', false);

    if(!isEmpty(classId)) {
      nlapiSubmitField(recordType, recordId, 'class', classId);
    }
  }

  if(locationsEnabled && isEmpty(currentLocation)) {
    var locationId = nlapiLookupField(applyingTransactionType, applyingTransactionId, 'location', false);

    if(!isEmpty(locationId)) {
      nlapiSubmitField(recordType, recordId, 'location', departmentId);
    }
  }

  // NOTE here you can copy custom information from the invoice to the CustomerPayment
}

if(nlapiGetContext().getExecutionContext() == 'debugger') {

}