Create NetSuite vendor bills from Paige with SuiteScript

/**
 * @NApiVersion 2.1
 * @NScriptType ScheduledScript
 */
define(['N/sftp', 'N/file', 'N/record', 'N/search', 'N/runtime', 'N/log'],
  (sftp, file, record, search, runtime, log) => {

  const HOST = 'your.sftp.host';
  const USER = 'paige-sftp';
  const DIR = '/paige/invoices';
  const HOST_KEY = 'AAAAB3NzaC1yc2E...';           // from ssh-keyscan
  const FOLDER_ID = 1234;                          // File Cabinet folder for invoice PDFs
  const EXPENSE_ACCOUNT_ID = 567;                  // internal ID of your AP expense account

  const execute = () => {
    const pwdGuid = runtime.getCurrentScript().getParameter({ name: 'custscript_paige_pw_guid' });
    const conn = sftp.createConnection({ username: USER, passwordGuid: pwdGuid, url: HOST, hostKey: HOST_KEY, directory: DIR });

    const listing = conn.list({ path: '.' });
    for (const entry of listing) {
      if (entry.directory || !entry.name.endsWith('.json')) continue;
      try {
        processOne(conn, entry.name);
      } catch (e) {
        log.error({ title: 'Paige import failed: ' + entry.name, details: e });
      }
    }
  };

  const processOne = (conn, jsonName) => {
    const jsonFile = conn.download({ directory: '.', filename: jsonName });
    const doc = JSON.parse(jsonFile.getContents());
    const f = doc.fields;
    const pdfName = doc.metadata.pdf_file;

    // 1. Find the vendor by name (create it, or fail loudly, per your policy).
    const vendorId = findVendor(f['Vendor Name']);

    // 2. Create the vendor bill.
    const bill = record.create({ type: record.Type.VENDOR_BILL, isDynamic: true });
    bill.setValue({ fieldId: 'entity', value: vendorId });
    bill.setValue({ fieldId: 'tranid', value: f['Invoice Number'] });
    bill.setValue({ fieldId: 'trandate', value: parseDate(f['Invoice Date']) });
    if (f['Due Date']) bill.setValue({ fieldId: 'duedate', value: parseDate(f['Due Date']) });
    bill.selectNewLine({ sublistId: 'expense' });
    bill.setCurrentSublistValue({ sublistId: 'expense', fieldId: 'account', value: EXPENSE_ACCOUNT_ID });
    bill.setCurrentSublistValue({ sublistId: 'expense', fieldId: 'amount', value: parseAmount(f['Total']) });
    bill.setCurrentSublistValue({ sublistId: 'expense', fieldId: 'memo', value: 'Paige ' + doc.metadata.document_type });
    bill.commitLine({ sublistId: 'expense' });
    const billId = bill.save();

    // 3. Download the PDF into the File Cabinet and attach it to the bill.
    const pdf = conn.download({ directory: '.', filename: pdfName });
    pdf.folder = FOLDER_ID;
    pdf.name = (f['Invoice Number'] || pdfName) + '.pdf';
    const fileId = pdf.save();
    record.attach({ record: { type: 'file', id: fileId }, to: { type: 'vendorbill', id: billId } });

    // 4. Move the processed files aside so they aren't imported twice.
    for (const n of [jsonName, pdfName, jsonName.replace('.json', '.xml'), jsonName.replace('.json', '.csv')]) {
      try { conn.move({ from: n, to: 'processed/' + n }); } catch (e) { /* xml/csv may not matter */ }
    }
  };

  const findVendor = (name) => {
    const res = search.create({ type: search.Type.VENDOR, filters: [['entityid', 'is', name]], columns: ['internalid'] }).run().getRange({ start: 0, end: 1 });
    if (!res.length) throw new Error('Vendor not found: ' + name);
    return res[0].getValue('internalid');
  };
  const parseDate = (s) => new Date(s);                         // adjust for your date format
  const parseAmount = (s) => parseFloat(String(s).replace(/[^0-9.\-]/g, ''));

  return { execute };
});