NetSuite for light-manufacturing and WMS-heavy businesses.

/**
 * @NApiVersion 2.1
 * @NScriptType UserEventScript
 * @NModuleScope SameAccount
 *
 * On Work Order completion: posts the assembly build and writes the
 * component-to-parent lot linkages so a recall drill can walk the lineage
 * from a bench-test serial back to the receiving event. Paired with a
 * SuiteFlow that re-classifies the lot when its bin moves.
 * Engagement 02 — delivery #3 of #7 (see SOW §2.1).
 */

define(['N/record', 'N/search', 'N/log', 'N/format'], (record, search, log, format) => {
  const WO_REC = record.Type.WORK_ORDER;
  const LOT_LINKAGE = 'customrecord_assembly_lot_linkage';

  const beforeSubmit = (ctx) => {
    if (ctx.type !== ctx.UserEventType.COMPLETE) return;
    const wo = ctx.newRecord;
    const woId = wo.id;
    const parentLot = wo.getValue('custbody_wo_output_lot');
    if (!parentLot) return;

    const components = search.create({
      type: 'workordercomponent',
      filters: [['workorder', 'is', woId]],
      columns: [
        { name: 'componentname' },
        { name: 'componentlot' },
        { name: 'quantity' },
      ],
    }).run().each((row) => {
      const childLot = row.getValue({ name: 'componentlot' });
      if (!childLot) return true;
      const linkage = record.create({ type: LOT_LINKAGE, isDynamic: true });
      linkage.setValue('custrecord_link_parent_lot', parentLot);
      linkage.setValue('custrecord_link_child_lot', childLot);
      linkage.setValue('custrecord_link_wo', woId);
      linkage.setValue('custrecord_link_quantity', row.getValue({ name: 'quantity' }));
      linkage.setValue('custrecord_link_posted_at', format.formatValue({ value: new Date(), type: format.Type.DATETIME }));
      linkage.save();
      return true;
    });

    log.audit('wo:lot-linkage', { woId, parentLot });
  };

  return { beforeSubmit };
});

scripts/mfg/wocomplete-lot-linkage.ts from a recent light-manufacturing go-live — peer-reviewed, deployable, in your repo at handoff. Paired with a SuiteFlow that re-classifies a lot on bin move (raw → WIP → finished → RMA), so the WMS lane and the GL lane read the same lineage. The recall drill is a saved-search query, not a hand-built SQL.