require(["N/record", "N/format"]);
var record = require("N/record");
var format = require("N/format");
const adjustmentRec = record.create({
    type: 'inventoryworksheet',
    isDynamic: true,
});

adjustmentRec.setValue({
    fieldId: 'account',
    value: 2976,
});

adjustmentRec.setValue({
    fieldId: 'location',
    value: 4,
});

adjustmentRec.setValue({
    fieldId: 'lastinday',
    value: 'T',
});

const formattedDate = format.parse({
    value: "2/13/2025",
    type: format.Type.DATE
});

adjustmentRec.setValue({
    fieldId: 'trandate',
    value: formattedDate,
});

const inventorySublistID = 'invt';

adjustmentRec.selectNewLine({
    sublistId: inventorySublistID
});

adjustmentRec.setCurrentSublistValue({
    sublistId: inventorySublistID,
    fieldId: 'invtid',
    value: '3010'
});

adjustmentRec.setCurrentSublistValue({
    sublistId: inventorySublistID,
    fieldId: 'invtnewqty',
    value: '7000'
});

adjustmentRec.setCurrentSublistValue({
    sublistId: inventorySublistID,
    fieldId: 'invtnewvalue',
    value: '9000'
});

adjustmentRec.commitLine({
    sublistId: inventorySublistID
});

adjustmentRec.save({
    ignoreMandatoryFields: true
});

var x = 0;