Search code examples
mapreducenetsuitesuitescriptsuitescript2.0

Unable to set Inventory Status for an Inventory Adjustment record using Suitescript 2.x


I am trying to create Inventory Adjustments from another record. I am successfully able to copy the inventory number, bin, and quantity, however I can't seem to capture the inventory status.

{
  {
    invAdjDetail.setCurrentSublistValue({
      sublistId: "inventoryassignment",
      fieldId: "toinventorystatus",
      value: invStatus,
    });

    invAdjDetail.setCurrentSublistValue({
      sublistId: "inventoryassignment",
      fieldId: "status",
      value: invStatus,
    });

    invAdjDetail.setCurrentSublistValue({
      sublistId: "inventoryassignment",
      fieldId: "inventorystatus",
      value: invStatus,
    });

    invAdjDetail.setCurrentSublistValue({
      sublistId: "inventoryassignment",
      fieldId: "binnumber",
      value: invBin,
    });

    invAdjDetail.setCurrentSublistValue({
      sublistId: "inventoryassignment",
      fieldId: "quantity",
      value: -1 * invQty,
    });

    invAdjDetail.commitLine({ sublistId: "inventoryassignment" });
  }
}

invAdj.commitLine({ sublistId: "inventory" });

enter image description here Am I doing something incorrectly? I passed in a few fields in case the record browser was somehow not right, but none of them seem to work.

I have tried setting the inventory status field as

  • inventorystatus => from NS record browser

  • toinventorystatus => from NS record browser

  • status => Trying it out


Solution

  • I managed to fix it, I had to pass the inventory status in after I passed in the negative quantity.